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 …