Re: MySQL stops on Windows 2003

[Pär Iwarson]

I think you have the same problem we had. We have a webserver running on Windows 2003 Web Edition and the databaseserver MySQL 4.0.21 on a Linux.

Our problem was that the connection to the database suddenly broke for about 15 seconds up to a minute and then it worked fine until next time it broke. It broke down about 5-15 times a day. Very annoying.

Solution:
After checking network, ODBC and everything we could think of we finally found the answer in a registry key for TCP in the Windows Registry. To solve the problem you have to create a key in the registry called "TcpTimedWaitDelay". You probably don't have this key and then the default value is 240 seconds. And that is the time windows waits until it releases a port. You should therefore create the key with value 30 or 60 and then your problem will be gone. You can also look in to a registry key called "MaxUserPorts". But it is "TcpTimedWaitDelay" that solves the problem. Do a search on that key on Google and you will find a description on where to and how to create the key.

You can also read my answer in a thread in this forum for more information.

Good Luck!