mysql_casual_explain

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

mysql_casual_explain

★ 9 Open GitHub ↗

Highlight problematic MySQL explain results.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# MysqlCasualExplain

Highlight problematic MySQL explain results.

Inspired by [MySQLCasualLog.pm](https://gist.github.com/kamipo/839e8a5b6d12bddba539).

[![Gem Version](https://badge.fury.io/rb/mysql_casual_explain.svg)](https://badge.fury.io/rb/mysql_casual_explain)
[![test](https://github.com/winebarrel/mysql_casual_explain/actions/workflows/test.yml/badge.svg)](https://github.com/winebarrel/mysql_casual_explain/actions/workflows/test.yml)

## Installation

Add this line to your application's Gemfile:

```ruby
gem 'mysql_casual_explain'
```

And then execute:

$ bundle install

Or install it yourself as:

$ gem install mysql_casual_explain

## Usage

```ruby
#!/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
```

![](https://user-images.githubusercontent.com/117768/89421006-7656dd00-d76e-11ea-844d-e0dd43ef8460.png)

## Test

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

mysql_casual_explain

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README