Divi WordPress Theme

Topic: High MySQL usage on the Linux server  (Read 4366 times)

Offline HRamesh

  • New Member
  • *
  • Posts: 34
  • iTrader: +0/-0
    • View Profile
High MySQL usage on the Linux server
« on: September 20, 2008, 09:48:43 AM »
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
VPS Hosting - AccuWebHosting

Offline Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 604
  • iTrader: +153/-0
    • View Profile
Re: High MySQL usage on the Linux server
« Reply #1 on: September 21, 2008, 09:45:52 AM »
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

Offline Web_news

  • New Member
  • *****
  • Premium Member
  • Posts: 44
  • iTrader: +5/-0
    • View Profile
Re: High MySQL usage on the Linux server
« Reply #2 on: August 11, 2014, 08:01:00 PM »
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

Re: High MySQL usage on the Linux server
« Reply #3 on: January 28, 2016, 01:19:10 PM »
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.
Divi WordPress Theme
Tags: