Jcrespo has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/232049

Change subject: Increasing max_connections variables on all misc servers
......................................................................

Increasing max_connections variables on all misc servers

Phabricator m3 database server is hitting max_connections
error. We are bumping max_connections to 1500 to solve a max_
connection issue for this application. This should not affect
the rest of the servers, and phabricator mysql server is isolated,
so there is little danger on doing this. According to Chase,
the query patterns, while high in number, are expected, and not
abnormal.

Bug: T109279
Change-Id: Iafe6d5f9e5898ab9598ffe8bf935b7debdb97826
---
M templates/mariadb/misc.my.cnf.erb
1 file changed, 2 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/49/232049/1

diff --git a/templates/mariadb/misc.my.cnf.erb 
b/templates/mariadb/misc.my.cnf.erb
index a633193..2685994 100644
--- a/templates/mariadb/misc.my.cnf.erb
+++ b/templates/mariadb/misc.my.cnf.erb
@@ -22,7 +22,7 @@
 skip-name-resolve
 temp-pool
 
-max_connections                = 500
+max_connections                = 1500
 extra_max_connections          = 10
 max_connect_errors             = 1000000000
 max_allowed_packet             = 16M
@@ -71,4 +71,4 @@
 quick
 max_allowed_packet = 16M
 
-#!includedir /etc/mysql/conf.d/
\ No newline at end of file
+#!includedir /etc/mysql/conf.d/

-- 
To view, visit https://gerrit.wikimedia.org/r/232049
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iafe6d5f9e5898ab9598ffe8bf935b7debdb97826
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

Reply via email to