mysql qps 计算_请问MYSQL数据库QPS,TPS采用哪种计算方式？

Questions 其实包括了 很多sql语句的执行，ddl, dml, show, set等。

比如 SHOW GLOBAL STATUS LIKE 'Questions';也会计算在内的。

The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the [`Queries`](https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html#statvar_Queries) variable. This variable does not count `COM_PING`, `COM_STATISTICS`, `COM_STMT_PREPARE`, `COM_STMT_CLOSE`, or `COM_STMT_RESET` commands.

The discussion at the beginning of this section indicates how to relate this statement-counting status variable to other such variables.

QPS，如果不考虑存储过程的执行，可以采用 QPS=(Com_select + Com_insert + Com_delete + Com_update) / Uptime 。

不过，要相对准确表达QPS， 采用 QPS=Questions/Uptime 计算。

TPS的话，采用TPS=(Handler_commit + Handler_rollback)/Uptime 会更加准确。