jcrespo added a comment. > Now Jynus sais that he doesn't believe that fix is going to help our > situation. I'm curious about why he believes that.
Connection re-use does not work if you open 900 connections at the same time every 3 minutes. I have been saying that for a long time. If a DBA has to explain connection reuse vs pool of connections... :-/ > We could just as well place the locks for all client wikis on the wikidata > master db. Then there should be no reason to connect to the client database > at all (assuming the job queue is not using mysql). Please don't. You are moving the problem from one server to another (and a more critical server). A good start would be to close connections as soon as they are not needed anymore- instead of idling them. Whatever you do, please do not test it in production. TASK DETAIL https://phabricator.wikimedia.org/T118162 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: jcrespo Cc: Tobi_WMDE_SW, ori, mobrovac, thiemowmde, aaron, jcrespo, gerritbot, daniel, aude, hoo, Lydia_Pintscher, Addshore, Aklapper, Joe, Wikidata-bugs, Mbch331, Krenair _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
