From 7cc837a6a3c167559382e1e7cba501c99b38a957 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Oliver=20B=C3=B6ttcher?= Date: Wed, 7 Feb 2018 15:49:58 +0100 Subject: [PATCH] mysqlpp07 - tuning --- customer/pixelpark/mysql-pp07.pixelpark.com.yaml | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/customer/pixelpark/mysql-pp07.pixelpark.com.yaml b/customer/pixelpark/mysql-pp07.pixelpark.com.yaml index ab191958..f6897cd9 100644 --- a/customer/pixelpark/mysql-pp07.pixelpark.com.yaml +++ b/customer/pixelpark/mysql-pp07.pixelpark.com.yaml @@ -13,9 +13,15 @@ mysql::server::override_options: bind-address: '0.0.0.0' innodb_file_per_table: ON max_allowed_packet: 512M - innodb_log_file_size: 100M + innodb_log_file_size: 768M innodb_log_buffer_size: 32M innodb_buffer_pool_size: 6G + innodb_buffer_pool_instances: 6 + query_cache_size: 0 + query_cache_type: 0 + tmp_table_size: 128M + max_heap_table_size: 128M + mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAmhaYOecnhmbu0DsrhkWCg9Y5cb60n6SWq54h/bwukjsVZ5FxTwtnWpqD3Y6fale9OA840FTmh3XrBzVlM/Gc4UxGWXHKqH8S/oEtwgtKGhbk6ZoPquRR7hWdThjXzVNMJPsDkNSQqyz8aHPXuAns088aZMCAfQFZWcyEyZmXHtsg3UIsPSZZDjGhrm0umDgN8kO6EJ0oslQrR+XE+7t1Qx/mKPQswsE/LYLwTvdzSYrQ4HPTdu2MiU6K+Qt61s0lCG9QfIpcQPlO5RHrzILuiZ++by7zfo4aKu4sSrlfa6PPaMgkLTfMo8nELUI1CcgZnNL2WzPWGksvEKEeeCbZFTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAGbHoldhvmNM/pzGYiUUVvgCCttHRovkVMMCgIvhPohyKHo0uNL+UW6E0MU6iu/viS3g==] infra::profile::mysql_server::databases: pdns: -- 2.39.5