From 94a2bb099c2a747f64f3c0d675704ff4a6471e85 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Fri, 30 Dec 2022 18:38:57 +0000 Subject: [PATCH] Tune mysql for matomo on smaug --- roles/matomo.rb | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) 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" } } } -- 2.39.5