From 52d6b9b74a937b8f762f68464a3401f55ae992f6 Mon Sep 17 00:00:00 2001 From: Silvio Rhatto Date: Tue, 27 May 2014 17:10:27 -0300 Subject: Tuning mysql (2) --- manifests/init.pp | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/manifests/init.pp b/manifests/init.pp index 0f0f571..f05f2fe 100644 --- a/manifests/init.pp +++ b/manifests/init.pp @@ -41,10 +41,13 @@ class database { } database::config { - 'query_cache_size': value => '32M'; + 'query_cache_size': value => '64M'; + 'query_cache_limit': value => '2M'; 'join_buffer_size': value => '256K'; - 'tmp_table_size': value => '32M'; - 'max_heap_table_size': value => '32M'; + 'key_buffer_size': value => '32M'; + 'tmp_table_size': value => '64M'; + 'max_heap_table_size': value => '64M'; 'innodb_buffer_pool_size': value => '256M'; + 'table_cache': value => '800'; } } -- cgit v1.2.3