Revision as of 10:48, 7 February 2011 by Thales Jacobi
MySQL parses queries, creates a parse tree and then applies optimisations, sometimes rewrite query, determine order, choose indexes...
3 steps to optimise your queries
1. Choose carefully
2. Optimise using
3. Learn about
- Concurrency controls: table lock can consume resources (table lock or row lock)