Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

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

0 Members and 1 Guest are viewing this topic.

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

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

  • Premium Member
  • New 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

  • Guest
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:
 

Related Topics

  Subject / Started by Replies Last post
8 Replies
55644 Views
Last post December 01, 2016, 01:07:34 PM
by Mooni
1 Replies
2953 Views
Last post January 28, 2016, 01:45:49 PM
by hmb-willem
2 Replies
1673 Views
Last post June 15, 2013, 11:26:37 AM
by Web_news
0 Replies
343 Views
Last post April 15, 2016, 02:47:23 PM
by rumsfo
0 Replies
159 Views
Last post March 21, 2017, 04:59:25 PM
by Chris