Jcrespo has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/337840 )
Change subject: Increse the concurrent threads of large mariadb servers ...................................................................... Increse the concurrent threads of large mariadb servers There is sometimes too much stall, 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. Bug: T150474 Change-Id: I0921f0afdde8d775de8cde0eac4935427f348f80 --- M templates/mariadb/production.my.cnf.erb 1 file changed, 3 insertions(+), 1 deletion(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/40/337840/1 diff --git a/templates/mariadb/production.my.cnf.erb b/templates/mariadb/production.my.cnf.erb index 4ac2195..a111aea 100644 --- a/templates/mariadb/production.my.cnf.erb +++ b/templates/mariadb/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: newchange Gerrit-Change-Id: I0921f0afdde8d775de8cde0eac4935427f348f80 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
