At this week’s SF MySQL Meetup, I will give a talk:
“Understanding Indexing: Three rules on making indexes around
queries to provide good performance.” The meetup is 7 pm tomorrow
(Wednesday, 6/22), and will be held at CBS Interactive (235 2nd
St., San Francisco). Thanks to hosts Erin O’Neill and Mike
Tougeron for the invitation and location.
Application performance often depends on how fast a query can
respond and query performance almost always depends on good
indexing. So one of the quickest and least expensive ways to
increase application performance is to optimize the indexes. This
talk presents three simple and effective rules on how to
construct indexes around queries that result in good performance.
This is a general discussion applicable to all databases using
indexes and is not specific to any particular MySQL storage
engine (e.g., InnoDB, TokuDB, …[Read more]