Results 1 to 10 of 10
  1. #1
    Join Date
    May 2009
    Posts
    288

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

    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?

  2. #2
    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.

  3. #3
    Join Date
    May 2009
    Posts
    288
    Quote Originally Posted by linux-engineer View Post
    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.
    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?

  4. #4

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

    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

  5. #5
    Join Date
    May 2009
    Posts
    288
    if i don't make connections unlimited, then some players won't be able to connect to the server.

  6. #6
    But any given day if you have unlimited connections this issue will persists where you will have to restart Mysqld

  7. #7
    Join Date
    May 2009
    Location
    SLASH ROOT
    Posts
    853
    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..

  8. #8
    Join Date
    Jun 2006
    Posts
    1,111
    Quote Originally Posted by hypebeast View Post
    if i don't make connections unlimited, then some players won't be able to connect to the server.
    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?

  9. #9
    Join Date
    May 2009
    Location
    SLASH ROOT
    Posts
    853

  10. #10
    Join Date
    May 2005
    Location
    New York
    Posts
    736
    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
    Perigee Global Corporation
    Design, Development and Hosting Solutions
    Dedicated Servers, CDN, Hosted E-Mail, Web Hosting, VPS & Cloud Servers
    1.212.400-7632 www.perigeeglobal.com

Similar Threads

  1. local mysql server name, IP or localhost?
    By surfmanjoe in forum Hosting Security and Technology
    Replies: 2
    Last Post: 06-29-2007, 11:48 AM
  2. unable to connect localhost(10061)
    By mooodi in forum Hosting Security and Technology
    Replies: 5
    Last Post: 04-06-2007, 03:36 AM
  3. Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    By manisha_khtri in forum Hosting Security and Technology
    Replies: 2
    Last Post: 06-05-2006, 10:05 AM
  4. cannot connect to localhost
    By SmartTux in forum Hosting Security and Technology
    Replies: 11
    Last Post: 03-28-2005, 08:34 PM
  5. Replies: 5
    Last Post: 05-11-2004, 12:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •