Top 10 MySQL Tips and Tricks


1) Optimize your WHERE clause.

  • Remove unnecessary parentheses, this will speed up evaluation
  • COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM and MEMORY tables, but NOT Innodb tables. Beware.
  • If you use the SQL_SMALL_RESULT option, MySQL uses an in-memory temporary table

2 thoughts on “Top 10 MySQL Tips and Tricks

Leave a Reply

Your email address will not be published. Required fields are marked *