mysql performance tips

  • Some MySQL performance tips

    ByConan

    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!)  Don’t use DISTINCT when you…