diff options
| author | Silvio Rhatto <rhatto@riseup.net> | 2014-05-27 17:10:27 -0300 |
|---|---|---|
| committer | Silvio Rhatto <rhatto@riseup.net> | 2014-05-27 17:10:27 -0300 |
| commit | 52d6b9b74a937b8f762f68464a3401f55ae992f6 (patch) | |
| tree | d734e5f7445c79cc3ea6d7c5c806ea007c13dcd2 | |
| parent | cca02a5cc047ea095e3226fb10dce59b867e2460 (diff) | |
| download | puppet-database-52d6b9b74a937b8f762f68464a3401f55ae992f6.tar.gz puppet-database-52d6b9b74a937b8f762f68464a3401f55ae992f6.tar.bz2 | |
Tuning mysql (2)
| -rw-r--r-- | manifests/init.pp | 9 |
1 files 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'; } } |