Hi Hervé, On Sat, Jan 16, 2010 at 11:34:38PM +0100, Herve COMMOWICK wrote: > Hi Cyril, > > You forgot the log-error option that much sysadmin use for correct debugging > without pollution, but i don't think it logs incorrect logging (if i > remember well). > > The Authentication packet is mandatory for preventing blocking, but i don't > know if the check of the response is really interesting. > My first thought was it can detect integrity error on the "mysql" database, > but i hope MySQL can detect this kind of error in another way and display > errors in the Handshake initialization packet. On the other side, it can > detect server load, but i also think it can be detected in another way > because it is not so reliable. > > By the way, Willy, do what you think better. ;-)
I don't know mysql and don't even have one for testing. But experience shows that for a default test to be widely used, it must be easy to set up, not have side effects, and if possible not cause undesired logging. For instance, I'm pretty sure that most users would prefer a lighter check which does not require setting up a user than a deeper one which requires a user. However, if providing the user brings a far better test coverage, it can be nice to have it as an option. That way users decide how to check their servers. Hoping this helps you figure how to arrange this test. If you want we can discuss that on monday. Regards, Willy
