Divi WordPress Theme

High MySQL usage on the Linux server

Topic: High MySQL usage on the Linux server  (Read 7075 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 »

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?


VPS Hosting - AccuWebHosting

Online Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 661
  • 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.


Both the commands require root access of the server.


Offline Web_news

  • New Member
  • *****
  • Premium Member
  • Posts: 43
  • 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.


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.
Shopify Divi WordPress Theme

Webmaster, are You Ready for High Volume Traffic?

Started by TechBoard Apache

Replies: 0
Views: 4329
Last post September 09, 2007, 10:59:46 AM
by Tech
High Page rank and Google search result

Started by AndrewBoard Google

Replies: 9
Views: 5597
Last post April 15, 2013, 11:07:33 AM
by Steve Smith
High bounce rate in Google analytics

Started by RajuBoard Google

Replies: 10
Views: 7047
Last post August 25, 2015, 09:37:51 AM
by Thechipper
GlasirHost | Free month and up to 40% off! | High performance hosting at only $2.97!

Started by GlasirHostBoard Paid Services

Replies: 0
Views: 2856
Last post November 27, 2009, 07:06:19 AM
by GlasirHost
Great Range of C Class IP Hosting at Low Price with High Uptime | Upto 200 IPs

Started by rfharrisBoard Web Hosting Offers

Replies: 0
Views: 1030
Last post March 27, 2017, 06:41:18 PM
by rfharris