Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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
1  
Collect metrics with Cacti or Munin. –  HTTP500 Jan 25 '13 at 18:42

2 Answers 2

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
1  
Hm. That doesn't seem to have been maintained in years. –  Michael Hampton Jan 25 '13 at 22:14

Your Answer

 
discard

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.