MySQL:’s new visual EXPLAIN provides a graphical representation of what the optimizer plans to run your code. Compare to CLI version below.

Optimizing MySQL Queries is often wrongly viewed by many DBAs as a ‘dark art’. For years we have been pre-pending EXPLAIN to SELECT statements in hopes of looking into the entrails of our offered code in hopes that the query optimizer deities looked whit favor on our efforts. But with MySQL 5.6 and the latest versions of MySQL Workbench, we have now entered into the age of an EXPLAIN that works with more than just SELECT statements and the ability to see graphically what is happening to our queries in the optimizer. Take a look at the two screen captures in this post and compare them. The query used is a very simple two table join from the good ol’ World database. Command Line EXPLAIN of a MySQL Query

I will dig into some other examples next post on what poor queries look like with VISUAL EXPLAIN as well as some well written queries. This is one graphic tool that an old command line dinosaur like me can enjoy!


2 Responses to EXPLAIN versus VISUAL EXPLAIN part I

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: