I have been running a website using Percona mysql for about 18 months now. Today suddenly the web site stopped working and I found that it was because the mysql database had stopped responding.
I logged into the server and ran “service mysql restart” and it showed that the database shutdown ok but then when it tried to restart it failed. I tried several more times to restart the database but always get a failed status. I rebooted the server and tried again, but that did not help.
root@ambling2:/var/lib/mysql# service mysql start
- Starting MySQL (Percona Server) database server mysqld [fail]
I checked and there is plenty of disk space available:
root@ambling2:/var/lib/mysql# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdc1 704G 12G 657G 2% /var/lib/mysql
The last thing logged in the /var/lib/mysql/mysql-error.log file is the following:
140119 23:12:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.5.35-33.0-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Percona Server (GPL), Release 33.0
140310 13:56:50 [Note] /usr/sbin/mysqld: Normal shutdown
140310 13:56:50 [Note] Event Scheduler: Purging the queue. 0 events
140310 13:56:52 [Warning] /usr/sbin/mysqld: Forcing close of thread 14664450 user: ‘root’
140310 13:56:52 [Warning] /usr/sbin/mysqld: Forcing close of thread 14662690 user: ‘root’
140310 13:56:52 InnoDB: Starting shutdown…
140310 13:56:52 InnoDB: Waiting for 1 pages to be flushed
140310 13:57:10 InnoDB: Shutdown completed; log sequence number 214690824939
140310 13:57:10 [Note] /usr/sbin/mysqld: Shutdown complete
140310 13:57:10 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
No new lines are added to the mysql-error.log file each time that I type ‘service mysql start’. The last lines are the lines logged when mysql shut down.
Where can I look next to try and determine why mysql is not working. Mysql has been installed and running fine for 18 months now and the server had been up over a month when the database suddenly stopped responding today.