Mercurial > repos > other > Puppet

changeset 5:f2056be70cb8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Increase memory a bit more for optimisation
author IBBoard <dev@ibboard.co.uk>
date Sat, 30 Aug 2014 10:05:08 +0000
parents 894e6287926f
children b7c30595c97a
files modules/website/manifests/mysql.pp
diffstat 1 files changed, 4 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/modules/website/manifests/mysql.pp	Wed Aug 27 13:46:07 2014 +0000
+++ b/modules/website/manifests/mysql.pp	Sat Aug 30 10:05:08 2014 +0000
@@ -18,12 +18,13 @@
     override_options => {
       'mysqld' => {
         'query_cache_size' => '32M',
-        'join_buffer_size' => '262144', #256K
-        'tmp_table_size'   => '48M',
-        'max_heap_table_size' => '48M',
+        'join_buffer_size' => '524288', #512K
+        'tmp_table_size'   => '64M',
+        'max_heap_table_size' => '64M',
         'table_open_cache' => '500',
         'slow_query_log'   => '1',
         'slow_query_log_file' => '/var/log/mysql/slow-query.log',
+        'log-queries-not-using-indexes' => '1',
       }
     },
     require => File['/var/log/mysql/']