MySQL Error : Socket In Use

Hello,

I have a Windows Server 2008R2 box running in the cloud (on Amazon EC2) with IIS enabled.  Our datastore is a MySQL box (hosted on Amazon RDS) on the same region/local network as my web server.

Despite both the web server and mysql box being on the same network, I am getting occasional socket error messages during peak use (when in reality, the peak use isn't that significant at all).  I'm looking to find out how to resolve this:

Server was unable to process your request.  --> Can't connect to MySQL server on 'hostname' (10061): Only one usage of each socket address (protocol/network/address/port) is normally permitted 10.76.249.164:3306 --> Only one usage of each socket address (protocol/network/address/port is normally permitted)

As a web server, there will be many concurrent connections to the mysql server.  Why am I getting errors about the socket address already being in use.  How do I gracefully handle this situation?
millwebAsked:
Who is Participating?
 
SwafnilConnect With a Mentor Commented:
I found the following article about the topic on MSDN with some hints on how to fix it:

http://blogs.msdn.com/b/dgorti/archive/2005/09/18/470766.aspx

The problem seems to be that the dynamically assigned MySQL connection port on the MySQL client can not be opened because all ports have already been used; each call to the MySQL server uses one dynamically assigned port on the client-side for as long as the connection is open and alive, so if you are opening a lot of connections in peak times, you'll run out of client ports.

The resolution is to increase the amount of parallel connections which is done by modifying the registry on the web server side. For in-detail information, check the above link and see if this helps.

Regards, Sascha
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.