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

• ← Using a Windows XServer to access the Gnome desktop on a Linux Server
• MySQL – Restoring from a Dump Syntax →