本文介绍了如何通过MySQL的全局状态变量来计算数据库的QPS（Queries Per Second）和TPS（Transactions Per Second）。通过示例查询`Questions`、`Uptime`、`Com_commit`和`Com_rollback`等状态变量，计算得到QPS约为146，TPS约为18。这有助于数据库管理员理解和优化数据库性能。
有很多人，自己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
921
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
