查詢Mysql狀態

查詢Mysql狀態  

#查詢數據庫連接
show full  processlist;
show status like '%Max_used_connections%';
show status like '%Threads_connected%';#當前連接數
show status like '%table_lock%';#表鎖定
show status like 'innodb_row_lock%';#行鎖定
show status like '%qcache%'; #查詢緩存情況
show variables like "%query_cache%";
SHOW STATUS LIKE 'Qcache%'; 
show variables like "%binlog%";
show status like 'Aborted_clients';#由於客戶沒有正確關閉連接已經死掉，已經放棄的連接數量
show variables like '%max_connections%';
show variables like '%timeout%';
show variables like 'log_%'; #查看日志是否啟動