統(tǒng)計(jì)最近N秒內(nèi)的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)
統(tǒng)計(jì)db啟動(dòng)以來的qps值，慢查詢數(shù)量等信息
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
以上這篇超簡(jiǎn)單的qps統(tǒng)計(jì)方法(推薦)就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持腳本之家。
您可能感興趣的文章:- Mysql數(shù)據(jù)庫(kù)的QPS和TPS的意義和計(jì)算方法
- 你的服務(wù)器IIS最大并發(fā)數(shù)有多少？
- 在apache下限制每個(gè)虛擬主機(jī)的并發(fā)數(shù)！！！！
- redis通過pipeline提升吞吐量的方法
- springboot高并發(fā)下提高吞吐量的實(shí)現(xiàn)
- TPS(吞吐量)、QPS(每秒查詢率)、并發(fā)數(shù)、RT(響應(yīng)時(shí)間)是什么意思
