Query Optimization

• Enable the slow query log

• Use a low long-query-time threshold

• Don't assume that logged queries really are slow

  • Test them, benchmark if necessary
  • Use EXPLAIN to verify

• Test alternative indexes

  • Fewer rows isn't always better
  • Consider disk seeks as well