Today I found an application called mtop that monitors MySQL queries. It shows you which queries are taking the most amount of time to complete.
To install mtop enter the following in the terminal
sudo apt-get install mtop
To run mtop enter the following in the terminal
mtop
A screenshot of mtop in action.
|
