Tracking down a script using CPU.

I have a little issue, not really a huge problem, but I'd like to get an answer.
At times my mysqld CPU usage jumps to almost 100%, and stays like that for a good amount of time, making EVERYTHING lag like a hell, I have a bad feeling that it's some of the guys' PHP script I host. But I need to know how can I track down the script which causes this.

The server runs under Fedora 1, and the mysql server version is 4.0.20-standard.

Also, is there a way to limit how much mysql server can use CPU in the first place?

Any tips are appreciated.

Thanks. Tracking down a script using CPU.

 

 

 

 

Top