TPS/QPS

有很多人，自己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 |

Questions/ Uptime

QPS：146

MariaDB [(none)]> show global status like 'com_commit';

+---------------+---------+

| Variable_name | Value |

| Com_commit | 8960761 |