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 raised the priority of this task from to Needs Triage.
aaron updated the task description. (Show Details)
aaron added a subscriber: aaron.

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 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.

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

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

bd808 moved this task from Done to Archive on the MediaWiki-Core-Team board.
bd808 added a subscriber: bd808.