Bug #48443 com_* variables going backwards
Submitted: 30 Oct 2009 18:22 Modified: 3 Nov 2009 16:47
Reporter: Bogdan Kecman Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.0.67 OS:Windows (WIN 2003 rc2 )
Assigned to: CPU Architecture:Any

[30 Oct 2009 18:22] Bogdan Kecman
Description:
The com_* variables return to previous value and then continue.

for e.g. com_insert taken every 1 minute:

<value>2680303</value>
<value>2680303</value>
<value>2680303</value>
<value>2680304</value> <=== increases by one
<value>2680303</value> <=== goes back to a previous value
<value>2680304</value>
<value>2680307</value> <=== increases
<value>2680303</value> <=== goes back
<value>2680303</value>
<value>2680303</value>
<value>2680303</value>
<value>2680304</value>
<value>2680304</value>

How to repeat:
fetch com_* variables every minute and look if they are steady growing or not.

Suggested fix:
don't go backwards !
[31 Oct 2009 20:31] MySQL Verification Team
see bug #31222