Query Mysql status _ MySQL

Querying Mysql status bitsCN.com

Query Mysql status

# Query Database Connection show full processlist; show status like '% Max_used_connections %'; show status like '% Threads_connected %'; # Current connections show status like '% table_lock % '; # table lock show status like 'innodb _ row_lock % '; # row lock show status like' % qcache % '; # Query cache status show variables like "% query_cache % "; show status like 'qcache % '; show variables like "% binlog %"; show status like 'aborted _ clients'; # The connection is dead because the client does not properly close the connection, dropped connections: show variables like '% max_connections %'; show variables like '% timeout %'; show variables like 'log _ % '; # Check Whether logs are started

BitsCN.com