MysqlCasualExplain

Highlight problematic MySQL explain results.

Inspired by MySQLCasualLog.pm.

Installation

Add this line to your application's Gemfile:

gem 'mysql_casual_explain'

And then execute:

$ bundle install

Or install it yourself as:

$ gem install mysql_casual_explain

Usage

#!/usr/bin/env ruby
require 'active_record'
require 'mysql_casual_explain'

ActiveRecord::Base.establish_connection(
  adapter:  'mysql2',
  username: 'root',
  database: 'employees'
)

class Employee < ActiveRecord::Base; end

puts Employee.all.explain

Test

docker-compose build
docker-compose run client bundle exec appraisal ar60 rake