The Five Minute DBA

Users are complaining that the application is slow. By reviewing your system and database performance, you have identified a slow running SQL query in the database. If you did not know how to tune an SQL statement in MySQL, what would you do? This book aims to address this need by discussing the ideal approach and best principles toward optimizing SQL statements. This chapter provides a few quick tips you can apply immediately.

In this chapter we will be using the following approach:

• Confirm your slow query

• Identify a missing index

• Apply a new index

• Verify your new index

Identifying Performance Problems

Users report ...

Get Effective MySQL Optimizing SQL Statements now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.