Bug #48443 com_* variables going backwards

• Submitted: 30 Oct 2009 18:22
• Modified: 3 Nov 2009 16:47
• Reporter: Bogdan Kecman
• Status: Duplicate
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.0.67
• OS: Windows (WIN 2003 rc2 )
• 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