Page MenuHomePhabricator

[CatWatch] CategoryMembership is running SELECTS on the master
Closed, ResolvedPublic5 Estimated Story Points

Description

SELECT /* CategoryMembershipChangeJob::run  */  rev_timestamp,rev_id  FROM `revision` INNER JOIN `recentchanges` ON ((rc_this_oldid = rev_id) AND rc_source = 'mw.categorize' AND (rc_cur_id = rev_page) AND (rc_timestamp >= rev_timestamp))  WHERE rev_page = '510504' AND (rev_timestamp >= '20160128204753')  ORDER BY rev_timestamp DESC, rev_id DESC LIMIT 1

Event Timeline

jcrespo raised the priority of this task from to Needs Triage.
jcrespo updated the task description. (Show Details)
jcrespo added a subscriber: jcrespo.

There is a slave with specialized partitioning on the recentchanges table to improve the performance.

Addshore renamed this task from CategoryMembership is running SELECTS on the master to [CatWatch] CategoryMembership is running SELECTS on the master.Jan 29 2016, 9:45 AM
Addshore added a project: archived--TCB-Team.
Addshore set Security to None.
Addshore added a subscriber: Addshore.

Change 267227 had a related patch set uploaded (by Addshore):
Use slave for selects in CategoryMembershipJob

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

Change 267227 merged by jenkins-bot:
Use slave for selects in CategoryMembershipJob

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