Mercurial > repos > other > Puppet

changeset 51:62ae90b291b3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Reduce table cache because of possible odd performance issues and increase query cache
author IBBoard <dev@ibboard.co.uk>
date Sat, 08 Aug 2015 15:20:17 +0000
parents 9c0ed2404c59
children be1e9773a12c
files modules/website/manifests/mysql.pp
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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',
       }
     },