Optimization
Optimization of both MySQL server and SQL queries is the process that starts from clearness of your application.
MySQL manuals
Understanding MySQL EXPLAIN
MySQL free management tools
- HeidiSQL - GUI Windows tool
- Sequel Pro - GUI Mac OS X tool
- Adminer - lite web tool
- PhpMyAdmin - power web tool