MySQL Bugs: #17963: Instance Manager: server monitoring changes global connection statistics

Bug #17963	Instance Manager: server monitoring changes global connection statistics
Submitted:	6 Mar 2006 13:45	Modified:	18 Oct 2007 10:28
Reporter:	Giuseppe Maxia	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	Instance Manager	Severity:	S4 (Feature request)
Version:	5.0.18, 5.1.7	OS:	Linux (Linux)
Assigned to:	Alexander Nozdrin	CPU Architecture:	Any
Tags:	Instance Manager

Description:
Due to its specific implementation (as explained in bug #14318), the instance manager tries to connect to each instance using a fake username and password.
This fact affects the server counts of connections and  aborted connections, making these statistics almost meaningless.

How to repeat:
After a successful start of the instance manager, open a client and check the server statistics:
show /*!50001 global */ global status like "Connections";
show /*!50001 global */ status like "aborted_connects";
You will notice that the value for  aborted_connects and Connections will increase every 20 seconds (or less, if you changed the monitoring-interval variable).

Suggested fix:
Use some other method to check if the instance is alive.

Thank you for a problem report. What you ask for sounds like a feature request for me. Do you agree with this severity?

I don't think this is a simple feature request. In my opinion, it's a bug, because the instance manager is creating a unwanted side effect with its behavior.
In some of my servers, I am using the connection statistics returned by "show status" to decide when to start investigating suspect entries. If I use the instance manager, these statistics become useless. Thus, it's a bug, albeit a non-critical one.

Sorry, but intentionally implemented and documented behaviour is a feature, functionality (even if it is not useful and can lead to problems), not a bug. If you do want it to be implemented another way, it is a feature request. Reasonable, in this case:

"IM should work without changing connection statistics considerably."

OK. 
I give up. It's a feature request.

Giuseppe