In addition to speaking at RMOUG event in Denver, I also spoke today in Broomfield on “Improving MySQL Performance with Better Indexes”.
This presentation included details on :
- Effective examples of capture SQL via application logging and TCP/IP analysis necessary for identifying the best candidates. Slow is not always the best query to start with.
- All the commands necessary to identify why you may need an index, how to create varying types of indexes, and how to confirm there true effectiveness.
- How the number of table rows and different storage engines can greatly effect the optimization choice and query performance
- The presentation shows how to determine/create and verify covering indexes for a single table example, a master/child example and a production 13 table join.
You can obtain the slides from Improving MySQL Performance With Better Indexes Presentation.