mysql qps如何查看_超简单的qps统计方法(推荐)

最新推荐文章于 2024-09-19 02:15:14 发布

小方有点小方

最新推荐文章于 2024-09-19 02:15:14 发布

阅读量1.7k

点赞数

文章标签： mysql qps如何查看

本文链接：https://blog.csdn.net/weixin_42539414/article/details/113223015

版权

本文介绍了两种在MySQL中查看QPS（每秒查询数）的方法：一种是实时统计最近N秒内的QPS值，包括SELECT、INSERT等操作；另一种是通过`s`命令查看自数据库启动以来的QPS、慢查询数量等信息。这些方法可以帮助管理员监控数据库性能。

摘要由CSDN通过智能技术生成

统计最近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 | 3 |

| NULL