What Linux command do I type to see my MySQL server load in real time?

ServerChecker asked:

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.

My answer:


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


View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.