… | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null …ALTER TABLE Innodb, same as MyISAM will internally run analyze as soon as table is rebuilt and values will be more sensible: mysql> alter table…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
…Here is what I’d like to see Packed indexes. In many cases then difference in … as well as ALTER TABLE (expecially together with ability to create index without table rebuilding) Buffer pool improvements… is ugly and inconvenient. Having independent CLUSTER=key option would be great, it also would …
