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

One thought on “Top 10 MySQL Tips and Tricks

Leave a Reply and Let me know what you think...