Need HELP ASAP!!!

Discussion in 'MySQL' started by hitboy, Sep 1, 2007.

0
  1. #1
    ok so I am getting the "too many connections" deal with my sites... I know this is because there is a current mysql limit of connections. I am currently on a dedicated server can anyone tell me how I get rid of these connection limits or how I increase them? Thanks :rolleyes:
     
    hitboy, Sep 1, 2007 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    You can edit the file my.cnf and change the value of MAX_CONNECTIONS

    Open the file my.cnf, find the line containing the variable MAX_CONNECTIONS and increase it say:

    set-variable = max_connections=500

    You may have to restart mysql after this.

    It is always a good idea to make a backup copy of your original my.cnf file, just in case.
     
    Kuldeep1952, Sep 1, 2007 IP
  3. hitboy

    hitboy Well-Known Member

    Messages:
    2,939
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    170
    #3
    hmm i looked in the /etc folder and my my.cnf file isnt there any ideas how to find it?
     
    hitboy, Sep 1, 2007 IP
  4. hfweb

    hfweb Peon

    Messages:
    36
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Check,

    /etc/mysql/my.cnf

    ;)
     
    hfweb, Sep 1, 2007 IP
  5. hitboy

    hitboy Well-Known Member

    Messages:
    2,939
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    170
    #5
    i fixed this problem i had to just have one created..
     
    hitboy, Sep 1, 2007 IP