# HG changeset patch # User IBBoard # Date 1439047217 0 # Node ID 62ae90b291b323af9837767b3e2029b5d1f724ba # Parent 9c0ed2404c59796f9a13acae568d1403ac3bf6a7 Reduce table cache because of possible odd performance issues and increase query cache diff -r 9c0ed2404c59 -r 62ae90b291b3 modules/website/manifests/mysql.pp --- a/modules/website/manifests/mysql.pp Sat Aug 08 08:48:06 2015 +0000 +++ b/modules/website/manifests/mysql.pp Sat Aug 08 15:20:17 2015 +0000 @@ -17,11 +17,11 @@ package_name => "mysql${mysqlsuffix}-server", override_options => { 'mysqld' => { - 'query_cache_size' => '32M', + 'query_cache_size' => '64M', 'join_buffer_size' => '524288', #512K 'tmp_table_size' => '64M', 'max_heap_table_size' => '64M', - 'table_open_cache' => '500', + 'table_open_cache' => '64', 'log-queries-not-using-indexes' => '1', } },