Page 1 of 1

Mysql gets killed and shutdown all my website

Posted: Fri Jul 06, 2018 7:05 am
by tomtom
Hello, i have 2gb vps with centos 6 and vestacp and i'm hosting few websites. Sometimes there are random crashes of the database and almost all of my websites gets shutdown and it is really frustrating.. Maybe you can help me find a reason why. innodb buffer size is 1GB.

with command top:
Image

with free -m
Image

grep -i 'killed process'
Image

I know from this that my database get killed but why? and how to prevent it.. If you need any more logs please ask. Any help is appreciated because i'm fighting this for a long time..

Also there is var/log/messages in pastebin:
https://pastebin.com/Xfh0Th6V

Re: Mysql gets killed and shutdown all my website

Posted: Mon Sep 10, 2018 4:17 pm
by xorro
have you tried increasing memory limit in MySQL / MariaDb configurations?