Jcrespo has uploaded a new change for review. https://gerrit.wikimedia.org/r/235685
Change subject: Set max idle connection timeout to 60 seconds on Phabricator ...................................................................... Set max idle connection timeout to 60 seconds on Phabricator Sometimes, Phabricator creates a large number of connections that are left in "Sleep" state (not executing any query). While a root cause have not yet been found, seting the wait timeout to 60 seconds seems to help avoiding the issue. Bug: T109279 Change-Id: I3d76fd7c4e95c24c500d7f93a836772c0a2c550a --- M templates/mariadb/phabricator.my.cnf.erb 1 file changed, 2 insertions(+), 2 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/85/235685/1 diff --git a/templates/mariadb/phabricator.my.cnf.erb b/templates/mariadb/phabricator.my.cnf.erb index bee7036..49ccfd7 100644 --- a/templates/mariadb/phabricator.my.cnf.erb +++ b/templates/mariadb/phabricator.my.cnf.erb @@ -34,8 +34,8 @@ log-warnings = 0 thread_stack = 192K thread_cache_size = 100 -interactive_timeout = 28800 -wait_timeout = 3600 +interactive_timeout = 60 # T109279 +wait_timeout = 60 # T109279 sync_binlog = 1 binlog_cache_size = 1M -- To view, visit https://gerrit.wikimedia.org/r/235685 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I3d76fd7c4e95c24c500d7f93a836772c0a2c550a 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
