# HG changeset patch
# User IBBoard <dev@ibboard.co.uk>
# Date 1409393108 0
# Node ID f2056be70cb88bd1dc2342656e74063730d96f37
# Parent  894e6287926fc7a57adf8f91acc8e998d9bbfc26
Increase memory a bit more for optimisation

diff -r 894e6287926f -r f2056be70cb8 modules/website/manifests/mysql.pp
--- 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/']