Planet MySQL

Displaying posts with tag: innodb indexes (reset)

Dec

2011

Slides of my talk on B+Tree Indexes and InnoDB

Posted by Ovais Tariq on Sun 18 Dec 2011 07:58 UTC
Tags:

indexing, innodb, Presentation, clustered indexes, slides, covering index, B+Tree, B-Tree, percona live, innodb indexes, secondary index, MySQL, Performance, primary index, index lookup, index pages, index tree, composite index

The slides of my talk on B+Tree Indexes and InnoDB are now available for download. This slide was presented during Percona Live London 2011. You can download the slides from here.
There are many other interesting and informative talks that were presented during Percona Live London 2011, and I think you should definitely check them out, if you haven't. They are available here.

The post Slides of my talk on B+Tree Indexes and InnoDB appeared first on ovais.tariq.

Jan

2011

Understanding InnoDB clustered indexes

Posted by Ovais Tariq on Thu 20 Jan 2011 14:02 UTC
Tags:

innodb, indexes, Clustering, primary key, clustered indexes, B-Tree, innodb resources, advantages, disadvantages, index storage, innodb indexes, secondary index, Performance

Some people don't probably know, but there is a difference between how indexes work in MyISAM and how they work in InnoDB, particularly when talking from the point of view of performance enhancement. Now since, InnoDB is starting to be widely used, it is important we understand how indexing works in InnoDB. Hence, the reason for this post!

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links