mysqld dead but subsys locked
For me, this means that the daemon has crashed and was restarted, but the lockfile that mysqld uses to prevent multiple daemons from accessing the same database is still there...

I fix it with

service mysqld stop
service mysqld start


Not sure if you can just to a restart instead of a stop then start, and I haven't figured out the cause yet for the crash either.