Page 1 of 1

Mysql server getting down again and again

Posted: Mon Sep 07, 2015 6:23 am
by karthickica
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

Re: Mysql server getting down again and again

Posted: Mon Sep 14, 2015 8:11 am
by jtpro
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

Re: Mysql server getting down again and again

Posted: Mon Sep 14, 2015 9:21 am
by tjebbeke
Check log files, what kind of server you are using? Low memory VPS? (<1GB RAM)

Re: Mysql server getting down again and again

Posted: Wed Sep 30, 2015 9:49 am
by karthickica
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

Re: Mysql server getting down again and again

Posted: Thu Oct 01, 2015 8:04 am
by joem
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.

Re: Mysql server getting down again and again

Posted: Tue Sep 04, 2018 9:09 pm
by daansk44
Where can I find this option in CentOS7
I have the latest installation of vestacp