mysql TPS和qps查询sql

本文主要是介绍mysql TPS和qps查询sql，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

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; 

这篇关于mysql TPS和qps查询sql的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---