How to Avoid MySQL Service Being Killed by Out-of-Memory (OOM) Killer on Linux
(Doc ID 1548124.1)
Last updated on JANUARY 28, 2020
Applies to:MySQL Server - Version 5.0 and later
MySQL Cluster - Version 7.5 to 7.5 [Release 7.5]
Information in this document applies to any platform.
How to avoid MySQL getting killed by the Out-of-Memory (OOM) killer on Linux.
Example of issue:
Mysqld restarts periodically by mysqld_safe but no errors in mysql error log just message that mysqld_safe restarted mysqld. Caused by Linux Out Memory Killer killing mysqld process.
Can be verified by the examining system logs. Entries like below:
/var/log/messages-20170108:Jan 7 21:55:30 ktsk kernel: Killed process 1904 (mysqld) total-vm:2855024kB, anon-rss:449640kB, file-rss:0kB
/var/log/messages-20170108:Jan 7 21:55:58 ktsk kernel: httpd invoked oom-killer: gfp_mask=0x200da, order=0, oom_score_adj=0"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document