mysql TPS和qps查询sql

最新推荐文章于 2025-06-10 15:16:25 发布

原创最新推荐文章于 2025-06-10 15:16:25 发布 · 2.2k 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

11 篇文章

订阅专栏

博客提及了TPS查询和QPS查询，这两者在信息技术领域常用于衡量系统性能。TPS反映系统每秒处理的事务数，QPS则体现每秒的查询率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

TPS查询

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查询

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;