From 2327b354b21b970e31f931305bdefba78d55cc08 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Oliver=20B=C3=B6ttcher?= Date: Thu, 1 Mar 2018 13:17:45 +0100 Subject: [PATCH] Gruenderwoche - mysql perf tuning --- customer/bmwi-gruenderwoche/production.yaml | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/customer/bmwi-gruenderwoche/production.yaml b/customer/bmwi-gruenderwoche/production.yaml index b7687f59..5ff83b54 100644 --- a/customer/bmwi-gruenderwoche/production.yaml +++ b/customer/bmwi-gruenderwoche/production.yaml @@ -10,6 +10,19 @@ infra::profile::mysql_server::databases: php::dev: true php::pear: true +mysql::server::override_options: + mysqld: + innodb_buffer_pool_size: 2G + innodb_buffer_pool_instances: 1 + thread_pool_size: 4 + innodb_log_buffer_size: 64M + query_cache_type: 0 + default-storage-engine: INNODB + innodb_file_per_table: 1 + table_open_cache: 512 + innodb_log_file_size: 512M + performance_schema: ON + infra::profile::apache::htdigest: server: www: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAoTIYPVLxCsFFZV0+/1WZ5AvEJwIkT9EgEFmqpz5Q7RGZn385ZvJwI4IJKwMjVzny6NUbnPlw0f5yiTAK2TLHKYNtVamTopFYt2E8YEG6jK82w5ZHakZ/Fa6RfsccoIDPty6z7MM64wuNpmpPxLzSg2UXYzbkKFd4e6NnrUh5szbctc1db6NnRIlKEm3iKe7FFwF3blFBBZhY8ms6M6Uj9gh9xK7c5QA0sjUZd/0I+foQvmIcv7aPJabiQSOhLkTr3hm7a8VyilC2AmpfP98Vt3vJsWxJL4a7tvo0c+k6aS0ya8gxy984fOAGjZhQ1mD0XIxbc3klS9l6IJ2d6cNnrDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCFr69MvCBcz4vbKTcJV1mggCDbDDdruL+0FBBIGmtjejj0L6q02F9+/Qq49MBjkSaIjg==] -- 2.39.5