最简单的qps统计方法

最新推荐文章于 2025-07-01 17:38:57 发布

胡儿胡儿

最新推荐文章于 2025-07-01 17:38:57 发布

阅读量5.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签： qps

本文链接：https://blog.youkuaiyun.com/cug_jiang126com/article/details/50164677

通过MySQL查询语句实时统计最近5秒内的QPS（每秒查询数），包括SELECT, INSERT, UPDATE, REPLACE, DELETE操作。同时展示如何获取数据库启动以来的QPS值和慢查询数量等信息。" 89448998,7406235,Linux常用命令详解与实战,"['Linux命令', '系统管理', '文件操作', '网络工具', '进程管理']

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

统计最近N秒内的QPS值(包括每秒select，insert等值)

mysql> select variable_name,sum(per_sec) as qps from (select straight_join lower(gs0.variable_name) as variable_name, (gs1.variable_value - gs0.variable_value)/5 as per_sec from ( select variable_name ,variable_value from information_schema.global_status where variable_name in ('com_select','com_update','com_insert','com_replace','com_delete') union all select '',sleep(5) from dual ) as gs0 join information_schema.global_status gs1 using (variable_name)) t group by variable_name with rollup;

+---------------+---------+
| variable_name | qps |
+---------------+---------+
| com_delete | 0 |
| com_insert | 2.2 |
| com_replace | 0 |
| com_select | 11524.8 |
| com_update | &