超简单的qps统计方法(推荐)
统计最近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 | 11530 |
+---------------+---------+
6 rows in set (5.00 sec)
统计db启动以来的qps值,慢查询数量等信息
mysql> \s
--------------
mysql ver 14.14 distrib 5.5.35, for linux (x86_64) using readline 5.1
connection id: 98313987
current database: udb
current user: ucloud@172.23.0.48
ssl: not in use
current pager: stdout
using outfile: ''
using delimiter: ;
server version: 5.5.35-log mysql community server (gpl) by remi
protocol version: 10
connection: 172.23.9.201 via tcp/ip
server characterset: utf8
db characterset: utf8
client characterset: utf8
conn. characterset: utf8
tcp port: 3206
uptime: 274 days 1 hour 22 min 29 sec
threads: 172 questions: 7559640986 slow queries: 150149138 opens: 7799 flush tables: 15 open tables: 973 queries per second avg: 319.261
以上这篇超简单的qps统计方法(推荐)就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持。