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
