Solved

MySQL Error : Socket In Use

Posted on 2011-03-22
1
1,180 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
[X]
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
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Happy holidays! Your Ops team can pack their bags. IT management and IT management tools are dead. Or at least that’s according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering.
Or at least that’s the word according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering. According to the blog, AWS is launching their AWS MS program to expedite the adoption of cloud by Fortune 1000 and Global 2000 companie…
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.

687 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