From: Tom Hughes Date: Fri, 30 Dec 2022 22:16:24 +0000 (+0000) Subject: Tune mysql for matomo on smaug X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/c0c1eb432ab2e5ab007b9441c10e3124c720bcf7?ds=sidebyside Tune mysql for matomo on smaug --- 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" } } }