This is an old revision of the document!
MySQL Tips & Tricks
Part of MySQL
Use Indexes
Pros: Massive increase in searching performance.
Cons: Slightly Increase in Storage Requirements. Slightly Increase on Write speeds.
Example:
ALTER TABLE table_name ADD INDEX index_name (column);
Enforce Data Integrity at the DB Level
Eg.: unique constraints, cascade deletes
Pros: Application agnostic Data Integrity
Cons: -
Log Queries in Development
Pros: Great to see Queries happening in Real Time
Cons: Slightly higher storage requirement
Don't forget to disable in Production
Usage:
Update my.cnf and add / change:
general_log_file = /var/log/mysql_queries.log general_log = 1