[MySQL Status] Queries, Questions, read/s differences, Com_Commit and handle_commit,
Queries: this status variable indicates the number of Queries received by the mysql System, including the query Questions in the stored procedure. This status variable indicates the number of Queries received by the mysql system, but it does not include the query of show engine innodb status-> [Row Operations]-> reads/s in the stored procedure. This is calculated through reads. reads = state variable Innodb_buffer_pool_read_requests Com_Commit: handle_commit: the number of internal commit executions passes preliminary execution. com_commit does not record implicitly committed transactions. Therefore, it is inaccurate to use com_commit for tps calculation if implicit commit is enabled. Handle_commit, because it contains the number of internal commit, it may be larger than the actual commit for calculation.