MySQL Forums
Forum List  »  Performance

Re: "Can't create tcp/ip socket (24)" warning message
Posted by: Rick James
Date: March 27, 2010 09:31PM

That sounds like an OS error, not a MySQL error.

If you really need 1500 connections, you should seriously consider master-slave setup. With a load balancer in front of the slaves you could scatter reads evenly across multiple machines.

If you need 1500 connections that will do writes, that gets messier.

I often see servers executing hundreds of queries per second, but with an average of only about 1 thread running (lots of others sleeping). When I see more than 10 threads doing work, I worry that the queries need optimizing.

If your threads are coming from web servers, each 'page' should connect, do its work, and disconnect. This keeps the number of connections somewhat limited.

How is a single "user" going to have 1500 connections? Will he have 1500 machines doing work? Sounds like a hacker/spammer/robot.

Options: ReplyQuote

Written By
Re: "Can't create tcp/ip socket (24)" warning message
March 27, 2010 09:31PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.