• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

High MySQL usage on the Linux server

Started by HRamesh, September 20, 2008, 09:48:43 AM

HRamesh

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

Kailash

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

Web_news

If you want to monitor MySQL processes like top command, you can install mytop on your server. Search for mytop for the installation instruction. It will not take more than a minute to install.

hmb-willem

cPanel provides very helpful Mysql process check plugin called as WatchMySQL. You can install it easily on your server via SSH using following commands.

cd /usr/src
wget http://download.ndchost.com/watchmysql/latest-watchmysql
sh latest-watchmysql

It's that simple! Now log into the WHM, scroll down to the plugins section and click the 'WatchMySQL' link.