[摘要]+---------------+--------+1 row in set (0.00 sec)QPS=(com_update+com_insert+com_delete+com_select)/...
+---------------+--------+
1 row in set (0.00 sec)
QPS=(com_update+com_insert+com_delete+com_select)/uptime=3076,某一时间段内的QPS查询方法同上。
2 TPS计算(每秒事务数)
mysql> show global status like 'com_commit';
+---------------+---------+
关键词:MySQL几点重要的性能指标计算与优化的办法代码总结