From 6351b2795646b0800bb609d84388e805da5a6e48 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Oliver=20B=C3=B6ttcher?= Date: Wed, 30 Mar 2016 10:37:06 +0200 Subject: [PATCH] BMF: mysql performance vars --- customer/bmf/db01-bmf-de.pixelpark.net.yaml | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/customer/bmf/db01-bmf-de.pixelpark.net.yaml b/customer/bmf/db01-bmf-de.pixelpark.net.yaml index eafe4172..2a3e9cc1 100644 --- a/customer/bmf/db01-bmf-de.pixelpark.net.yaml +++ b/customer/bmf/db01-bmf-de.pixelpark.net.yaml @@ -8,6 +8,11 @@ site::additional_classes: mysql::server::override_options: mysqld: innodb_file_per_table: ON + tmp_table_size: 128M + max_heap_table_size: 128M + thread_pool_size: '16' + innodb_buffer_pool_instances: '1' + innodb_buffer_pool_size: 4G mysql::server::backup::backupdir: /var/lib/backup/mysql -- 2.39.5