超简单的qps统计方法(推荐)
统计最近N秒内的QPS值(包括每秒select,insert等值)
mysql>selectvariable_name,sum(per_sec)asqpsfrom(selectstraight_join lower(gs0.variable_name)asvariable_name, (gs1.variable_value-gs0.variable_value)/5asper_secfrom( selectvariable_name,variable_value frominformation_schema.global_statuswherevariable_namein('com_select','com_update','com_insert','com_replace','com_delete') unionall select'',sleep(5)fromdual )asgs0 joininformation_schema.global_statusgs1using(variable_name))t groupbyvariable_namewithrollup;
+---------------+---------+
|variable_name|qps |
+---------------+---------+
|com_delete | 0|
|com_insert | 2.2|
|com_replace | 0|
|com_select |11524.8|
|com_update | 3|
|NULL | 11530|
+---------------+---------+
6rowsinset(5.00sec)
统计db启动以来的qps值,慢查询数量等信息
mysql>\s
--------------
mysql Ver14.14Distrib5.5.35,forLinux(x86_64)usingreadline5.1
Connectionid:98313987
Currentdatabase:udb
Currentuser:ucloud@172.23.0.48
SSL:Notinuse
Currentpager:stdout
Usingoutfile:''
Usingdelimiter:;
Serverversion:5.5.35-logMySQLCommunityServer(GPL)byRemi
Protocolversion:10
Connection:172.23.9.201viaTCP/IP
Servercharacterset:utf8
Db characterset:utf8
Clientcharacterset:utf8
Conn. characterset:utf8
TCPport:3206
Uptime:274days1hour22min29sec
Threads:172 Questions:7559640986 Slowqueries:150149138 Opens:7799 Flushtables:15 Opentables:973 Queriespersecondavg:319.261
以上这篇超简单的qps统计方法(推荐)就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持毛票票。