From 8e648b520141e54bebb0126947d1145760e079d0 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Fri, 30 Dec 2022 18:42:20 +0000
Subject: [PATCH] Tune mysql for matomo on smaug

---
 roles/matomo.rb | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/roles/matomo.rb b/roles/matomo.rb
index 4c99f7a79..3a3836fc3 100644
--- a/roles/matomo.rb
+++ b/roles/matomo.rb
@@ -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"
       }
     }
-- 
2.39.5