From c0c1eb432ab2e5ab007b9441c10e3124c720bcf7 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Fri, 30 Dec 2022 22:16:24 +0000 Subject: [PATCH] Tune mysql for matomo on smaug --- roles/matomo.rb | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/roles/matomo.rb b/roles/matomo.rb index 1cd95a196..f171e437a 100644 --- a/roles/matomo.rb +++ b/roles/matomo.rb @@ -16,12 +16,13 @@ default_attributes( :mysql => { :settings => { :mysqld => { - :innodb_buffer_pool_instances => "64", - :innodb_buffer_pool_size => "64GB", + :innodb_buffer_pool_instances => "128", + :innodb_buffer_pool_size => "128GB", :innodb_flush_log_at_trx_commit => "2", - :innodb_log_file_size => "8GB", - :join_buffer_size => "256KB", - :key_buffer_size => "0" + :innodb_log_file_size => "16GB", + :join_buffer_size => "1GB", + :key_buffer_size => "0", + :max_connections => "64" } } } -- 2.39.5