[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Aaron Schulz aschulz4...@gmail.com changed: What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED Resolution|--- |FIXED -- 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #39 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 110299 merged by jenkins-bot: Made ActiveUsers use querycache and do staggered updates on view https://gerrit.wikimedia.org/r/110299 -- 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #40 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 111258 had a related patch set uploaded by Aaron Schulz: Made ActiveUsers use querycache and do staggered updates on view https://gerrit.wikimedia.org/r/111258 -- 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #41 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 111258 merged by jenkins-bot: Made ActiveUsers use querycache and do staggered updates on view https://gerrit.wikimedia.org/r/111258 -- 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Gerrit Notification Bot gerritad...@wikimedia.org changed: What|Removed |Added Status|RESOLVED|PATCH_TO_REVIEW Resolution|FIXED |--- -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #38 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 110299 had a related patch set uploaded by Nemo bis: Made ActiveUsers use querycache and do staggered updates on view https://gerrit.wikimedia.org/r/110299 -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Nemo federicol...@tiscali.it changed: What|Removed |Added Assignee|wikibugs-l@lists.wikimedia. |aschulz4...@gmail.com |org | -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Nemo federicol...@tiscali.it changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=59988 -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Nemo federicol...@tiscali.it changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=60468 -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED --- Comment #34 from Umherirrender umherirrender_de...@web.de --- All wikis now on 1.22wmf4, it is still active on enwiki, looks like the new query is not slow anymore - FIXED -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #35 from Aaron Schulz aschulz4...@gmail.com --- (In reply to comment #34) All wikis now on 1.22wmf4, it is still active on enwiki, looks like the new query is not slow anymore - FIXED It's still sometimes slow for enwiki/wikidatawiki, not sure exactly why though. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #36 from Nemo federicol...@tiscali.it --- For the records, on en.wiki it's now like this: Served by mw1022 in 0.453 secs. Served by mw1077 in 0.343 secs. Served by mw1043 in 0.467 secs. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #37 from MZMcBride b...@mzmcbride.com --- Query cache and other caching layers likely affect any attempts at benchmarking. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #30 from Niklas Laxström niklas.laxst...@gmail.com --- Serves in about one second on translatewiki.net now. Should we close this bug now? -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #31 from Nemo federicol...@tiscali.it --- (In reply to comment #30) Serves in about one second on translatewiki.net now. Should we close this bug now? Probably. On the other hand, it should be restored on en.wiki with 1.22wmf4 on Monday, May 20, 2013, so we could as well wait a week and see. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #32 from Oleg grazero...@rambler.ru --- Restore Active Users in small Wikipedias! The decision to remove it was harmful for small Wikis! -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #33 from Nemo federicol...@tiscali.it --- (In reply to comment #32) Restore Active Users in small Wikipedias! The decision to remove it was harmful for small Wikis! As I said, it's going to be restored on all wikis (and then disabled again on some wikis if needed). See the calendar for 1.22wmf4 code update: https://www.mediawiki.org/wiki/MediaWiki_1.22/Roadmap -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #29 from db duplicate...@googlemail.com --- (In reply to comment #15) special page was removed with Gerrit change #55807 Back with gerrit 58686 gerrit 62408 refactored the query. Please test if this helps with the performance. Thanks. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Bawolff (Brian Wolff) bawolff...@gmail.com changed: What|Removed |Added CC||vss...@gmail.com --- Comment #28 from Bawolff (Brian Wolff) bawolff...@gmail.com --- *** Bug 47559 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Bawolff (Brian Wolff) bawolff...@gmail.com changed: What|Removed |Added CC||bawolff...@gmail.com --- Comment #27 from Bawolff (Brian Wolff) bawolff...@gmail.com --- If the query really is that slow, could be re-done as a cached special page perhaps. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #26 from MZMcBride b...@mzmcbride.com --- (In reply to comment #25) I wonder, why I didn't read it in the wikitech-ambassadors mailing list. Perhaps this change was just not submitted to that mailing list? Related: bug 47350 (Restore Special:ActiveUsers prior to the release of MediaWiki 1.21) -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Rainer Rillke @commons.wikimedia rainerril...@hotmail.com changed: What|Removed |Added CC||rainerril...@hotmail.com --- Comment #25 from Rainer Rillke @commons.wikimedia rainerril...@hotmail.com --- I wonder, why I didn't read it in the wikitech-ambassadors mailing list. Perhaps this change was just not submitted to that mailing list? -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Oleg grazero...@rambler.ru changed: What|Removed |Added CC||grazero...@rambler.ru --- Comment #24 from Oleg grazero...@rambler.ru --- +1 to Ravishankar. In Lezgi Wikipedia we have the rules of administrators election - voter must have at least 10 edits in the «Articles», «Templates» and/or «Category» namespaces within the last 30 days. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Ravishankar ravidreams...@yahoo.com changed: What|Removed |Added CC||ravidreams...@yahoo.com --- Comment #23 from Ravishankar ravidreams...@yahoo.com --- Hi, We have been using this metric in Tamil Wikipedia to identify and encourage new and active users. Can we get this feature back, please? At least, you can switch this on and off per wiki or provide an option to run this through extensions. Thanks. -- You are receiving this mail because: You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Quim Gil q...@wikimedia.org changed: What|Removed |Added CC||q...@wikimedia.org -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 MZMcBride b...@mzmcbride.com changed: What|Removed |Added CC||b...@mzmcbride.com --- Comment #21 from MZMcBride b...@mzmcbride.com --- If the addition of this feature was poorly thought out, surely its removal had even less consideration. Looking at https://gerrit.wikimedia.org/r/55807, was this feature really removed in just 20 minutes? Won't this be a breaking change in the MediaWiki API (among the other ripple effects)? (In reply to comment #12) http://translatewiki.net/wiki/Special:ActiveUsers It's certainly not fast... !-- Served in 12.943 secs. -- So on the wiki that set its recent changes to be _years_, it's slightly slow. On a giant production database, however... Less than half a second on enwiki This really justified removing the feature in the course of an hour? I'm a bit baffled here. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #22 from Niklas Laxström niklas.laxst...@gmail.com --- It was slow on WMF too: [23:45:38] binasher ^demon: i noticed that one of the enwiki slaves was lagging a bunch and getting a bunch of ActiveUsersPager queries.. looks like an uncommonly called page, but the query results in just about a full scan of recentchanges with an on disk temp table [23:46:03] binasher takes around 2 minutes on a busy server if all pages are in the bufferpool [23:46:08] binasher and 8 if not -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Bartosz Dziewoński matma@gmail.com changed: What|Removed |Added CC||hazard...@yahoo.com --- Comment #19 from Bartosz Dziewoński matma@gmail.com --- *** Bug 46938 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Tom H thutchison...@hotmail.com changed: What|Removed |Added CC||thutchison...@hotmail.com --- Comment #20 from Tom H thutchison...@hotmail.com --- (In reply to comment #16) Please revert this change. This page is (was?) very useful on many small and even medium wikis with relatively low number of edits and it was not a performance hit there. The summarized, up-to-date information about active users or even a list of active users is very useful. If there is a performance problem on some wikis (translatewiki?) it should be solved in a per-wiki way. I see at least three ways: 1. limit time period or number of analyzed edits 2. use some caching/locking to avoid this call be called too often 3. disable it in per-wiki way only on wikis where a problem occurs Or, at least, offer an alternative while removing this page. +1 on this revert. I'm sorry, but it was a 'axe it' mentality based load on wikipedia because of its unique - large data set. If the query is trash, tweak or improve it. Pull it from somewhere else. Too many smaller wikis rely on what is already a small set of metric data for Mediawiki. Rate limit it, cache it or allow for disabling with a boolean switch. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Andrzej Krzysztofowicz an...@mif.pg.gda.pl changed: What|Removed |Added Status|RESOLVED|REOPENED CC||an...@mif.pg.gda.pl Resolution|INVALID |--- --- Comment #16 from Andrzej Krzysztofowicz an...@mif.pg.gda.pl --- Please revert this change. This page is (was?) very useful on many small and even medium wikis with relatively low number of edits and it was not a performance hit there. The summarized, up-to-date information about active users or even a list of active users is very useful. If there is a performance problem on some wikis (translatewiki?) it should be solved in a per-wiki way. I see at least three ways: 1. limit time period or number of analyzed edits 2. use some caching/locking to avoid this call be called too often 3. disable it in per-wiki way only on wikis where a problem occurs Or, at least, offer an alternative while removing this page. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Bartosz Dziewoński matma@gmail.com changed: What|Removed |Added CC||afeld...@wikimedia.org, ||innocentkil...@gmail.com, ||matma@gmail.com, ||s.mazel...@xs4all.nl --- Comment #17 from Bartosz Dziewoński matma@gmail.com --- (CC-ing code submitter and reviewers.) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #18 from Aaron Schulz aschulz4...@gmail.com --- One thing that slowed it down was showing the count of the recent edits (an expensive GROUP BY). It could have used a LIMIT 10 subquery for each or just not have that count at all and maybe just use user_editcount (total edits, recent or not). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 db duplicate...@googlemail.com changed: What|Removed |Added Status|NEW |RESOLVED CC||duplicate...@googlemail.com Resolution|--- |INVALID --- Comment #15 from db duplicate...@googlemail.com --- special page was removed with gerrit 55807 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #13 from Umherirrender umherirrender_de...@web.de --- query reduced with gerrit 51290 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #14 from Nemo federicol...@tiscali.it --- (In reply to comment #12) !-- Served in 12.943 secs. -- (In reply to comment #13) query reduced with Gerrit change #51290 -rakkaus:#mediawiki-i18n- [nike] updated translatewiki.net to 7ca8090 2013-03-15 14:32:34 + (45 seconds ago) Now: !-- Served in 7.325 secs. -- !-- Served in 6.851 secs. -- -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|Unprioritized |Normal CC||aklap...@wikimedia.org --- Comment #11 from Andre Klapper aklap...@wikimedia.org --- Can this problem still be seen? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #12 from Sam Reed (reedy) s...@reedyboy.net --- http://translatewiki.net/wiki/Special:ActiveUsers It's certainly not fast... !-- Served in 12.943 secs. -- Less than half a second on enwiki -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added CC||umherirrender_de...@web.de --- Comment #9 from Umherirrender umherirrender_de...@web.de 2012-10-19 16:37:20 UTC --- That pages was slow on translatewiki before my changes, because translatewiki has set RCMaxAge to a high value and that result in many rows in the recentchange table. It is hard to say, which query will give the best result for this. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #10 from Sam Reed (reedy) s...@reedyboy.net 2012-10-19 17:19:28 UTC --- (In reply to comment #9) That pages was slow on translatewiki before my changes, because translatewiki has set RCMaxAge to a high value and that result in many rows in the recentchange table. It is hard to say, which query will give the best result for this. It just seemed a likely candidate as it had been deployed, then it was noticed it was slow. Granted, it's not that commit. Reverted https://gerrit.wikimedia.org/r/#/c/28689/ -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||performance -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #1 from Sam Reed (reedy) s...@reedyboy.net 2012-10-17 18:27:20 UTC --- http://www.mediawiki.org/wiki/Special:ActiveUsers https://github.com/mediawiki/core/commits/master/includes/specials/SpecialActiveusers.php I bet it's from https://github.com/mediawiki/core/commit/341552f6618be866571de5e0f1a6c78038bb856a https://gerrit.wikimedia.org/r/#/c/17945/ -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Sam Reed (reedy) s...@reedyboy.net changed: What|Removed |Added CC||s...@reedyboy.net --- Comment #2 from Sam Reed (reedy) s...@reedyboy.net 2012-10-17 18:28:20 UTC --- Need to grab a full SQL query and run EXPLAIN on it -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #3 from Sam Reed (reedy) s...@reedyboy.net 2012-10-17 18:30:10 UTC --- Query wikidb (23) (slave): SELECT /* IndexPager::buildQueryInfo (ActiveUsersPager) Reedy */ rc_user_text AS user_name,rc_user_text,user_id,COUNT(*) AS recentedits,MAX(ipb_deleted) AS ipb_deleted FROM `mw_recentchanges` FORCE INDEX (rc_user_text) INNER JOIN `mw_user` ON ((rc_user_text=user_name)) LEFT JOIN `mw_ipblocks` ON ((user_id=ipb_user) AND ipb_auto = '0') WHERE (rc_user 0) AND (ipb_deleted IS NULL OR ipb_deleted = 0) AND (rc_log_type IS NULL OR rc_log_type != 'newusers') AND (rc_timestamp '20120917182934') -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #4 from Sam Reed (reedy) s...@reedyboy.net 2012-10-17 18:31:14 UTC --- mysql explain SELECT /* IndexPager::buildQueryInfo (ActiveUsersPager) Reedy */ rc_user_text AS user_name,rc_user_text,user_id,COUNT(*) AS recentedits,MAX(ipb_deleted) AS ipb_deleted FROM `recentchanges` FORCE INDEX (rc_user_text) INNER JOIN `user` ON ((rc_user_text=user_name)) LEFT JOIN `ipblocks` ON ((user_id=ipb_user) AND ipb_auto = '0') WHERE (rc_user 0) AND (ipb_deleted IS NULL OR ipb_deleted = 0) AND (rc_log_type IS NULL OR rc_log_type != 'newusers') AND (rc_timestamp '20120917182934'); ++-+---++---+---+-+--+---+-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---++---+---+-+--+---+-+ | 1 | SIMPLE | recentchanges | ALL| rc_user_text | NULL | NULL | NULL | 11096 | Using where | | 1 | SIMPLE | user | eq_ref | user_name | user_name | 257 | mediawikiwiki.recentchanges.rc_user_text | 1 | Using index | | 1 | SIMPLE | ipblocks | ref| ipb_user | ipb_user | 4 | mediawikiwiki.user.user_id | 1 | Using where | ++-+---++---+---+-+--+---+-+ 3 rows in set (0.01 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #5 from Niklas Laxström niklas.laxst...@gmail.com 2012-10-17 21:33:07 UTC --- I guess the problem is recentchanges table which is not using index. It's scanning millions of row in translatewiki.net -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Aaron Schulz aschulz4...@gmail.com changed: What|Removed |Added CC||aschulz4...@gmail.com --- Comment #6 from Aaron Schulz aschulz4...@gmail.com 2012-10-17 21:33:58 UTC --- (In reply to comment #1) http://www.mediawiki.org/wiki/Special:ActiveUsers https://github.com/mediawiki/core/commits/master/includes/specials/SpecialActiveusers.php I bet it's from https://github.com/mediawiki/core/commit/0 https://gerrit.wikimedia.org/r/#/c/17945/ Can you revert that? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Niklas Laxström niklas.laxst...@gmail.com changed: What|Removed |Added Blocks||39480 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 Nemo_bis federicol...@tiscali.it changed: What|Removed |Added CC||federicol...@tiscali.it Blocks||29572 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #7 from Sam Reed (reedy) s...@reedyboy.net 2012-10-17 22:18:22 UTC --- (In reply to comment #6) (In reply to comment #1) http://www.mediawiki.org/wiki/Special:ActiveUsers https://github.com/mediawiki/core/commits/master/includes/specials/SpecialActiveusers.php I bet it's from https://github.com/mediawiki/core/commit/0 https://gerrit.wikimedia.org/r/#/c/17945/ Can you revert that? https://gerrit.wikimedia.org/r/28457 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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 41078] Special:ActiveUsers query is very slow
https://bugzilla.wikimedia.org/show_bug.cgi?id=41078 --- Comment #8 from Niklas Laxström niklas.laxst...@gmail.com 2012-10-17 22:34:53 UTC --- Makes only marginal difference: 101 rows in set (35.61 sec) mysql explain SELECT /* IndexPager::buildQueryInfo (ActiveUsersPager) Nike */ rc_user_text AS user_name,rc_user_text,user_id,COUNT(*) AS recentedits,MAX(ipb_user) AS blocked FROM `bw_recentchanges` FORCE INDEX (rc_user_text) INNER JOIN `bw_user` ON ((rc_user_text=user_name)) LEFT JOIN `bw_ipblocks` ON ((user_id=ipb_user) AND ipb_auto = '0' AND ipb_deleted = '1') WHERE (rc_user 0) AND (ipb_deleted IS NULL) AND (rc_log_type IS NULL OR rc_log_type != 'newusers') AND (rc_timestamp = '20120917223021') GROUP BY rc_user_text,user_id ORDER BY rc_user_text LIMIT 101; ++-+--++---+--+-+-++-+ | id | select_type | table| type | possible_keys | key | key_len | ref | rows | Extra | ++-+--++---+--+-+-++-+ | 1 | SIMPLE | bw_recentchanges | index | rc_user_text | rc_user_text | 273 | NULL| 155136 | Using where | | 1 | SIMPLE | bw_user | eq_ref | user_name | user_name| 257 | mediawiki.bw_recentchanges.rc_user_text | 1 | Using index | | 1 | SIMPLE | bw_ipblocks | ref| ipb_user | ipb_user | 4 | mediawiki.bw_user.user_id | 1 | Using where; Not exists | ++-+--++---+--+-+-++-+ 3 rows in set (0.01 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. 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
