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

Effective MySQL之SQL語句最佳化小結

相關文章