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.

MySQL - error at database

Discussion in 'Database Discussions' 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)
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  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.....
     
  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 ?
     
  5. darrencain

    darrencain Member

    Joined:
    Aug 3, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  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.
     
  7. darrencain

    darrencain Member

    Joined:
    Aug 3, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  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
     
  9. darrencain

    darrencain Member

    Joined:
    Aug 3, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
    #9 darrencain, Jul 27, 2014
    Last edited by a moderator: Jul 30, 2014
Loading...

Share This Page