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.

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

Discussion in 'Database Discussions' started by Marco Urbani, Nov 30, 2015.

  1. Marco Urbani

    Marco Urbani Member

    Joined:
    Oct 27, 2015
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Italy
    cPanel Access Level:
    Root Administrator
    Good morning,
    Friday mysql crashes 2 times a day with this error: The mysqld process was terminated Because the system is low on memory .

    Code:
    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
    
    
     
    #1 Marco Urbani, Nov 30, 2015
    Last edited by a moderator: Nov 30, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page