Re: mysqld hangs

[Andreas Wideroe]

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 <johnny@stripped>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 <wodfer@stripped> 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
> johnny@stripped