What Linux command can I type where I can watch MySQL server load in real time?
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.
Try innotop, a
top clone for MySQL. It is probably already in your package repositories.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.