-
Notifications
You must be signed in to change notification settings - Fork 131
Multiple Clustering Indexes
Covering indexes can result in orders of magnitude performance improvements for queries. Bradley's presentation on covering indexes describes what a covering key is, how it can effect performance, and why it works. However, the definition of covering indexes can get cumbersome since MySQL limits the number of columns in a key to 16 (32 on MariaDB).
Tokutek introduced multiple clustering indexes into MySQL to address these problems. Zardosht describes the multiple clustering indexes feature and [how clustering indexes differ from covering iUser interfaceUser interfacendexes](http://www.tokutek.com/2009/05/clustering_indexes_vs_covering_indexes). Zardosht also describes the query versus update tradeoffs that exist with clustering indexes.
TokuDB now runs in MySQL 5.5, MariaDB 5.5, Percona Server 5.6, and MariaDB 10. Multiple clustering indexes are supported on all of these platforms. However, the user interface for clustering indexes is slightly different. We describe the differences here.