…the full row data corresponding to the given index entry. So what choices does MySQL have if you have just 2 separate indexes…MySQL picks to use combined index and indeed the…wrong of course – it can’t be more than if only index prefix is used. MySQL does…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…the system and how data was lost: MySQL…the wrong machine (production master) All slaves followed and dropped their copy of the data The…picking on the…Why? Well, here’s few of the…the right page and so the right index id. The…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…INDEX or change the query and report MySQL Optimizer Bug 
But now lets see in the…wrong cardinality which shows us index prefix is unique (245900 is estimate for the row count in the…the order of magnitude is enough. Sometimes it is not and you’re thinking why a hell it could be picking…
