https://bugzilla.wikimedia.org/show_bug.cgi?id=42614
--- Comment #26 from Platonides <[email protected]> --- It makes no sense that mysql needs to read so many rows with an index. Unless the table is really huge or the random numbers aren't really random. In comment 23 (the expensive query) I see a key_len of 291. That suggests to me that job_cmd is not varbinary(60) in that server but varchar(255). That change was done in 2007! (f38344aba) Still, although less efficient, I don't see why that should make the index not be used “correctly“. I wonder if we may have slaves with different job_cmds. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
