Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MSQL 5.1 Error establishing a database connection

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

  1. saamxvr

    saamxvr Well-Known Member

    Joined:
    Oct 30, 2010
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    56
    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

    Joined:
    Feb 25, 2010
    Messages:
    1,835
    Likes Received:
    21
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Friendly moderator note

    I moved this thread to our Database Discussions section.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. GaryT

    GaryT Well-Known Member

    Joined:
    May 19, 2010
    Messages:
    320
    Likes Received:
    3
    Trophy Points:
    68
    *** 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:
    56
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice