1.MyISAM 表锁状态
show status like 'table%';
Table_locks_immediate | 136
Table_locks_waited | 4
2.InnoDB 行锁状态
show status like 'innodb_row%';
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
3.各种语句执行情况
show status like 'com_%';
| Com_select | 11 |
| Com_update | 0 |
...
4.服务器运行时间
show status like 'uptime';
5.索引使用情况
show status like 'handler_read%';
| Handler_read_first | 0 |
| Handler_read_key | 6 | //使用到的索引次数
| Handler_read_last | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_deleted | 0 |
| Handler_read_rnd_next | 631 | //值越高,索引效率越低
6.MySQL 连接次数
show status like 'connections';
7.慢查询次数
show status like 'slow_queries';
8.表缓存
show status like 'open_tables'; //当前打开的表缓存
show status like 'opened_tables'; //曾经打开的表缓存
9. show status like 'last_query_cost'; // 查询成本
| Last_query_cost | 1.799000 |