Skip to content

Instantly share code, notes, and snippets.

@v1nc3ntlaw

v1nc3ntlaw/mysql slow queries analyse tool

Created August 9, 2010 15:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save v1nc3ntlaw/515578 to your computer and use it in GitHub Desktop.
Save v1nc3ntlaw/515578 to your computer and use it in GitHub Desktop.
Download ZIP
mysql slow queries analyse tool
Raw
mysql slow queries analyse tool
wget http://hackmysql.com/scripts/mysqlsla
chmod +x mysqlsla-2.03
sudo ./mysqlsla-2.03 /var/log/mysql/mysql-slow.log
# 預設會列出 top 10 的 slow quires
# 可以帶參數 --top 13 修改列出的項目數量
# 通常網路上都說從 top 1, 2, 3 的 slow quires 去修
# 是對增進效能最有幫助的！
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment