[Koha] MySQL using 99% CPU and making web site slow to a crawl

[Chris Cormack]

On Wed, Nov 01, 2006 at 08:08:36AM +1000, Greg Vickers said:
> Hi all,
> 
> I don't know what to do to investigate MySQL to find out why it is using 
> up so much CPU time, or if there is some abnormal data entered in the 
> Koha web site that causes MySQL to do this. Can anyone give me some tips 
> or pointers on what to do?
> 
Hi Greg

show processlist \g;  Is a great command to run in mysql, it will show
you what is causing it to lock up. 
So if you can find the offending query with that command, then we can
start to look into why its going bad.

Hope this helps

Chris



-- 
Chris Cormack                                                     Programmer
027 4500 789                                       Katipo Communications Ltd
chris at katipo.co.nz                                          www.katipo.co.nz