Linux

Hi,

I have cPanel installed on one of the testing Linux server. I have noticed that MySQL using high resource on the server. I checked from WHM -> Show Running MySQL process but it didn't help me to check which MySQL database/user is using high resource. Is there any command through which I can check the resource usage from SSH?

Thanks,

Ramesh

[cPanel/WHM Configuration]

You can check the current running MySQL processes using following command:

watch -n 0.5 mysqladmin proc

Also you can use below command at mysql prompt (mysql>) to see the current database in used but it will not refresh automatically.

SHOW PROCESSLIST;

Both the commands require root access of the server.

Kailash