EXPLAIN Output Format

MySQL Storage Engines List

Restrictions and Limitations on Partitioning

optimizer_switch的引入和配置

关于最佳数据架构（基准测试在优化SQL语句的作用）

mysqldumpslow — Summarize Slow Query Log Files

MySQL DML stats per table

使用mysqlbinlog命令为二进制日志生成聚合信息

$ mysqlbinlog /path/to/mysql-bin.000999 | \

grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter" | \

cut -c1-100 | tr '[A-Z]' '[a-z]' | \

sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$//" | sed -e "s/ where .*$//" | \

sort | uniq -c | sort -nr

ITPub博客

Effective MySQL之SQL语句优化小结