If you are getting the following error while trying to start MySQL service;
[root@ ~]# /etc/init.d/mysqld restart
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@ ~]#
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@ ~]#
And if you are getting the following error in the MySQL log;
[root@ ~]# tail -f /var/log/mysqld.log
080503 14:30:28 [ERROR] Can’t start server: can’t create PID file: No space left on device
Number of processes running now: 0
080503 14:30:28 mysqld restarted
080503 14:30:28 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
080503 14:30:28 [ERROR] Can’t start server: can’t create PID file: No space left on device
Number of processes running now: 0
080503 14:30:28 mysqld restarted
080503 14:30:28 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
The issue might be due to the lack of space in the ‘/var’ partition. So you need to reduce the disk space, which should fix the issue.
[root@ ~]# df -h
[root@ ~]# cd /var
[root@ ~]# du -sch *
[root@ ~]# cd /var
[root@ ~]# du -sch *
Using the above commands, you can see that files and folders which consumes more size. You need to delete the unwanted files or folders and try reduce the size.
Try restart the MySQL service. 🙂
[root@ ]# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
[root@ ]#
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
[root@ ]#