1. Session 1
    • Understanding Processlist
    • Understanding InnoDB Status
    • Tools and Apps
      • MySQL Monitor
      • JMeter
  2. Session 2
    • Understanding Index
    • Using EXPLAIN
    • Logging slow queries
    • Tuning SQL Queries
  3. Session 3
    • MySQL Server Configuration
      • Memory Management
      • Network Management
      • Concurrency/Thread Management
  4. Session 4
    • Third party tools
      • mysqltuner.pl
    • Case study
      • Read intensive operation
      • Write intensive operation
      • Balanced read-write operation