运行中的mysql状态查看,对正在运行的mysql进行监控，其中一个方式就是查看mysql运行状态。(1)QPS(每秒Query量)QPS = Questions(or Queries) / secondsmysql show global status like Question%;(2)TPS(每秒事务量)TPS = (Com_commit + Com_rollback) / secondsmysql show global status like Com_commit;mysql show global status like Com_rollback;(3)key Buffer 命中率mysqlshow global status like key%;key_buffer_read_hits = (1-key_reads / key_read_requests) * 100%key_buffer_write_hits = (1-key_writes / k
