关于MySQL的TPS和QPS

来源:互联网 时间:1970-01-01


关于MySQL的TPS和QPS,有需要的朋友可以参考下。


TPS - Transactions Per Second(每秒传输的事物处理个数),这是指服务器每秒处理的事务数,支持事务的存储引擎如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 (@[email protected]_roll)/@uptime;




QPS - Queries Per Second(每秒查询处理量)同时适用与InnoDB和MyISAM 引擎

计算方法:

QPS=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;


版权声明:本文为博主原创文章,未经博主允许不得转载。



相关阅读:
Top