diff options
| -rw-r--r-- | manifests/init.pp | 21 |
1 files changed, 19 insertions, 2 deletions
diff --git a/manifests/init.pp b/manifests/init.pp index 31361bf..0f0f571 100644 --- a/manifests/init.pp +++ b/manifests/init.pp @@ -14,9 +14,9 @@ class database { content => "mysql soft nofile 24000\nmysql hard nofile 32000\n", } - # Avoid Errcode: 24 + # TODO: remove in the future file { '/etc/mysql/conf.d/mysqld_open_files_limit.cnf': - ensure => present, + ensure => absent, owner => root, group => root, mode => 0644, @@ -30,4 +30,21 @@ class database { sqldump => true, sqldumpoptions => '--lock-tables --complete-insert --add-drop-table --quick --quote-names --single-transaction', } + + # + # Tuning + # + + # Avoid Errcode: 24 + database::config { 'open-files-limit': + value => '500000', + } + + database::config { + 'query_cache_size': value => '32M'; + 'join_buffer_size': value => '256K'; + 'tmp_table_size': value => '32M'; + 'max_heap_table_size': value => '32M'; + 'innodb_buffer_pool_size': value => '256M'; + } } |