Track down MySQL queries?

I need a bit of help, I was wondering how you can track down MySQL queries that are using excessive amounts of CPU, for example this process:

Pid
Owner
Priority
Cpu %
Mem %
Command

7786
mysql
0
10.7
2.3
/usr/sbin/mysqld--basedir=/--datadir=/var/lib/mysql--user=mysql--pid-file=/var/lib/mysql/mercury.centurionhosting.com.pid--skip-locking--port=3306

how do i find out where it is coming from?

Thanks

 

 

 

 

Top