My MySQL is stopping automatically

aaP_azunweb

Hi,

My MySQL is stopping automatically all the time, and it only becomes active again if I restart the service.

But a few hours after I restarted it, it keeps stopping automatically again.

These are my VPS settings:
VCPU: 3
Memory: 4 GB Ram
Storage: 80 GB
Cloud: Hetzner

The logs that appear in the MySql service:

Can anyone help me please?

aaPanel_Kern

aaP_azunweb
Hello, execute the command to view the error log
cat /www/server/data/*.err|grep -i -C 10 error dmesg|grep -E "kill|mysql|oom"

aaP_azunweb

Did I execute the commands correctly? I'm a beginner.

Here are the screenshots:

aaPanel_Kern

aaP_azunweb
out of memory killed process 79474 (mysqld)

Hello, there is not enough memory and the system is killing . You can use the command to check whether to use swap
free -m

aaP_azunweb

Hi,

I used the command you said and this popped up.

Thank you for wanting to help me!

aaPanel_Kern

aaP_azunweb
Hello, what is the MySQL performance you configured?

Try to add physical memory.
Try to add swap. You can use Linux Tools to add swap in the app store

entiretools

I am facing the same issue

My MySQL is stopping automatically all the time, and it only becomes active again if I restart the service.

kloudboy

I had the same issue with two other aaPanel installations running WordPress. My MySQL( mariadb) service kept stopping automatically.

aaPanel_Kern

Hello, Please check whether mysql has been closed by the system? You can use this command to check
dmesg|grep -E "kill|mysql|oom"
What is the hardware configuration of your server?

kloudboy

wdikiz

I had the same issue with aaPanel running WordPress. My MySQL( mariadb) service kept stopping automatically and i have to restart the mysql service each time