Step #1: Back to Basics

• Benchmark & Analyze

  • Understand what's slow and why
  • Figure out how expensive queries are

• Optimize

  • Fix what you can fix
  • Design with scale in mind

• Tune

  • Adjust MySQL settings

• Monitor