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 any other answers on Server Fault.

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