Mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. This is stated in it's site, however I have tried it on Mysql-5.0.18 and it works without any issue. With mytop monitoring mysql server is a lot more easier. After installing it from OpenBSD package, I just run it and it works :]
shell>mytop --password=Ilovesguil
Here's the screenshot of mytop .....
shell>mytop --password=Ilovesguil
Here's the screenshot of mytop .....

It shows the process info and who is currently login to the database.
1 comment:
"however I have tried it on Mysql-5.0.18 and it works without any issue"
I can see on screen shot that qps and qps now shows 0 ... but you have 1 query (id 2) active :) so this is a issue :)
Post a Comment