V
V
Vlad2020-12-30 00:06:12
MySQL
Vlad, 2020-12-30 00:06:12

Why does mariadb - database server stop?

Over the past month, the mariadb - database server process has already stopped twice on the server, because of which sites stopped working - mysql error.

Whether prompt it is possible to understand the reason of shutdown of mariadb somehow??

5feb9ab5176a9956409225.png

5feb9abd21db8857177752.png

5feb9ac57d6f4029611439.png

5feb9acc6527a461028241.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dimonchik, 2020-12-30
@dimonchik2013

logs
usually have no place
less often - something crashes or clamps like a container

V
Vitaly Karasik, 2020-12-30
@vitaly_il1

Most likely, as they said in the comments, there is not enough RAM. You can check by looking in /var/log/messages (or syslog) - if processes are killed, then we will see an out of memory killer there.
What to do? - if this is a commercial site, I would at least increase the server, and even better - separate Nginx and MySQL.
For the advanced - turn on MySQL slow query log and tune - the graph shows that there was a CPU load spike.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question