Mysql server getting down again and again

karthickica · Post by **karthickica** » Mon Sep 07, 2015 6:23 am

Hello All,
Mysql server getting down and stop running , After restarting the server its works fine ,
I can't target what goes wrong.
I am using vesta vps as my service , Os : ubuntu .
So here is my mysql error log report : [Warning] IP address 'ip address ' could not be resolved: Temporary failure in name resolution ,
Can any help me to sort out this issue, Thanks

jtpro · Post by **jtpro** » Mon Sep 14, 2015 8:11 am

Hi, I'm using Ubuntu Server 14.04 LTS with VestaCP inside VirtualBox machine. Clearly installed OS with VestaCP.
After start/reboot in 5 minutes all my sites (Joomla) can't connect to MySQL. I do in console: sudo service mysql stop, sudo service mysql stop and the problem get solve. But mysql don't crashes. Simply no connection

Post by **tjebbeke** » Mon Sep 14, 2015 9:21 am

Check log files, what kind of server you are using? Low memory VPS? (<1GB RAM)

karthickica · Post by **karthickica** » Wed Sep 30, 2015 9:49 am

Hi All again i am running into a serious issue , Today mysql has be went down , Please find this screenshot for the error log report : https://www.dropbox.com/s/nix3nwn13pbjj ... 4.png?dl=0
After that i have restarted mysql server and then i have do an update in my server apt-get-update , While update i have this issue : https://www.dropbox.com/s/hgfgiu3rxj0px ... 9.png?dl=0
Then i have restarted my server . Now mysql is randomly getting down after restart.
When restart mysql server i facing a issue like : service mysql restart
Stop : unknown instance
mysql start / running

joem · Post by **joem** » Thu Oct 01, 2015 8:04 am

karthickica wrote:Hi All again i am running into a serious issue , Today mysql has be went down , Please find this screenshot for the error log report : https://www.dropbox.com/s/nix3nwn13pbjj ... 4.png?dl=0
After that i have restarted mysql server and then i have do an update in my server apt-get-update , While update i have this issue : https://www.dropbox.com/s/hgfgiu3rxj0px ... 9.png?dl=0
Then i have restarted my server . Now mysql is randomly getting down after restart.
When restart mysql server i facing a issue like : service mysql restart
Stop : unknown instance
mysql start / running

Open

/etc/mysql/my.cnf

Find

Code: Select all

innodb_buffer_pool_size=128M

Change To

Code: Select all

innodb_buffer_pool_size=64M

Reboot Mysql

You may want to consider adding a swap file or more ram. Check out https://www.digitalocean.com/community/ ... untu-14-04 on how to add swap file.

daansk44 · Post by **daansk44** » Tue Sep 04, 2018 9:09 pm

Where can I find this option in CentOS7
I have the latest installation of vestacp

Vesta Control Panel - Forum