- About Percona
- You’ve Made a Great Choice
- MySQL Indexing: Agenda Understanding Indexing Setting up best indexes for your applications
- Indexing in the Nutshell
- Majority of indexes you deal in MySQL is this type BTREE Indexes www.percona.com RTREE Indexes
- Family of BTREE like Indexes
- B+Tree Example Branch/Root Node Less than 3 Data Pointers Leaf Node
- Indexes in MyISAM vs Innodb In MyISAM data pointers point to physical offset in the data file
- What Operations can BTREE Index do
- String Indexes
- Multiple Column Indexes
- Overhead of The Indexing Indexes are costly
- Indexing Innodb Tables
- How MySQL Uses Indexes Data Lookups Sorting Avoiding reading “data” Special Optimizations
- Using Indexes for Data Lookups
- It Gets Tricky
- The First Rule of MySQL
- Using Index for Sorting
- It becomes even more restricted!
- MySQL Using Index for Sorting Rules
- Avoiding Reading
- Min/Max Optimizations
- Indexes and Joins
- Using Multiple Indexes for the table
- Prefix Indexes
- Choosing Prefix Length
- What is new with MySQL 5.6
- Understanding ICP
- ICP Examples
- More on Picking the Index
- Use EXPLAIN
- Indexing Strategy
- Indexing Strategy Example
- Percona Toolkit – Pt-query-digest
Работа с индексами: лучшие практики для MySQL. Зайцев Петр
