[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 Sean Pringle sprin...@wikimedia.org changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED --- Comment #18 from Sean Pringle sprin...@wikimedia.org --- Regarding monitoring: We have userstat=ON on the labsdb instances to maintain user_statistics and client_statistics tables in information_schema. The data is also being logged on db1044 for time-series reporting, but isn't exposed anywhere yet. http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html Unfortunately the user_statistics.concurrent_connections field isn't updated due to bug. However by logging user_statistics.total_connections we can still identify spikes. So far nobody has abused max_user_connections=512, and, as Coren implied earlier, we can continue to be lenient until forced to do otherwise. Closing. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 --- Comment #17 from Andre Klapper aklap...@wikimedia.org --- Johannes: Any recent complaints from users because article list generator doesn't work? Is there any work left to do here or can this be closed (see comment 14)? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 --- Comment #16 from Tim Landscheidt t...@tim-landscheidt.de --- (In reply to comment #14) [...] Need to monitor for a while to see peak connection usage per user. From that we can pick a sane cut-off. Do we now how some data to close this bug? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 --- Comment #13 from Johannes Kroll (WMDE) johannes.kr...@wikimedia.de --- This has been un-fixed since more than a month now. We are getting angry emails from users because the article list generator doesn't work for anything except enwiki. Please fix it. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 --- Comment #14 from Sean Pringle sprin...@wikimedia.org --- Should now be re-fixed back to 512. https://gerrit.wikimedia.org/r/#/c/106254/ Need to monitor for a while to see peak connection usage per user. From that we can pick a sane cut-off. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 --- Comment #15 from Marc A. Pelletier m...@uberbox.org --- I wish mariadb had a 95th percentile max_connections. /That/ would be useful. :-) -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 Marc A. Pelletier m...@uberbox.org changed: What|Removed |Added Assignee|m...@uberbox.org|sprin...@wikimedia.org --- Comment #12 from Marc A. Pelletier m...@uberbox.org --- Sean, I agree with the request in principle; given the use patterns it'd be reasonable to up the limit by a few orders of magnitude (just low enough that no single tool can use up everything) so that bursts of activity don't hit the limit. It was set (by hand) to 512 in the past with no issues. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 49872] max_user_connections too low on Wikimedia Labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=49872 MZMcBride b...@mzmcbride.com changed: What|Removed |Added CC||b...@mzmcbride.com Summary|max_user_connections too|max_user_connections too |low |low on Wikimedia Labs -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
