SOLVED MySQL Keeps Stopping - Now Using MariaDB

[Larry Braziel]

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:

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

 

[cPanelMichael]

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.

Hello,

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

free -m

Also, try using a command such as:

mysqladmin processlist;

This should help you to determine which databases are using the most resources.

Thank you.