中文解釋show status;
有一個腳本可以測試效能
http://homeserver.com.tw/2011/04/07/mysql-show-status/
show status和show global status不同
http://dba.stackexchange.com/questions/54337/difference-between-show-status-and-show-global-status-in-mysql
show processlist
http://alvinalexander.com/blog/post/mysql/how-show-open-database-connections-mysql
show global status介紹
http://lxneng.iteye.com/blog/451985
show processlist中有sleep狀態的連線
http://mool.pixnet.net/blog/post/25219480-mysql-processlist-%E4%B8%80%E5%A4%A7%E5%A0%86sleep-
mysql console下/P
http://www.psce.com/blog/2012/03/28/how-to-work-with-a-long-process-list-in-mysql/
show processlist中的狀態列表
http://www.t086.com/article/4818
connection太多
http://dba.stackexchange.com/questions/1558/how-long-is-too-long-for-mysql-connections-to-sleep
修改wait_time和interactive_timeout
mysql -h ma19.ap-southeast-1.rds.amazonaws.com -P 3306 -u root -pgodie -e 'show variables;'
確認設定值
http://www.pc-freak.net/blog/monitoring-mysql-server-queries-and-debunning-performance-slow-query-issues-in-console-terminal-with-native-mysql-commands-mtop-mytop/
即時看MySQL狀態，如mytop、watch + show processlist
http://dba.stackexchange.com/questions/42532/format-of-mysql-query-log
yymmdd hh:mm:ss thread_id command_type query_body
http://blog.shlomoid.com/2008/06/how-to-perform-connection-massacre.html
快速刪除大量thread/process
中文解釋各項設定值
Here1
Here2
Explain指令介紹
man mysql
http://linux.die.net/man/1/mysql
# mysql -h mydb.ap-southeast-1.rds.amazonaws.com -P 3306 -u root -p[密碼] -e 'show processlist;'
Window (2)