# HG changeset patch
# User IBBoard <dev@ibboard.co.uk>
# Date 1409144239 0
# Node ID b0a6f4b93e1035d83f1c6c447f41c570f6f39115
# Parent  f9876f71f1a3cd19c928af7b6f44468a77dad782
Start optimising MySQL based on "MySQLTuner.pl" script

diff -r f9876f71f1a3 -r b0a6f4b93e10 modules/website/manifests/mysql.pp
--- a/modules/website/manifests/mysql.pp	Mon Aug 18 18:57:52 2014 +0000
+++ b/modules/website/manifests/mysql.pp	Wed Aug 27 12:57:19 2014 +0000
@@ -15,6 +15,17 @@
   }
   class { 'mysql::server':
     package_name => "mysql${mysqlsuffix}-server",
+    override_options => {
+      'mysqld' => {
+        'query_cache_size' => '32M',
+        'join_buffer_size' => '262144', #256K
+        'tmp_table_size'   => '48M',
+        'max_heap_table_size' => '48M',
+        'table_open_cache' => '500',
+        'slow_query_log'   => '1',
+        'slow_query_log_file' => '/var/log/mysql-slow-query.log',
+      }
+    },
   }
   $username = strip($mysqluser)
   $password = strip($mysqlpassword)