Hi all, I've been unable to find a single reference to the thread status of "unauthenticated user" on any mysql documentation - from time to time I get this status when connecting from one particular host. The real problem is that whilst in this state the requesting host appears to those accessing the database from it to be hung for a few minutes before being correctly connected. The only way I've found to get around it is to 'mysqladmin reload' the database (which provides a temporary solution). The database is accessed by multiple hosts, yet it is only this one that has difficulties.
The version of mysql I'm using is described as Ver 10.4 Distrib 3.23.12c-alpha, for sun-solaris2.7 (sparc) Unfortunately upgrading to a newer version is not a quick option as the database is used to record statistics from multiple devices at five minute intervals as well as being used by customers to view their statistics and is over 50GB in size.
