MySQL中TPS和QPS的计算方式

最新推荐文章于 2024-06-11 14:09:38 发布

转载最新推荐文章于 2024-06-11 14:09:38 发布 · 182 阅读

本文详细介绍了如何计算MySQL服务器的TPS（每秒事务处理量）和QPS（每秒查询处理量）。通过查询GLOBAL_STATUS表获取COM_COMMIT、COM_ROLLBACK和QUESTIONS的值，再结合UPTIME，计算得出TPS和QPS。

TPS - Transactions Per Second（每秒传输的事物处理个数），即服务器每秒处理的事务数，如果是InnoDB会显示，没有InnoDB就不会显示。
TPS = (COM_COMMIT + COM_ROLLBACK)/UPTIME

use information_schema;
select VARIABLE_VALUE into @num_com from GLOBAL_STATUS where VARIABLE_NAME ='COM_COMMIT';
select VARIABLE_VALUE into @num_roll from GLOBAL_STATUS where VARIABLE_NAME ='COM_ROLLBACK';
select VARIABLE_VALUE into @uptime from GLOBAL_STATUS where VARIABLE_NAME ='UPTIME';
select (@num_com+@num_roll)/@uptime;

QPS - Queries Per Second（每秒查询处理量）MyISAM 引擎
QUESTIONS/UPTIME

use information_schema;
select VARIABLE_VALUE into @num_queries from GLOBAL_STATUS where VARIABLE_NAME ='QUESTIONS';
select VARIABLE_VALUE into @uptime from GLOBAL_STATUS where VARIABLE_NAME ='UPTIME';
select @num_queries/@uptime;

来源于网络

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21601207/viewspace-741749/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21601207/viewspace-741749/