mysql qps如何查看_mysql状态查看 QPS/TPS/缓存命中率查看

运行中的mysql状态查看

对正在运行的mysql进行监控，其中一个方式就是查看mysql运行状态。

(1)QPS(每秒Query量)

QPS = Questions(or Queries) / uptime

mysql > show  global  status like 'Question%';

mysql > show  global  status like 'uptime%';

(2)TPS(每秒事务量)

TPS = (Com_commit + Com_rollback) / uptime

mysql > show global status like 'Com_commit';

mysql > show global status like 'Com_rollback';

mysql > show  global  status like 'uptime%';

(3)key Buffer 命中率

mysql>show  global   status  like   'key%';

key_buffer_read_hits = (1-key_reads / key_read_requests) * 100%

key_buffer_write_hits = (1-key_writes / key_write_requests) * 100%

(4)InnoDB Buffer命中率

mysql> show status like 'innodb_buffer_pool_read%';

innodb_buffer_read_hits = (1 - innodb_buffer_p