https://bugzilla.wikimedia.org/show_bug.cgi?id=38813
Web browser: ---
Bug #: 38813
Summary: My Contributions - Critical flood of slow queries that
is causing a DB overload on en-wiki
Product: MediaWiki extensions
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: ArticleFeedbackv5
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Classification: Unclassified
Mobile Platform: ---
A flood of slow queries from ArticleFeedbackv5Hooks::contributionsData() caused
AFT5 to overloaded db12. As a result, it is now disabled in its entirety on the
English-language Wikipedia.
It looks like there is no af_user_id or af_user_ip index, so the query scans
the whole aft_article_feedback table (200k rows) on every view of
Special:Contributions, according to Tim Starling.
Needless to say, this is the most important bug we need to fix at this time,
either by disabling feedback on MyContribs entirely, or by solving the specific
problem about af_user_id and testing thoroughly that it solves the larger issue
before deploying it in our next window.
--
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
