MySQL Performance & Reporting

This presentation will show you how to get performance by optimizing:

  • General queries—going beyond the default settings
  • How MySQL uses indexes
  • Reporting queries, including:
    • Summary tables
    • JOINs
    • Covered indexes
  • Full text search queries for InnoDB (an early access feature in MySQL 5.6)