Planet MySQL

Displaying posts with tag: secondary key (reset)

Dec

2012

Posted by Jorgen Loland on Thu 20 Dec 2012 07:38 UTC
Tags:

innodb, new feature, MySQL 5.6, secondary key

Sergey Glukhov (Gluh) recently wrote an interesting blog about InnoDB secondary key improvements in MySQL 5.6. His blog isn't aggregated to planet.mysql.com but certainly deserves some attention.
Here it is: InnoDB, extended secondary keys.

Apr

2011

A few notes on InnoDB PRIMARY KEY

Posted by Ovais Tariq on Sun 24 Apr 2011 17:27 UTC
Tags:

innodb, Clustering, primary key, clustered indexes, auto_increment, compression, Covering indexes, disk space, mysql resources, secondary index, MySQL, hidden primary key, index-organized table, non-sequential primary key, primary index, secondary key, unique key

InnoDB uses an index-organized data storage technique, wherein the primary key acts as the clustered index and this clustered index holds the data. Its for this reason that understanding the basics of InnoDB primary key is very important, and hence the need for these notes.

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links