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.

SOLVED MySQL Keeps Stopping - Now Using MariaDB

Discussion in 'Database Discussions' started by Larry Braziel, Dec 14, 2016.

  1. Larry Braziel

    Larry Braziel Registered

    Joined:
    Dec 12, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Blue Ridge, GA
    cPanel Access Level:
    Root Administrator
    Hello cPanel Staff & Users:

    I'm having a problem with mySQL shutting down almost daily, this is frustrating for both me and my user's and I would like to put a stop to it. This is what the log says:
    Code:
    Dec 11 20:54:41 dal-tx-01 kernel: [4565600.865356] Out of memory in UB 66640: OOM killed process 2516 (mysqld) score 0 vm:1124912kB, rss:205760kB, swap:3536kB
    Dec 14 00:01:36 dal-tx-01 kernel: [4749621.319394] Out of memory in UB 66640: OOM killed process 1060 (mysqld) score 0 vm:1140208kB, rss:85744kB, swap:220216kB
    Dec 14 14:54:17 dal-tx-01 kernel: [4803184.595318] Out of memory in UB 66640: OOM killed process 9521 (mysqld) score 0 vm:1137840kB, rss:101976kB, swap:157232kB
    Dec 14 15:01:56 dal-tx-01 kernel: [4803643.361491] Out of memory in UB 66640: OOM killed process 17068 (mysqld) score 0 vm:1071072kB, rss:167324kB, swap:0kB
    Dec 14 15:02:01 dal-tx-01 kernel: [4803648.767507] Out of memory in UB 66640: OOM killed process 17779 (mysqld) score 0 vm:1066088kB, rss:128108kB, swap:0kB
    Dec 14 15:02:05 dal-tx-01 kernel: [4803652.624920] Out of memory in UB 66640: OOM killed process 17834 (mysqld) score 0 vm:1066384kB, rss:125156kB, swap:0kB
    Dec 14 15:02:06 dal-tx-01 kernel: [4803653.319562] Out of memory in UB 66640: OOM killed process 17907 (mysqld) score 0 vm:930020kB, rss:101796kB, swap:0kB
    Dec 14 21:14:15 dal-tx-01 kernel: [4825983.406034] Out of memory in UB 66640: OOM killed process 1061 (mysqld) score 0 vm:1075512kB, rss:40232kB, swap:121100kB
    Dec 14 21:14:27 dal-tx-01 kernel: [4825995.026526] Out of memory in UB 66640: OOM killed process 1839 (mysqld) score 0 vm:1069936kB, rss:129940kB, swap:0kB
    Dec 14 21:14:29 dal-tx-01 kernel: [4825997.565372] Out of memory in UB 66640: OOM killed process 1945 (mysqld) score 0 vm:630696kB, rss:64268kB, swap:0kB
    
    
    What can I do to fix this 'Out of memory' issue? I have tried adjusting ram usage stuff in the my.cnf file, however it looks like this has had no effect.

    Does anyone have any suggestions or recommendation on how to fix this? It's urgent that I get this fixed as it's affecting our sites and all customer sites on a production VPS.

    Thanks,
    Larry
     
    #1 Larry Braziel, Dec 14, 2016
    Last edited by a moderator: Dec 15, 2016
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,037
    Likes Received:
    1,280
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    How much RAM is installed on the system? You can check with a command such as:

    Code:
    free -m
    Also, try using a command such as:

    Code:
    mysqladmin processlist;
    This should help you to determine which databases are using the most resources.

    Thank you.
     
Loading...

Share This Page