From: Tom Hughes <tom@compton.nu>
Date: Fri, 30 Dec 2022 18:38:57 +0000 (+0000)
Subject: Tune mysql for matomo on smaug
X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/94a2bb099c2a747f64f3c0d675704ff4a6471e85?ds=sidebyside;hp=e043d3c35ca1f156a2066128c57233869235a822

Tune mysql for matomo on smaug
---

diff --git a/roles/matomo.rb b/roles/matomo.rb
index b3ac24581..4c99f7a79 100644
--- a/roles/matomo.rb
+++ b/roles/matomo.rb
@@ -16,9 +16,11 @@ default_attributes(
   :mysql => {
     :settings => {
       :mysqld => {
-        :innodb_buffer_pool_instances => "8",
-        :innodb_buffer_pool_size => "16GB",
-        :innodb_flush_log_at_trx_commit => "2"
+        :innodb_buffer_pool_instances => "16",
+        :innodb_buffer_pool_size => "64GB",
+        :innodb_flush_log_at_trx_commit => "2",
+        :innodb_log_file_size => "2GB",
+        :key_buffer_size => "0"
       }
     }
   }