mySQL won't start

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

I think I have run out of room on the drive and have to find something to delete.

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/

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.

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.