Summary


  • Find slow queries using BENCHMARK() or the slow query log.

  • See how queries are executed using EXPLAIN .

  • Speed things up by adding indexes and recheck with EXPLAIN .

  • ANALYZE TABLE and OPTIMIZE TABLE will help the MySQL query optimizer to do its job well.



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