Thread: Is there any logs that show what would cause mysql to freeze?

Is there any logs that show what would cause mysql to freeze? Also, when I try to restart it from command line it says failed. Eventually it does do it.

Hello,

What verison of mysql are you using?

do you have logs setup ? do you have the DIR

/var/log/mysql

if so have a look in there then run the cat command on the file. If you do not have that you
need to set these up.

run cat /etc/my.cnf and see if you have logs setup they look under

[mysqld_safe] log-error=/var/log/mysql/error.log [mysqld] log-error=/var/log/mysql/error.log

If you need any help of futher info please let me know and I will try and help.
Thanks

Rick
DubHosting

Yep, /var/log/mysql will have anything in it that was recorded.