neurofuzzy, flash game development, rich internet applications, free source code – *alt.neurotica.fuzzy*

neurofuzzy, flash game development, rich internet applications, free source code – *alt.neurotica.fuzzy*

12/24/2011

MySQL Slow Query Log Visualizer

Filed under: General — geoff @ 9:03 pm

I needed a way to visualize slow query logs, and I couldn’t find anything out there that quite suited my needs, so I went ahead and built one. Of course, my first thought was to build something in Adobe AIR, but then I thought I should start fiddling with HTML5.

The results of my efforts can be found here.

It’s pretty simple, actually. Only about 200 lines of JS, some CSS and a single HTML page. All the work is done client-side. There’s actually not a lot of HTML5-ness that I coded. I owe a lot to the coolness of list.js and jQuery Visualize.

Keep in mind, if you are using Google Chrome, the app must be hosted on a local (or remote) web server in order to parse the log. Firefox works, and seems to not care either way. This currently does not work in Safari, and I have not tested this in IE9. It probably doesn’t work.

I hope you find this useful. As always, your feedback is welcome. Happy Holidays!

Get MySQL Slow Query Log Visualizer at Google Code

2 Comments

  1. "Keep in mind, if you are using Google Chrome, the app must be hosted on a local (or remote) web server in order to parse the log. Firefox works, and seems to not care either way. This currently does not work in Safari, and I have not tested this in IE9. It probably doesn’t work."
    So why not use AIR?

    Comment by Gil — 12/25/2011 @ 5:56 am

  2. Because it was literally 200 or so lines of code. Most of the heavy lifting is done with list.js and visualize.js. If I could have done it in 200 lines in AIR, I might have chosen that. Even so, I doubt performance would be nearly as good. The logs can get quite large, and web browsers are pretty good at displaying and formatting lots and lots of tabular data.

    Comment by ggaudrea — 12/26/2011 @ 1:37 am

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

 

Powered by WordPress