MySQL Query Analyzer Rails Plugin Released
Bob Silva has released a fine MySQL Query Analyzer plugin for Rails. I’ve been looking for something like this for a while, I’m going to give it a shot and see how well it works. Check it out.
“With all that said, I wrote a plugin to make it easier to catch those mistakes and stay on top of your database optimizations. This plugin makes use of the EXPLAIN sql statement in MySQL to print out how MySQL formed its execution plan. Basically, for each SELECT query your application runs in the development or testing environments, Rails will also print the query execution plan right after it so you can quickly analyze the queries Rails is making and either add indexes, reorder your joins and remove unneeded or redundant indexes.”
.
Posted on September 22, 2006
Filed Under Analytics, Daily Thoughts, Ruby on Rails, Tech, Web
Related Posts:
-
RFacebook Rails Plugin
Making sure your email and news letters aren’t SPAM
Ruby on Rails 1.1 Released!
MySQL encoding and converting databases to UTF8
Ruby on Rails News, Links, Books and more
RESTful Rails Application Development PDF released in English
Comments
Leave a Reply
-
Projects
-
Search it all
-
About
I'm Marston and here you'll find my rantings, rhetoric and other useful info. I dig tech, photography, quantum physics and organic food. I'm the founder of SugarStats.com and thats my days developing.
-
Flickr
www.flickr.com
This is a Flickr badge showing public photos from Marston A.. Make your own badge here.
-
Twitter
- @ekivemark Just went though the same. Got it back today, everything running smooth so far... 5 hrs ago
- Oh snap. Well played. RT @TechCrunch: TechCrunch50: You Want Advertising? We'll Give You Advertising http://tcrn.ch/59t by @arrington 5 hrs ago
- Hah! RT @JasonCalacanis: Sarah Palin resigning in order to spend more time working on her banging body; gunning for Megan Fox in Maxim 6 hrs ago
- RT @cnnbrk: Palin stepping down as Alaska governor – http://bit.ly/3MjZx #sarahpalin 7 hrs ago
- Where can I buy @chrisco 's totally dope Obama tie-die shirt? http://tr.im/qNqj - New slogan: "Obama: Totally Dope." #obama 8 hrs ago
- Rolfcopter. I'm an ex-FPSer and think I might have just injured myself laughing. http://tr.im/qLta #duke-nukem-disease 13 hrs ago
- Just posted my pics from Reboot 11 and Copenhagen - http://www.flickr.com/photos/malffred/sets/72157620760789791/ #reboot11 13 hrs ago
- Rockin' out to The Glitch Mob - http://tr.im/qKBr 15 hrs ago
- More updates...