Post by Peter Cooper on September 23rd, 2006

MySQL Query Analyzer Plugin for Rails

Mysqlanalyzerplugin

Bob Silva has put together a fine MySQL query analyzer plugin for Ruby on Rails. It uses MySQL's EXPLAIN command to analyze all of the different SQL queries made by your Rails application (or, more accurately, by ActiveRecord!) and gives you the information you need to add better indexes (or add any extra indexes at all!) and could help show where a little custom SQL could silence a squeaky wheel.

This entry was posted on Saturday, September 23rd, 2006 at 2:22 am and is filed under Elsewhere, Ruby on Rails, Tools. Responses are currently closed, but you can trackback from your own site.

Previous Post: Control your Rails Process Sizes with Ruby 1.8.5
Next Post: Ola Bini looks at Ruby Metaprogramming Techniques

One Response to “MySQL Query Analyzer Plugin for Rails”

  1. #1
    Marston Online Says:
    September 23rd, 2006 at 6:17 am

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