Wednesday, January 25th, 2006
AjaxMyTop: MySQL Monitor
We’ve seen in-browser SQL, a database administrator, and even a database designer. Now there’s a database monitor…
AjaxMyTop shows active MySQL connections. You get a data grid showing connections, each showing ID, user, duration, and so on. Periodic Refresh ensures the connections are kept fresh, and you can easily set the refresh period in an input field. Being a true data grid, the connection list can be sorted and filtered on one or more fields. In a nice touch, the column heading morphs to include a text input when you want to type in a filter for that column. It’s nice to see keyboard shortcuts here, certainly a feature every DBA will welcome.
Right now it looks to be read-only … hopefully the team will add a “destroy connection” button real soon now!
there’s been a top ajax implementation out for a while here
[...] [AjaxMyTop: MySQL Monitor] [...]
This is not the same as what you link to noa. Your link is a web clone of the Unix utility ‘top’ This is a clone of Jeremy Zawodny’s unix utility ‘mytop’ which monitors a MySQL database. mytop is an essential tool for anyone doing any serious MySQL database administration or development.
[...] Buscando un poco en la red encontré en el blog de Ajaxian la herramienta que estaba necesitando. Un monitor de MySQL en Ajax (AjaxMyTop) que muestra periódicamente el estado actual de todas las conexiones a una base de datos. Es una herramienta muy sencilla que recién se esta comenzando a desarrollar (versión 0.1) pero que tiene un gran futuro. [...]
We actually have the ability to kill threads in the latest release. There might be a bug with the display, but you can kill threads by pressing “k” and then entering the thread ID.
Glad you guys like it, groove coder and I worked hard at making it
work well with XML while keeping performance.
_m
Someone AJAXified mytop!
Check this out. Someone has built and AJAX powered version of mytop, the little console based MySQL monitoring tool I wrote years ago. I guess it’s now buzzword compliant. If you can’t wait to get your hands on it, head over to the AjaxMyTop project…
[...] http://ajaxian.com/archives/779 [...]
Hi there, I just thought I would stop by and say hello. It’s been a hectic but very worthwhile last few days for me. In searching for more sql server programming related info on the Internet, I came across your site. I find your content really interesting and I thought to write some words. It’s been a great help in collecting more info on sql server programming. Thanks again and have a great day!
The above comment is just comment spam.
AjaxMyTop
mytop is a very valuable tool for mysql. It’s essentially a unix top command but for mysql threads. Recently created and bringing the same data to your web browser is the Ajax-ified version AjaxMyTop. Way cool!
mytop is a handy little program for monitoring MySQL queries that we’ve used in the past on a couple of our boxes so I decided to fire up this AJAX version and see how it fared.
Johnny
Mytop gives us a lot of information but understanding what mytop is actually telling us with the information is not easy from the start. There are currently two views in mytop version 1.4 but version 1.5 promises to add another view making three views in total.
Realy Mytop two versions?
My proect
Blog Cialis
Thanks
Thanks for showing us this. It will be interesting to see how it’s developing.
Tara, Freelancer currently working on the Stop Smoking Online Pharmacies project.
Great application, really help me to finish the site with the SQL database. thanks
- yuhirocks from fasting how to
Good application and good article. But i raise my hand for monyog always which i found as best application to monitor mysql and get best out of it.
We actually have the ability to kill threads in the latest release. There might be a bug with the display.
oldtimerock, sildenafil 100