MySQL 5.7 & Workbench 6.1 Query Plans


MySQl 5.7 and Workbench 6.1 Query Plan

MySQL 5.7 and Workbench 6.1 work together to provide an even prettier version of a query plan than the impressive stuff from the 5.6/6.0 combo

Here is a sneak peek at MySQL Workbench 6.1′s VISUAL EXPLAIN.

Recently I was demonstrating the difference between using EXPLAIN and VISUAL EXPLAIN to a full room at the fantastic SkiPHP Conference in Salt Lake City. MySQL 5.6 and Workbench 6.0 combine to make an easy to read graphic that aids in understanding the Query Plan Generated by the Optimizer. All in the audience agrees that the ASCII-ish output of EXPLAIN paled in comparison to VISUAL EXPLAIN. Now MySQL 5.7 and Workbench 6.1 work together to provide an even better VISUAL EXPLAIN.

I really meant to test 5.7/6.0 on the plane on the way to SLC but did not get around to it. If I had known, I would have covered the new VISUAL EXPLAIN at SkiPHP. So those who attended, please accept my apology!

For those who do not know, VISUAL EXPLAIN takes a query, such as
SELECT Country.Name, City.Name, Language
FROM CountryLanguage
JOIN Country on (CountryLanguage.CountryCode = Country.Code)
JOIN City on (City.CountryCode = Country.Code)
WHERE IsOfficial = 'T' AND City.Population > 1000000;

and generates a graphic as seen at the start of this blog post. There are lots of great docs on using EXPLAIN, and some on VISUAL explain. Now I am eagerly awaiting the Workbench 6.1 docs to learn more.

About these ads

2 Comments

Filed under MySQL

2 responses to “MySQL 5.7 & Workbench 6.1 Query Plans

  1. I’ve already used MySQL 5.7 and Workbench 6.1 in my Mac and PC. Why can’t I display visual explain like in the article’s picture?

    Thanx…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s