How to find out which script or client is using too much of mysql?
I have dual Xeon with 1 GB of RAMToday I opened Cpanel >> CPU/Memory/MySQL Usage and saw the unusual mysql cpu usage
mysql 10.79 123.49 0.0
Top Process %CPU 0.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/labnix1.www-lab.com.pid --skip-locking
Top Process %CPU 0.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/labnix1.www-lab.com.pid --skip-locking
Top Process %CPU 0.7 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/labnix1.www-lab.com.pid --skip-locking
Top Process %CPU 0.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/labnix1.www-lab.com.pid --skip-locking
Top Process %CPU 0.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/labnix1.www-lab.com.pid --skip-locking
Top Process %CPU 0.7 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/labnix1.www-lab.com.pid --skip-locking
Thanks

