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@katipo.co.nz www.katipo.co.nz