Jcrespo has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/337840 )
Change subject: Increase the concurrent threads of large mariadb servers ...................................................................... Increase the concurrent threads of large mariadb servers There is sometimes too much stall, probably due to the thread pool limitations, while large servers can probaby handle up to 64 concurrent connections. It will not improve the performance, but it may reduce the contention for very large servers. Increase the thread pool limit to 64 when the servers have more than 200GB of memory. Bug: T150474 Change-Id: I0921f0afdde8d775de8cde0eac4935427f348f80 --- M modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb 1 file changed, 3 insertions(+), 1 deletion(-) Approvals: jenkins-bot: Verified Jcrespo: Looks good to me, approved diff --git a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb index 4ac2195..a111aea 100644 --- a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb +++ b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb @@ -48,7 +48,9 @@ <% else -%> thread_pool_stall_limit = 100 <% end -%> -<% if Integer(@processorcount) <= 32 -%> +<% if Float(@memorysize.split[0]) > 200.0 -%> +thread_pool_size = 64 +<% elsif Integer(@processorcount) <= 32 -%> thread_pool_size = 32 <% else -%> thread_pool_size = <%= @processorcount %> -- To view, visit https://gerrit.wikimedia.org/r/337840 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I0921f0afdde8d775de8cde0eac4935427f348f80 Gerrit-PatchSet: 3 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> Gerrit-Reviewer: Aaron Schulz <[email protected]> Gerrit-Reviewer: Jcrespo <[email protected]> Gerrit-Reviewer: Marostegui <[email protected]> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
