Bug #2524 mysqladmin status Questions rollover causes avg to show wrong.

• Submitted: 26 Jan 2004 16:57
• Modified: 29 Jan 2004 4:32
• Reporter: Brad Dameron
• Status: Won't fix
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 4.0.16
• OS: Linux (Redhat 8 Linux)
• CPU Architecture: Any

[26 Jan 2004 16:57] Brad Dameron

Description:
if you do a "mysqladmin status" the "Questions" display rolled over after so many billion questions thus causing the "Queries per second avg:" to show incorrectly. Showed we were doing 78 questions per second when we were actually averaging 1250. 

How to repeat:
Do several billion questions to cause Questions display to rollover to 0.

Suggested fix:
Fix average to reset when Questions resets.

[29 Jan 2004 4:32] Alexander Keremidarski

Like with any other statistics variable Questions can be overflowed and there is nothing we can do about it.

It is of LONG type. On 64-bit platform it is much bigger so it is not that easy, but is still possible.

It does not make much sense to monitor all statistics values and if some of them reaches maximum to "adjust" the others.