本文共 834 字,大约阅读时间需要 2 分钟。
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 会更加准确。
转载地址:http://hoodl.baihongyu.com/