Hi, Thanks for your input. Yes I can logon to the server and I will try this command next time it hangs. Will let you know what I see.
Best regards, Andreas --- On Sat, Aug 23, 2008 at 5:32 PM, Johnny Withers <[EMAIL PROTECTED]>wrote: > There are all kinds of logs mysql will produce. You should probably log all > queries since you won't be able to logon to the server when it hangs. If you > are still able to logon, the best thing would be to run "show processlist;" > in the mysql client ... if you can logon that is. > > You can review what logs mysql can create here: > > http://dev.mysql.com/doc/refman/4.1/en/log-files.html > > Hope that helps. > > -johnny > > > On 8/23/08, Andreas Andersen <[EMAIL PROTECTED]> wrote: >> >> Hi, >> I'm running a server on FreeBSD 6.3 (prerelease) with mysql server and >> client 4.1.22. The server is hosting several websites running Joomla. >> >> Recently the mysql server has started hanging (perhaps 3-5 times a week) >> with a load (top) above 95%. >> >> Nothing shows up in /var/log/messages or dmesg nor ps -aux | grep my. >> >> How can I see what the mysql server is struggling with? I'd like to enable >> some sort of logging, but I'm not sure how to do it. Can anyone help me >> out >> a little here? >> >> Thanks and best regards, >> Andreas >> > > > > -- > ----------------------------- > Johnny Withers > 601.209.4985 > [EMAIL PROTECTED]