Questions
The number of statements executed by the server. As of MySQL 5.0.72, this includes only statements sent to the server by clients and no longer includes statements executed within stored programs, unlike the Queries variable. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands.
原文请参考:
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Questions
也就是说在MySQL 5.0.72版本之前,在存储过程里中执行的语句都会被算到Questions这个指标里,在5.0.72版本之后,只会计算一次。
所以这就导致在使用了存储过程的MySQL DB实施版本升级之后会发现,Qustions量的突然变化。
关于此,MySQL还有一个Bug记录,可以参考:
http://bugs.mysql.com/bug.php?id=24289
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29154652/viewspace-776531/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29154652/viewspace-776531/