首页 > 其他 > 详细

TPS/QPS

时间:2018-04-16 18:15:24      阅读:208      评论:0      收藏:0      [点我收藏+]
有很多人,自己TPS和QPS的关系都搞不清。
如下为基本的查询方式是,与计算公式! 拿走不谢!

MariaDB [(none)]> show global status like ‘questions‘;
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| Questions | 70991770 |
+---------------+----------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global status like ‘uptime‘;
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| Uptime | 485352 |
+---------------+--------+
1 row in set (0.00 sec)

Questions/ Uptime
QPS:146

MariaDB [(none)]> show global status like ‘com_commit‘;
+---------------+---------+
| Variable_name | Value |
+---------------+---------+
| Com_commit | 8960761 |
+---------------+---------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global status like ‘com_rollback‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Com_rollback | 117 |
+---------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global status like ‘uptime‘;
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| Uptime | 485432 |
+---------------+--------+
1 row in set (0.00 sec)

Com_commit + Com_rollback / Uptime
TPS:18

TPS/QPS

原文:http://blog.51cto.com/hexudong/2104011

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!