Last modified: 2013-10-10 12:03:41 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T57556, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 55556 - Extremely/unusually slow SQL on categorylinks table
Extremely/unusually slow SQL on categorylinks table
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized blocker
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2013-10-10 10:54 UTC by Magnus Manske
Modified: 2013-10-10 12:03 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Magnus Manske 2013-10-10 10:54:17 UTC 
SQL queries run "forever". Tested for Commons:

MariaDB [commonswiki_p]> SELECT * from categorylinks limit 5;

This just sits there and does nothing, forever.
Comment 1 Marc A. Pelletier 2013-10-10 11:45:54 UTC 
There is a ridiculously long query going on that table that is delaying a DDL query that is locking the table.

*sigh*  I was hoping we wouldn't have to introduce a query killer.  :-(
Comment 2 Magnus Manske 2013-10-10 11:46:52 UTC 
Back to the roots indeed :-(
Comment 3 Marc A. Pelletier 2013-10-10 11:54:40 UTC 
The query has been killed; I expect everything else will have just unclogged at once.
Comment 4 Marc A. Pelletier 2013-10-10 12:03:41 UTC 
I think I'll want to deploy an alert for exagerately long queries before I implement a query killer; so we get a better idea of how often that happens and who the culprits are.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links