Springle has uploaded a new change for review. https://gerrit.wikimedia.org/r/194788
Change subject: Increase MariaDB thread_pool_size. ...................................................................... Increase MariaDB thread_pool_size. This is the number of thread groups (multiple threads per group). Theoretically this should be equal to the number of cores but realistically we see CPU underutilization, plus we need the login phase of new connections to be handled promptly. Change-Id: Idbc9988a59765a854cda6aac4b55b00247b18614 --- M templates/mariadb/production.my.cnf.erb 1 file changed, 1 insertion(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/88/194788/1 diff --git a/templates/mariadb/production.my.cnf.erb b/templates/mariadb/production.my.cnf.erb index f3767ba..3492fe8 100644 --- a/templates/mariadb/production.my.cnf.erb +++ b/templates/mariadb/production.my.cnf.erb @@ -26,6 +26,7 @@ thread_handling = pool-of-threads thread_pool_stall_limit = 100 +thread_pool_size = 32 max_connections = 5000 back_log = 500 extra_max_connections = 10 -- To view, visit https://gerrit.wikimedia.org/r/194788 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Idbc9988a59765a854cda6aac4b55b00247b18614 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Springle <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
