View the running mysql status to monitor the running mysql. One way is to view the mysql running status. Www.2cto.com (1) QPS (Queries per second) QPS = Questions (or Queries)/seconds mysql> show global status like 'Question % '; (2) TPS (transaction volume per second) TPS = (Com_commit + Com_rollback)/seconds mysql> show global status like 'com _ commit '; mysql> show global status like 'com _ rollback'; (3) key Buffer hit rate mysql> show global status like 'key % '; key_buffer_read_hits = (1-key_reads/key_read_requests) * 100% key_buffer_writ E_hits = (1-key_writes/key_write_requests) * 100% (4) InnoDB Buffer hit rate www.2cto.com mysql> show status like 'innodb _ buffer_pool_read % '; bytes = (1-bit/second) * 100% (5) Query Cache hit rate mysql> show status like 'qcache % '; Query_cache_hits = (Qcahce_hits/(Qcache_hits + Qcache_inserts) * 100%; (6) table Cache status quantity mysql> show global Status like 'open % '; compare open_tables and opend_tables values (7) Thread Cache hit rate mysql> show global status like 'thread %'; mysql> show global status like 'connections '; thread_cache_hits = (1-Threads_created/connections) * 100% (8) locked mysql> show global status like '% lock %'; Table_locks_waited/Table_locks_immediate = 0.3% if the ratio is large, the blocking caused by table locks is serious. Innodb_row_lock_waits innodb row locks are too large, which may be caused by gap locks (9) replication delay m. Ysql> show slave status view latency (10) Tmp Table status (temporary Table status) mysql> show status like 'create _ tmp % '; Created_tmp_disk_tables/Created_tmp_tables ratio should not exceed 10%, if the value of Created_tmp_tables is large, it may be that there are too many sort sentences or the number of connected sentences is not optimized enough (11) Binlog Cache Usage mysql> show status like 'binlog _ cache % '; if the Binlog_cache_disk_use value is not 0, you may need to increase the binlog_cache_size (12) Innodb_log_waits volume. mysql> show status like 'innodb _ log_waits '; Innodb_log_w If the aits value is not equal to 0, it indicates that innodb log buffer is waiting for space shortage, for example, the command >#show global status; although you can use: ># show global status like %... %.