Re: MySQL stops authenticating remote connections

[Pär Iwarson]

Have you solved the problem?

We currently have a very similar problem. The only difference is that it´s not permanently frozen and we don't need to restart mysql. But this result in a very unstables webserver where the CPU Usage is very volatile and goes up and down between 0 and 100%. When it's down to zero it build up a large queue due to the fact that MySQL has frozen the connections. When MySQL works again it runs for 100% and then down again etc.

We use version 4.0.21 on a FreeBSD Linux. The web server is on a Windows Server 2003 Web Edition.

The problem started for us when MySQL hang due to no disc space left. The bin-log grew too big and we forgot to purge the bin logs. However, since that crash we have had this problem that is very similar to yours.

We run a pretty busy website and MySQL is under quit heavy load sometimes. The problem is more severe under heavy load but seem to be there even when the site is not that busy.

I would be interesting to here if you managed to solve the problem and how you solved it. We have no solution to our problem right now :/