Page 1 of 1

MariaDB stopped after High Load

Posted: Sat Feb 10, 2018 4:24 pm
by shishupal
Hi, I was testing the site load using loader.io and haven't checked the server. After 2-3 hr I have visited my site and it was giving Error Database connection.

Logged on admin panel and found that MariaDB is stopped. I wonder, why it is not restarted?? It was down from 3hrs and not started :(

Even the server load was not much high. How to fix this.

Re: MariaDB stopped after High Load

Posted: Mon Feb 12, 2018 1:57 pm
by skurudo
It's hard to say, what problem you got.
Check mysql error log please.

Re: MariaDB stopped after High Load

Posted: Mon Feb 12, 2018 5:38 pm
by mehargags
This has nothing to do with VestaCP. If the payload increases, you need to :

1) increase server resources like RAM and CPU Cores
or
2) fine tune MySQL, Apache/Nginx to perform better

Also @shishupal, all your past posts seem to be too "novice". If you expect help, atleast post your server specs and related information.

Re: MariaDB stopped after High Load

Posted: Tue Feb 13, 2018 6:57 pm
by skamasle
Of course dificult to say, maybe OOM come and kill something, I see this a lot of times, I not know why my OOM always kill mysql first.

But without logs is imposible to know what happen.