Planet MySQL

Displaying posts with tag: hidden primary key (reset)

Apr

2011

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