Need Help Increasing MYSQL Connections!

Discussion in 'Site & Server Administration' started by Asus-Games, Feb 15, 2009.

  1. #1
    I have a small VPS and up to now I've never had to increase the max MYSQL connections. I'd love some help in this depertment:

    Step By Step, exactly what I need to type in SSH to get this to work right.

     
    Asus-Games, Feb 15, 2009 IP
  2. ipdedicated

    ipdedicated Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If it doesn't exist, create the file /etc/my.cnf and add the following lines:

    [mysqld]
    max_connections=300

    You can change 300 for whatever you wish.
     
    ipdedicated, Feb 16, 2009 IP
  3. Asus-Games

    Asus-Games Peon

    Messages:
    582
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks. It was set to 100 and with 50 sites all running heavy, the server was spitting out errors like no tomorrow.
     
    Asus-Games, Feb 16, 2009 IP
  4. ipdedicated

    ipdedicated Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You're welcome :)
     
    ipdedicated, Feb 16, 2009 IP