https://bugzilla.wikimedia.org/show_bug.cgi?id=56041
--- Comment #2 from Tim Starling <[email protected]> --- <springle> Reedy: could UpdateCollation do reads from a slave? <Reedy> Couldn't see why not... We've got the wfWaitForSlave() calls in anyway, so they should be up to date for when we do the next select() <Reedy> TimStarling might have some input too <TimStarling> the select is too slow? <springle> yes. does a large filesort. innodb buffer pool gets out of whack pulling on old data, other writes pile up, then swap starts and everything crawls, then max_connections <TimStarling> I suppose it would work, as long as the slave is guaranteed to have no open snapshot <springle> trying without adaptive hash latch now, but not convinced that's a core issue -- 5.5 already has some fo the old related bugs fixed <TimStarling> maybe it could use a $dbr->commit() before the select to be on the safe side <springle> the select does ORDER BY cl_to, cl_type, cl_from .. is that definitely needed? <TimStarling> springle: yes, see https://gerrit.wikimedia.org/r/#/c/53301/ <springle> ok -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
