Revision as of 10:48, 7 February 2011 by Thales Jacobi (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)



MySQL Optimisation

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)
  • Indexation