Php, mysql automatically stops every day

aap_lucifer

Why Php, mysql and sometimes apache automatically stops every day once or twice without having any traffic on the website??

aaPanel_Kern

Hello, what is your server hardware configuration? Also check if it is shut down by the system?

dmesg|grep -iE "kill|httpd|apache|http|mysql|oom"
grep -i 'killed' /var/log/messages
journalctl | grep -i 'killed'

aap_lucifer

Nov 25 14:55:47 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 184296 (mysqld) total-vm:3202080kB, anon-rss:480560kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:1276kB oom_score_adj:0
Nov 25 14:55:47 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 25 14:55:47 vmi2074836.contaboserver.net mysqld[183607]: /www/server/mysql/bin/mysqld_safe: line 198: 184296 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1
Nov 25 14:55:50 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313315 (mysqld) total-vm:3201824kB, anon-rss:276680kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:928kB oom_score_adj:0
Nov 25 14:55:50 vmi2074836.contaboserver.net mysqld[183607]: /www/server/mysql/bin/mysqld_safe: line 198: 313315 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1
Nov 25 14:55:50 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 25 14:55:50 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 246303 (php-fpm) total-vm:508664kB, anon-rss:89016kB, file-rss:0kB, shmem-rss:108828kB, UID:1000 pgtables:812kB oom_score_adj:0
Nov 25 14:55:50 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 25 14:55:52 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313431 (mysqld) total-vm:3191796kB, anon-rss:261980kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:888kB oom_score_adj:0
Nov 25 14:55:52 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 25 14:55:52 vmi2074836.contaboserver.net mysqld[183607]: /www/server/mysql/bin/mysqld_safe: line 198: 313431 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1
Nov 25 14:55:55 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313507 (mysqld) total-vm:3197340kB, anon-rss:229988kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:844kB oom_score_adj:0
Nov 25 14:55:55 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 25 14:55:55 vmi2074836.contaboserver.net mysqld[183607]: /www/server/mysql/bin/mysqld_safe: line 198: 313507 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1
Nov 25 14:56:35 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313602 (mysqld) total-vm:3201036kB, anon-rss:296364kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:1068kB oom_score_adj:0
Nov 25 14:56:35 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 25 14:56:35 vmi2074836.contaboserver.net mysqld[183607]: /www/server/mysql/bin/mysqld_safe: line 198: 313602 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1
Nov 25 14:56:36 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 172501 (/usr/sbin/amavi) total-vm:160896kB, anon-rss:135816kB, file-rss:0kB, shmem-rss:0kB, UID:112 pgtables:356kB oom_score_adj:0
Nov 25 14:56:36 vmi2074836.contaboserver.net systemd[1]: amavis.service: A process of this unit has been killed by the OOM killer.
Nov 25 14:56:36 vmi2074836.contaboserver.net systemd[1]: amavis.service: Main process exited, code=killed, status=9/KILL
Nov 25 14:56:36 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313755 (mysqld) total-vm:1142388kB, anon-rss:205364kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:548kB oom_score_adj:0
Nov 25 14:56:36 vmi2074836.contaboserver.net mysqld[183607]: /www/server/mysql/bin/mysqld_safe: line 198: 313755 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1
Nov 25 14:56:36 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 26 00:09:22 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313183 (php-fpm) total-vm:531940kB, anon-rss:185420kB, file-rss:0kB, shmem-rss:22420kB, UID:1000 pgtables:564kB oom_score_adj:0
Nov 26 00:09:22 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 00:52:23 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313246 (php-fpm) total-vm:539264kB, anon-rss:191852kB, file-rss:0kB, shmem-rss:22420kB, UID:1000 pgtables:580kB oom_score_adj:0
Nov 26 00:52:23 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 01:36:19 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313272 (php-fpm) total-vm:545408kB, anon-rss:199320kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:592kB oom_score_adj:0
Nov 26 01:36:19 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 02:25:18 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313245 (php-fpm) total-vm:553600kB, anon-rss:206952kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:608kB oom_score_adj:0
Nov 26 02:25:18 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 03:18:03 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313262 (php-fpm) total-vm:562660kB, anon-rss:215692kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:624kB oom_score_adj:0
Nov 26 03:18:03 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 04:24:20 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313263 (php-fpm) total-vm:574016kB, anon-rss:226968kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:648kB oom_score_adj:0
Nov 26 04:24:20 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 05:21:20 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313259 (php-fpm) total-vm:584320kB, anon-rss:236676kB, file-rss:0kB, shmem-rss:22420kB, UID:1000 pgtables:668kB oom_score_adj:0
Nov 26 05:21:20 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 06:33:20 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313273 (php-fpm) total-vm:596544kB, anon-rss:248584kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:692kB oom_score_adj:0
Nov 26 06:33:20 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 07:54:20 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313190 (php-fpm) total-vm:608896kB, anon-rss:261528kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:716kB oom_score_adj:0
Nov 26 07:54:20 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 09:13:20 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313270 (php-fpm) total-vm:621120kB, anon-rss:274828kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:740kB oom_score_adj:0
Nov 26 09:13:20 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 10:48:21 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 313257 (php-fpm) total-vm:637504kB, anon-rss:291080kB, file-rss:0kB, shmem-rss:22416kB, UID:1000 pgtables:772kB oom_score_adj:0
Nov 26 10:48:21 vmi2074836.contaboserver.net systemd[1]: session-1.scope: A process of this unit has been killed by the OOM killer.
Nov 26 17:52:08 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 359 (clamd) total-vm:1564512kB, anon-rss:1402628kB, file-rss:0kB, shmem-rss:0kB, UID:113 pgtables:2840kB oom_score_adj:0
Nov 26 17:52:08 vmi2074836.contaboserver.net systemd[1]: clamav-daemon.service: A process of this unit has been killed by the OOM killer.
Nov 26 17:52:08 vmi2074836.contaboserver.net systemd[1]: clamav-daemon.service: Main process exited, code=killed, status=9/KILL
Nov 26 17:57:00 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 1902 (mysqld) total-vm:3199184kB, anon-rss:384096kB, file-rss:0kB, shmem-rss:0kB, UID:1001 pgtables:1112kB oom_score_adj:0
Nov 26 17:57:00 vmi2074836.contaboserver.net systemd[1]: mysqld.service: A process of this unit has been killed by the OOM killer.
Nov 26 17:57:00 vmi2074836.contaboserver.net mysqld[1007]: /www/server/mysql/bin/mysqld_safe: line 198: 1902 Killed nohup /www/server/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --log-error=vmi2074836.contaboserver.net.err --open-files-limit=65535 --pid-file=/www/server/data/vmi2074836.contaboserver.net.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null > /dev/null 2>&1
Nov 26 20:51:11 vmi2074836.contaboserver.net kernel: Out of memory: Killed process 7740 (php-fpm) total-vm:535120kB, anon-rss:116312kB, file-rss:0kB, shmem-rss:137020kB, UID:1000 pgtables:788kB oom_score_adj:0
Nov 26 20:51:11 vmi2074836.contaboserver.net systemd[1]: php-fpm-83.service: A process of this unit has been killed by the OOM killer.

aaPanel_Kern

Hello, you can check from the log that it was shut down by the system due to insufficient memory.

aap_lucifer

similar sites are running fine on cpanel shared hosting but here i getting error for sometimes php, sometimes mysql.

aaPanel_Kern

It is recommended that you check whether the mysql PHP configuration exceeds the physical memory?
Have you been attacked? You can check the monitoring interface and website logs

aap_lucifer

Have not been attacked, also very less traffic.
mysql and php memory setup for 4-8gb ram where as vps has 6gb ram

aaPanel_Kern

How many mysql settings are there? Does the total exceed physical memory?

aap_lucifer

aaP_kotakomputer.ceo

aap_lucifer

OOM killer could be not enough RAM of your VPS node. Maybe your node overselling ram.

Use # top to check which app consume ram.

aap_lucifer

aaPanel_Kern

Hello, I suggest you adjust the PHP settings 1-2G