Submitted by securewebs on Thu, 04/30/2015 - 09:57 Pro Licensee
We have about 80 websites running on a machine where mySQL will not start. I am not really sure what to do about it. I don't believe this has happened before. Virtualmin reports "Timeout error occurred trying to start MySQL Daemon." On the command line the server just reports "failed" when running /etc/init.d/mysqld start. I wish I knew what to do but I really don't. Any suggestions would be most welcome.
Status:
Active
Comments
Submitted by securewebs on Thu, 04/30/2015 - 10:04 Pro Licensee Comment #1
I think I have run out of room on the drive and have to find something to delete.
Submitted by andreychek on Thu, 04/30/2015 - 10:05 Comment #2
Howdy -- sounds like you got it working! Feel free to let us know if you see any additional problems.
If it's not a space related issue, you may also see some relevant error messages in the MySQL error log located in /var/log/
Submitted by securewebs on Thu, 04/30/2015 - 10:11 Pro Licensee Comment #3
Yes, after deleting a couple of log files mySQL started again. Any suggestions on where I might be able to delete any files? I assume logfiles are safe but we could use some more wiggle room. The drive is a 120GB solid-state drive.
Submitted by andreychek on Thu, 04/30/2015 - 11:08 Comment #4
The key is to review your filesystem and look where the space usage is.
What you can do is log into your server as root over SSH, cd into the "/" directory, and run this command:
du -sh *That will show you which directory or directories are using the space.
You can then 'cd' into that particular directory and run the same command again. That process should lead you to what is using up all that space.