***BOGO*** mysqld hangs

["Andreas Andersen" <wodfer@xxxxxxxxx>]

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