In the daily Linux monitoring,we are facing the high mysql cpu usage problem but not sure which database or mysql query is using excessive CPU, at that time we can use the following commands to monitor the mysql process and optimize the offending database.
server@root[~]#mysqladmin proc stat
The above command will show you the current status for mysql process and if you want to check the continuously running mysql process then run the following command.
server@root[~]#mysqladmin -i3 pr
You can also install watchmysql to monitor the mysql
