MySQL Performance Tuning

Optimization Order

  1. Find the heaviest SQL first.
  2. Correct indexing and query plans.
  3. Scale architecture only after SQL hygiene.