… this completely because InnoDB uses a clustered index based on (in order) the primary key you specify (an auto_increment), a unique key, or one…’t create either a unique key or a column with an auto_increment primary key in a table using InnoDB, the database will create one… also seen others try to make InnoDB use a composite UNIQUE key on a table as a primary key taking up far more space…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… with –innodb-optimize-keys, it did not handle composite indexes correctly when verifying if the optimization is applicable with respect to AUTO_INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys…
Post: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
… with –innodb-optimize-keys, it did not handle composite indexes correctly when verifying if the optimization is applicable with respect to AUTO_INCREMENT columns. Bug… III). In cases where indexes with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys from optimization, even though it is…
