What Linux command do I type to see my MySQL server load in real time?
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.
Solution 1:
Try innotop, a top
clone for MySQL. It is probably already in your package repositories.
Solution 2:
I can recommend you mytop, a top clone for MySQL. It is also available in repositories of most common Linux distributions.