Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MySQL Error : Socket In Use

Posted on 2011-03-22
1
1,146 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
ID: 35196608
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
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.

828 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