Thursday, January 26, 2006

Mytop - Top of Mysql

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 .....


It shows the process info and who is currently login to the database.

1 comment:

Anonymous said...

"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 :)