MYSQL教程超简单的qps统计方法(推荐)

《MYSQL教程超简单的qps统计方法(推荐)》要点：
本文介绍了MYSQL教程超简单的qps统计方法(推荐)，希望对您有用。如果有疑问，可以联系我们。

MYSQL教程统计最近N秒内的QPS值(包括每秒select,insert等值)

MYSQL教程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;

MYSQL教程+---------------+---------+
| 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)

MYSQL教程统计db启动以来的qps值,慢查询数量等信息

MYSQL教程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

MYSQL教程以上这篇超简单的qps统计办法(推荐)就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持编程之家PHP.

欢迎参与《MYSQL教程超简单的qps统计方法(推荐)》讨论，分享您的想法，编程之家 52php.cn为您提供专业教程。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!