webmytop - MySQL monitoring tool
5th October 2008 12:30
A few years ago I made an ASP.net version of Jeremy Zawodny's mytop tool, to use monitoring the MySQL servers that power play.tm.
The tool consists of two simple parts - some general uptime, number of query, etc stats and the process list MySQL generates with the query "show processlist".
The idea was to make it web-based and have the stats updating in near-realtime using AJAX. It worked a treat and many a poorly coded query has been reoptimised after this tool shows it up churning a machine.
Things have moved on since - now my language of choice is PHP and AJAX is all done through jQuery, so it was time for an update. I also figured that other people may be interested in using it, so we opensourced it.
You can find the source and download packages over here at code.google.com/p/webmytop.
RSS Feed
About
Jason is a freelance web developer based in London.
My clients include numerous startups & agencies, Google, YouTube, FHM, Nickelodeon, Volvo & the BBC.
I also co-own Ferrago Ltd, who publish videogames content to around 7m consumers monthly.
Links
- FriendFeed (lifestream)
- Twitter (microblogging)
- Flickr (photos)
- Facebook (social network)
- delicious (bookmarks)
- last.fm (music)
- LinkedIn (social network)
- Google Reader (bookmarks)
Colophon
- Built in Python & Django using a Mac and TextMate.
- Hosted on Google App Engine.
- Activity feed by FriendFeed and augmented by getURLinfo. Icons from getFavicon.