Hi all,
My Linode has been running perfect for well over a year, then last night I noticed my MySQL server (on the same Linode) stopped running.

It's a Ubuntu 10.10 image with nginx & mysql.
I made no changes so have no idea why this happened.

using:

/etc/init.d/mysql restart

results in:



so, I tried:


and I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

any ideas what I need to do to get this fixed?

Is your disk full? "df -h" will check. MySQL seems to be the first thing that fails when that happens.

Thank you so much, that was indeed it.
Tried everything else, was pulling my hair out, never thought to check if disk was full.

Working again now.

Old and busted: Apache MaxClients
New hotness: MySQL no-space-left-on-device handling



Going for the exacta here: is logrotate installed and working?

When it happened to me years ago, logrotate wouldn't help. It was a log growing up, indeed, but it did grow up these 10-or-so GB in about a hour.
Yay for a few E_NOTICEs per request * tens of thousands of requests...

_________________
rsk, providing useless advice on the Internet since 2005.

Partitions. Saving your server from logswell crash since 1991*.


*) or whatever

I was young and stupid back then.
Now I'm not so young. Still stupid, probably.

_________________
rsk, providing useless advice on the Internet since 2005.