Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: secondary key (reset)

Gluh on InnoDB extended secondary keys
Employee +1 Vote Up -0Vote Down
posted by Jorgen Loland on Thu 20 Dec 2012 07:38 UTC
Tags:
(edit) 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.
A few notes on InnoDB PRIMARY KEY
+0 Vote Up -1Vote Down
posted by Ovais Tariq on Sun 24 Apr 2011 17:27 UTC
Tags:
(edit) mysql, innodb, Clustering, primary key, clustered indexes, auto_increment, compression, Covering indexes, disk space, mysql resources, secondary index, 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.
Showing entries 1 to 2

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.