Chapter 19. Optimizing Your Queries


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



MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net