Index

MySQL Percona Live 2015

Percona Live Presentation: Improving Performance With Better Indexes

Ronald Bradford
April 15, 2015

The slides for my Improving Performance With Better Indexes presentation at Percona Live 2015 MySQL Conference and Expo are now available. In this presentation I discuss how to identify, review and analyze SQL statements in order to create better indexes for your queries.

Databases MySQL

Ineffective concatenated indexes

Ronald Bradford
February 24, 2010

In MySQL significant performance improvements can be achieved by the correct use of indexes. It is important to understand different MySQL index implementations and one key improvement on indexes defined on single columns is to use multiple column or more commonly known concatenated indexes.

Databases MySQL Open Source

Handy MySQL documentation indexes

Ronald Bradford
August 21, 2009

Updated If your wanting to know more about MySQL Indexes on tables, then check out Understanding Different MySQL Index Implementations . I just discovered today in the MySQL 5.1 Reference Manual a handy set of additional indexes in the System Navigation section.