MySQL Bugs: #17232: Slow Query Counter Increases continiously.

Bug #17232	Slow Query Counter Increases continiously.
Submitted:	8 Feb 2006 11:10	Modified:	21 Jul 2006 12:47
Reporter:	Charlie Farrow	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.9	OS:	Windows (WIN XP SP2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any
Tags:	Monitoring

Description:
The slow query counter increase all the time; It appears the cause is somewhat non-buggy, but should be clearly considered a bug.

The slow query counter logs queries that are slow OR that do not use indeces. Hence when mysql administrator is on a page showing the graphs, it is requesting the status variables which do not use indexs and hence incrementing the slow query log.

This causes the slow query value to increase forever.

How to repeat:
Just try it and look at the variable!

Suggested fix:
I'm not sure, i assume this bug will effect the server also. Maybe we should introduce an alternative method of getting mysql status variables from the server?

Clearly this has two issues; 1) It makes the slow query log even more os an issue and 2) Performance when loggine these queries.

Sorry, Ammended statsu to S3, accidentilly set at S1.

Sorry, Ammended statsu to S3, accidentilly set at S1.

Thank you for the bug report.

Still happens in 1.1.9

MySQL Administrator simply displays the values returned by the server. This needs to be addressed on server side. Hiding the real value from the user by faking a normalized value would be even worse.

Please file a bug report for the server if you want this to be addressed.