]> git.openstreetmap.org Git - chef.git/commitdiff
Tune mysql for matomo on smaug
authorTom Hughes <tom@compton.nu>
Fri, 30 Dec 2022 18:42:20 +0000 (18:42 +0000)
committerTom Hughes <tom@compton.nu>
Fri, 30 Dec 2022 18:42:20 +0000 (18:42 +0000)
roles/matomo.rb

index 4c99f7a795f6c4fca49c3c01dff719f5546bd30d..3a3836fc3c8d60815058b454dc68444655d00462 100644 (file)
@@ -16,10 +16,10 @@ default_attributes(
   :mysql => {
     :settings => {
       :mysqld => {
-        :innodb_buffer_pool_instances => "16",
+        :innodb_buffer_pool_instances => "64",
         :innodb_buffer_pool_size => "64GB",
         :innodb_flush_log_at_trx_commit => "2",
-        :innodb_log_file_size => "2GB",
+        :innodb_log_file_size => "8GB",
         :key_buffer_size => "0"
       }
     }