Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What Linux command can I type where I can watch MySQL server load in real time?

BACKGROUND: I can type 'top' and watch overall server load (just look at inverse of Idle % and consider it over a period of time). But I need to know how to see when MySQL is running into critical load and may run out of process handles or something like that unless I do something about it.

share|improve this question
Collect metrics with Cacti or Munin. – HTTP500 Jan 25 '13 at 18:42
up vote 5 down vote accepted

Try innotop, a top clone for MySQL. It is probably already in your package repositories.

share|improve this answer

I can recommend you mytop, a top clone for MySQL. It is also available in repositories of most common Linux distributions.

share|improve this answer
Hm. That doesn't seem to have been maintained in years. – Michael Hampton Jan 25 '13 at 22:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.