The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MSQL 5.1 Error establishing a database connection

Discussion in 'Database Discussions' started by saamxvr, Dec 22, 2010.

  1. saamxvr

    saamxvr Well-Known Member

    Joined:
    Oct 30, 2010
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    Hello i have Intel(R) Xeon(TM) CPU 2.40GHz x4 , 2GB ram Dedicate server , im run 3 Wordpress site on it , my Server Load Averages is: 0.62 0.57 0.46

    Mostly i getting this error (Error establishing a database connection )
    I'm using MYSQL 5.1

    this is before optimized my.cnf

    this is after optimized my.cnf

    This is Tuner Result

     
  2. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Friendly moderator note

    I moved this thread to our Database Discussions section.
     
  3. GaryT

    GaryT Well-Known Member

    Joined:
    May 19, 2010
    Messages:
    321
    Likes Received:
    3
    Trophy Points:
    16
    *** MySQL's maximum memory usage is dangerously high ***
    *** Add RAM before increasing MySQL buffer variables ***


    max_connections=500

    Put this to max_connections=100 - why do you need 500 ? Your not running ebay are you ?

    This means make it higher.

    so now your my.cnf should look like:

     
  4. saamxvr

    saamxvr Well-Known Member

    Joined:
    Oct 30, 2010
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    Yes i will add this Thanks lot .!!!

    one more question why MSQL server restarting auto ? i was use 5.0 , now im use 5.1 , i never face this problem on 5.0 , plz can you give some more info about that ? my server load just fine , only thing DB error .
     
Loading...

Share This Page