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!

MySQL - error at database

Discussion in 'Database Discussion' started by tomescu, Jul 25, 2014.

  1. tomescu

    tomescu Member

    Joined:
    Apr 11, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Satu Mare / Romania
    cPanel Access Level:
    Root Administrator
    Given every 3 hours, I got a flood after the Load Averages 348.67 469.51 240.34 reached. Then MySQL crashes and stops working sites.

    In order to recover, always give Rebuild RPM Database. But I can not do that forever.

    I do not know what it is. It's the flood, or is there a problem with the MySQL server?

    Please help me! What can I do?


    (sorry for my bad english)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,928
    Likes Received:
    1,817
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. tomescu

    tomescu Member

    Joined:
    Apr 11, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Satu Mare / Romania
    cPanel Access Level:
    Root Administrator
    CPU
    memory (including swap)
    disk I/O
    ???

    I have 4 cores from one Intel processor, XEON... memory 5150 MB, and 100 GB Disk.....
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. tomescu

    tomescu Member

    Joined:
    Apr 11, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Satu Mare / Romania
    cPanel Access Level:
    Root Administrator
    Nobudy can't help me ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. darrencain

    darrencain Member

    Joined:
    Aug 3, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    England ( EU )
    cPanel Access Level:
    Root Administrator
    Upgrade to MySQL 5.6 ( If you're already upgraded to that, then rebuild it )

    Home »Software »MySQL Upgrade
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. tomescu

    tomescu Member

    Joined:
    Apr 11, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Satu Mare / Romania
    cPanel Access Level:
    Root Administrator
    I give rebuild in every 3 hours, and it's still crashing
    MySQL is allready 5.6.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. darrencain

    darrencain Member

    Joined:
    Aug 3, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    England ( EU )
    cPanel Access Level:
    Root Administrator
    what do you have in your my.cnf ?

    Located /etc/my.cnf


    and what your ram and cpu specs
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. tomescu

    tomescu Member

    Joined:
    Apr 11, 2014
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Satu Mare / Romania
    cPanel Access Level:
    Root Administrator

    cat /proc/meminfo |more
    MemTotal: 5242880 kB
    MemFree: 817288 kB
    Cached: 3747020 kB
    Active: 2421208 kB
    Inactive: 1867336 kB
    Active(anon): 358476 kB
    Inactive(anon): 183048 kB
    Active(file): 2062732 kB
    Inactive(file): 1684288 kB
    Unevictable: 0 kB
    Mlocked: 0 kB
    SwapTotal: 524288 kB
    SwapFree: 518620 kB
    Dirty: 0 kB
    Writeback: 0 kB
    AnonPages: 541524 kB
    Shmem: 5204 kB
    Slab: 136992 kB
    SReclaimable: 129496 kB
    SUnreclaim: 7496 kB

    - - - Updated - - -

    This is the configuration of VPS
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. darrencain

    darrencain Member

    Joined:
    Aug 3, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    England ( EU )
    cPanel Access Level:
    Root Administrator
    Download this my.cnf and replace your current one.

    [Removed]

    You may need to tweak it, but see what that does. don't forget to restart mysql.

    Mod Note: Please post the full my.cnf file in code tags rather than linking to a third-party download.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 darrencain, Jul 27, 2014
    Last edited by a moderator: Jul 30, 2014
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