Mercurial > repos > other > Puppet

changeset 2:b0a6f4b93e10

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Start optimising MySQL based on "MySQLTuner.pl" script
author IBBoard <dev@ibboard.co.uk>
date Wed, 27 Aug 2014 12:57:19 +0000
parents f9876f71f1a3
children ea71652452e9
files modules/website/manifests/mysql.pp
diffstat 1 files changed, 11 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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)