Can't connect to MySQL server on 'localhost' (10055)

Portal Home > Knowledgebase > Articles Database > Can't connect to MySQL server on 'localhost' (10055)

Posted by hypebeast, 06-24-2009, 01:25 PM
Do you guys know anything about this? My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly. Do you guys have any idea why this happen? I do have a lot of connections coming in and out of my server. Would that mean anything?
Posted by linux-engineer, 06-24-2009, 01:37 PM
Have you checked the number of Mysql connections you are making ? in /etc/my.cnf you can check the number of Mysql connections. max_connections=100 Else set it probably 30 would be fine to resolve this issue.
Posted by hypebeast, 06-24-2009, 01:49 PM
i have set it at 99999999 because i run a game server and i need all the players i can get. right now, at peak times, i have 600 players online. my computer specs: core2duo 2.83ghz processor 4gb ram 100mbit unmetered shared windows2k3 server 32bit could there be anything wrong with the server i currently have? like, would i need to upgrade or somethign?
Posted by linux-engineer, 06-24-2009, 01:53 PM
99999999 connections are too excessive. I would recommend you to set it in limit else Mysql could consume all resources and get system to get unresponsive
Posted by hypebeast, 06-24-2009, 02:35 PM
if i don't make connections unlimited, then some players won't be able to connect to the server.
Posted by linux-engineer, 06-24-2009, 02:46 PM
But any given day if you have unlimited connections this issue will persists where you will have to restart Mysqld
Posted by WHR-Abner, 06-24-2009, 04:52 PM
Sounds like you have a busy MySQL server.. I would suggest you to Load Balance your database server for uninterrupted service. I have personally tried and set up DRBD with MySQL in a couple of servers. They run smoothly and the data sync time is okay for me... If you want any admin help or tips, do PM me..
Posted by DevMonkey, 06-24-2009, 05:06 PM
You only have around 600 concurrent players though? So a limit of 700-800 would easily support this with room to grow, you can extend it in future. Is this machine only being used for mysql or does it also host the websites etc?
Posted by WHR-Abner, 06-24-2009, 05:15 PM
I missed one point.. Raise the values for both max_connections as well as max_user_connections. Let me know if that helped..
Posted by jNive, 06-24-2009, 07:14 PM
I don't think anyone needs unlimited connections on a MySQL server :-) Figure out how many you need, whether your server will be able to handle it, and set the limit to 25% above the peak estimate. Might be worth checking the other MySQL settings also regarding table caching, persistant connections, memory usage etc