Solved

MySQL Error : Socket In Use

Posted on 2011-03-22
1
1,080 Views
Last Modified: 2014-11-12
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?
0
Comment
Question by:millweb
1 Comment
 
LVL 7

Accepted Solution

by:
Swafnil earned 500 total points
Comment Utility
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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now