MySQL Tutorial

MySQL allows us to analyze individual queries to see how long they take and exactly how they are executed on the database. By looking at this information and armed with an understanding of how MySQL tries to optimize your queries for you, you can sometimes improve performance. In this chapter we'll look at the following:

• Finding slow queries

• Benchmarking your queries

• Using the slow query log

• Using EXPLAIN to see how queries are executed

• Understanding MySQL's built-in query optimization

• Optimization tips