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.

  • 1
    Collect metrics with Cacti or Munin. – HTTP500 Jan 25 '13 at 18:42

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

| improve this answer | |

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

| 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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