Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Mysql gets restarted again and again.

[its_joe]

Mysql gets restarted again and again.

Hello,
We have CentOS 4.7 , WHM 11, Apache/2.2.9, Mysql 5.0.51 on the server.
Currently we are facing Mysql issue. Mysql server get restarted after every 9-10 minutes. I have even tried /scripts/fixmysql on server but that didn't help. I am checking Mysql status as follows:
- Login to root SSH
- Type mysql and you get login to Mysql prompt
- Then type status to check the uptime
Here I see mysql uptime never goes above 8-9 minutes.
Waiting for the reply.
its_joe

[sinus]

maybe, your server load is hight.

[vapetrov]

First of all look into mysql error log.
Login to root SSH and search for it in /var/lib/mysql
It may be because of bug if version of mysql is not latest. Or may be completely new bug. If so, some queries able to crush mysqld.
So, investigate error log. If you'll found strange error messages try to install latest version mysql.





__________________
Private remote administrator of Linux servers - www.petrov.ks.ua
Quality hosting - Host-Web-Site.com

[its_joe]

Hello,
We have checked the mysql logs and there is no error message in it. also no database is is corrupted or crashed. In the logs we just see mysql is getting restarted. The mysql logs are as follows:
===============================================
# tail -f /var/log/mysqld.log
081102 10:50:03 InnoDB: Starting shutdown...
081102 10:50:05 InnoDB: Shutdown completed; log sequence number 1 2031460536
081102 10:50:05 [Note] /usr/sbin/mysqld: Shutdown complete
081102 10:50:05 mysqld ended
081102 10:50:42 mysqld started
081102 10:50:42 InnoDB: Started; log sequence number 1 2031460536
081102 10:50:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
081102 10:57:02 [Note] /usr/sbin/mysqld: Normal shutdown
081102 10:57:02 InnoDB: Starting shutdown...
081102 10:57:04 InnoDB: Shutdown completed; log sequence number 1 2031460536
081102 10:57:04 [Note] /usr/sbin/mysqld: Shutdown complete
081102 10:57:04 mysqld ended
081102 10:57:04 mysqld started
081102 10:57:04 InnoDB: Started; log sequence number 1 2031460536
081102 10:57:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
081102 11:05:30 [Note] /usr/sbin/mysqld: Normal shutdown
081102 11:05:30 InnoDB: Starting shutdown...
081102 11:05:31 InnoDB: Shutdown completed; log sequence number 1 2031460546
081102 11:05:31 [Note] /usr/sbin/mysqld: Shutdown complete
081102 11:05:31 mysqld ended
081102 11:05:32 mysqld started
081102 11:05:32 InnoDB: Started; log sequence number 1 2031460546
081102 11:05:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
==================================================
If there is any bug is current version then please give us the solution for it.
Waiting for reply.





__________________
Thanks.
its_joe

[vapetrov]

As far I see no error messages - clear restarts.
As you use WHM/Cpanel I guess something wrong with service monitoring system.
The system (chkservd) not feel mysqld running and restarted it.
Try to go to "WHM - Service Manager", uncheck checkbox "monitoring" near "mysql", press "save" button, than check the checkbox back and save one more time.
Also try to look into /var/log/chkservd.log - maybe you'll see detailed error message.
If it not helps show output of commands (in ssh root session):
cat /etc/chkserv.d/mysql
cat /etc/my.cnf





__________________
Private remote administrator of Linux servers - www.petrov.ks.ua
Quality hosting - Host-Web-Site.com






Last edited by vapetrov : 11-02-2008 at 06:31 PM.

[vapetrov]

And the simplest way - just uncheck "monitoring" checkbox in WHM - Service Manager.
mysql stable enough and usually not needed monitoring on not heavy loaded systems.





__________________
Private remote administrator of Linux servers - www.petrov.ks.ua
Quality hosting - Host-Web-Site.com

[jphilipson]

Also, check your /var/log/messages





__________________I perform System Administration

[koithara]

Check if any scripts are executed to restart your mysql, if the load has crossed a certain limit. You may check this in your cron jobs.





__________________Sony Koithara ,CrazyAdmins.com -> where admins go c r @ z y!!!