3.6.06. Elementary steps

  • Ask MySQL what it's doing
    • Query analysis with EXPLAIN
  • Cache the query
    • no free lunch, there's almost always a cost
    • Simple
      • Repetitive queries
      • Rare since requires constant snapshot
      • What's the point of the query