Planet MySQL

Displaying posts with tag: hidden primary key (reset)

Apr

2011

Posted by Ovais Tariq on Sun 24 Apr 2011 05: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.

Search

MySQL Links

Top 20 Authors

Oracle MySQL Blogs

Team Blogs

Vendor Blogs