| jcrespo | |
| Jan 28 2016, 8:55 PM |
| F3289170: sorts_s2master.png | |
| Jan 28 2016, 8:55 PM |
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
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Use slave for selects in CategoryMembershipJob | mediawiki/core | master | +12 -4 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Invalid | TTO | T125171 [Catwatch] Filter for Watch edits which add or remove pages from a category | |||
| Resolved | Addshore | T9148 Watch edits which add or remove pages from a category | |||
| Resolved | Addshore | T125147 [CatWatch] CategoryMembership is running SELECTS on the master |
There is a slave with specialized partitioning on the recentchanges table to improve the performance.
Change 267227 had a related patch set uploaded (by Addshore):
Use slave for selects in CategoryMembershipJob