This article discusses about some MySQL performance tips which are collected over Internet and based on the experience of the author (me ^__^). Specific Query Performance Tips (see also database design tips for tips on indexes):  Use EXPLAIN to profile the query execution plan  Use Slow Query Log (always have it on!) […]