The mysqld process was terminated Because the system is low on memory .

[Marco Urbani]

Good morning,
Friday mysql crashes 2 times a day with this error: The mysqld process was terminated Because the system is low on memory .

Server xxx
Indirizzo IP primario xxx
Process Name mysqld
Event Time domenica 29 novembre 2015 17.18.32 UTC
ID processo 2022
Process UID 498
Process Username mysql
Process Total Virtual Memory 1357244kB
Process Anonymous Resident Set Size 541708kB
Process File Resident Set Size 336kB
Process OOM Score 290
Stato Out of Memory ⚠
Informazioni memoria
Usato 690 MB
Disponibile 1,11 GB
Installato 1,79 GB
Carica informazioni 0.19 0.36 0.24
Tempo di attività 1 giorno, 9 ore, 32 minuti, e 27 secondi
Informazioni IOStat avg-cpu:  %user  %nice %system %iowait  %steal  %idle           5.12    1.22    1.67    1.87    0.07  90.05 Device:            tps  Blk_read/s  Blk_wrtn/s  Blk_read  Blk_wrtn vda              9.02      319.68      152.81  38408332  18360048
Top Processes
PID Proprietario CPU % Memory % Comando
1730 root 0.03 17.23 /usr/local/cpanel/3rdparty/bin/clamd
23466 root 0.03 3.83 spamd child
1747 root 0.03 3.75 /usr/local/cpanel/3rdparty/perl/514/bin/spamd --daemonize --max-spare=1 --max-children=3 --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid -i127.0.0.1
2351 root 0.00 1.40 cpdavd - accepting connections on 2077, 2078, 2079, and 2080
26210 root 15.96 1.34 tailwatchd - chkservd - sshd check
For addtional details, please see the attached dmesg log dump.



Anteprima di "oom_dmesg.txt"
[120465.846695] [25413] 99 25413 19584 554 0 0 0 httpd
[120465.847731] [25414] 99 25414 19584 554 0 0 0 httpd
[120465.848729] [25415] 99 25415 19584 554 0 0 0 httpd
[120465.849607] [25416] 99 25416 19584 554 0 0 0 httpd
[120465.850602] [25417] 0 25417 26951 4616 0 0 0 cpsrvd (SSL) -
[120465.851703] [25418] 0 25418 27431 3368 0 0 0 /usr/local/cpan
[120465.852841] [25419] 99 25419 19584 561 0 0 0 httpd
[120465.853837] [25420] 99 25420 3010 70 0 0 0 suphp
[120465.854893] Out of memory: Kill process 2022 (mysqld) score 290 or sacrifice child
[120465.855991] Killed process 2022, UID 498, (mysqld) total-vm:1357244kB, anon-rss:541708kB, file-rss:336kB

 

[cPanelMichael]

Hello

Check to see what's taking up your system's memory when this happens. The following guide is intended for troubleshooting high loads, but it includes some useful tips on checking memory as well:

Troubleshooting high server loads on Linux servers

Thank you.