bitscn.com
查询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_%'; #查看日志是否启动
bitscn.com