Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Displaying posts with tag: non-sequential 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.

The latest from the MySQL community

Get Started Contributing

Events

MySQL Showcase

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links