From 0c41cefc00a99ad24ca5cd62a91cb90cf2fc5ef7 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Oliver=20B=C3=B6ttcher?= Date: Wed, 17 Jan 2018 12:12:40 +0100 Subject: [PATCH] BJE - mysql optim --- .../buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml | 7 +++++++ .../buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml | 7 +++++++ .../test-web-buschjaeger-de.pixelpark.net.yaml | 9 +++++++++ 3 files changed, 23 insertions(+) diff --git a/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml index c343e6b5..2ecbc5fe 100644 --- a/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml @@ -19,3 +19,10 @@ mysql::server::override_options: log-bin: 'binlog' binlog-format: 'MIXED' binlog-ignore-db: 'performance_schema, information_schema' + expire_logs_days: '3' + innodb_file_per_table: '1' + query_cache_size: '0' + query_cache_type: '0' + table_open_cache: '500' + innodb_buffer_pool_size: '1G' + innodb_log_file_size: '256M' diff --git a/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml index 0d925046..689ba333 100644 --- a/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml @@ -19,3 +19,10 @@ mysql::server::override_options: log-bin: 'binlog' binlog-format: 'MIXED' binlog-ignore-db: 'performance_schema, information_schema' + expire_logs_days: '3' + innodb_file_per_table: '1' + query_cache_size: '0' + query_cache_type: '0' + table_open_cache: '500' + innodb_buffer_pool_size: '1G' + innodb_log_file_size: '256M' diff --git a/customer/buschjaeger/test-web-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/test-web-buschjaeger-de.pixelpark.net.yaml index 1121205a..9648ad9a 100644 --- a/customer/buschjaeger/test-web-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/test-web-buschjaeger-de.pixelpark.net.yaml @@ -38,6 +38,15 @@ infra::profile::mysql_server::databases: user: buschjaeger password: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAqAPfjkpxjcB5OcaggCEMoZHgfmgXMVfpG0ND7UBSK8O0nYKGS7Z7CP1SrrRXxU3HmSiwhm0t8BE7j1E4wtkeacvv8rxDN85FE84RtDO08ZYNH48SZ/FUpXbLtAAyuP+wF2ZGBHtjGGYHYDP0XJpACTVgExkN8vyNa8N7Y5OPZwfohbDZQZEo2kY0NXeNnGEPKVgzDQevtlbScWk2ut8xDf0hL0aqa/K+iDqC1OufylB1VLoDEWWKKU8baxwZTVf4f4GfbkF96tqt+RTMfh08Zxlq7UOK1bZNvkKs/ThxsxffmtMhkcBnB8x7L+Ft2+ylK7SBwql+CuwJmE6Xiq0hFDA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCiYj0KHXpkMN7Rn5o+9LC8gBBoSH581Kj/zsC951SN/uis] +mysql::server::override_options: + 'mysqld': + innodb_file_per_table: '1' + query_cache_size: '0' + query_cache_type: '0' + table_open_cache: '500' + innodb_buffer_pool_size: '1G' + innodb_log_file_size: '256M' + infra::profile::apache::htdigest: server: www: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAGDX73w7OdqMbm4JkeBBJVafsYx4OGYDCqfrhzsClhupNMp+cMD7HY3MeUEfgnt4dfjxckX1ZrOaJrswK65FnoCzBCK4rGtYAOhl6ZKbvfIgEQy2dKnie/3C8oc4x30LTKM/c1Tk2YeNdxu5MPFrUhTTiLYPt1vSXG7NJ+zXevKnFS7cWFxVL7B9NuUdZKK3GBgAEp7NBsyNK7/N6gVXAXRYH/nt1/3H4Lb9THFsqa/FD9juCfC09h3liuJpsaF89ViwKT5puccuR4jBdf7wRZfKhFY1UDb+7Y6D0iZ85MKMKmpoeOc/CRXnhQFkfK1wG5i2M32flrVWU9iXAM6+tDzA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCgeAiSxk2sF3Jm+/pCCqDSgBBKvchnMQMHsgMGCOWaJ4ET] -- 2.39.5