Page MenuHomePhabricator

Slow AFComputedVariable users query
Closed, ResolvedPublic

Description

AFComputedVariable::compute 10.64.32.27 2013 Lost connection to MySQL server during query (10.64.32.27) SELECT DISTINCT rev_user_text FROM revision WHERE rev_page = '36395484' AND (rev_timestamp<'20150219194512') ORDER BY rev_timestamp DESC LIMIT 10

This sucks when the page basically has a few bot authors and many revisions.

Event Timeline

aaron created this task.Feb 20 2015, 1:02 AM
aaron raised the priority of this task from to Needs Triage.
aaron updated the task description. (Show Details)
aaron added a subscriber: aaron.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 20 2015, 1:02 AM

Change 191823 had a related patch set uploaded (by Aaron Schulz):
Avoid "recent-contributors" queries that cause timeouts

https://gerrit.wikimedia.org/r/191823

Patch-For-Review

aaron claimed this task.Feb 20 2015, 1:06 AM
aaron added a project: MediaWiki-Core-Team.
aaron set Security to None.
aaron moved this task from Backlog to Needs Review/Feedback on the MediaWiki-Core-Team board.
Se4598 added a subscriber: Se4598.

Change 191823 merged by jenkins-bot:
Avoid "recent-contributors" queries that cause timeouts

https://gerrit.wikimedia.org/r/191823

bd808 closed this task as Resolved.Feb 23 2015, 11:59 PM
bd808 moved this task from Done to Archive on the MediaWiki-Core-Team board.
bd808 added a subscriber: bd808.