https://bugzilla.wikimedia.org/show_bug.cgi?id=45619
Sam Reed (reedy) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|Unprioritized |High --- Comment #1 from Sam Reed (reedy) <[email protected]> --- (In reply to comment #0) > The EXPLAIN without the FORCE INDEX looks worse on 5.1 without than with, > based > on number of rows examined, but it avoids a filesort. It looks better > without > the FORCE INDEX on mariadb than mysql 5.1 with or without. In both cases, > rev_timestamp is used instead of user_timestamp. function getIndexField() { return 'rev_timestamp'; } There is also code using usertext_timestamp: if ( $uid ) { $condition['rev_user'] = $uid; $index = 'user_timestamp'; } else { $condition['rev_user_text'] = $this->target; $index = 'usertext_timestamp'; } CREATE INDEX /*i*/user_timestamp ON /*_*/revision (rev_user,rev_timestamp); CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision (rev_user_text,rev_timestamp); I guess we should remove the force index for that one too? -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
