Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Why Use EXPLAIN FORMAT=JSON?

Why Use EXPLAIN FORMAT=JSON?

 19 April 04:50 PM - 5:15 PM @ Ballroom C
Experience level: 
Beginner
Duration: 
25 minutes conference
Tracks:
Architecture/Design
Development
Topics:
MySQL
Optimization
Tools and Techniques

Description

Although EXPLAIN FORMAT=JSON was first presented a long time ago, there still aren't many resources that explain how and why to use it. The most advertised feature is visual EXPLAIN in MySQL Workbench, but this format can do more than create nice pictures. It prints additional information that can't be found in good old tabular EXPLAIN, and can help to solve many tricky performance issues. In this session, I will not only describe which additional information we can get with the new syntax, but also provide examples showing how to use it to diagnose production issues.

Speakers

Sveta Smirnova's picture

Sveta Smirnova

Principal Technical Services Engineer, Percona

Biography:

Sveta Smirnova works as MySQL Support engineer since year 2006, she is also author of book "MySQL Troubleshooting" and author of JSON UDF functions for MySQL. In years 2006 - 2015 she worked in in Bugs Analysis MySQL Support Group in MySQL AB, then Sun, then Oracle. In March 2015 Sveta joined Support Team in Percona. In years 2012-2015 she worked on bugs priority. She was also Support representative in MySQL Backup Development Team. She works on tricky support issues and MySQL software bugs on a daily basis. Before starting at MySQL in 2006, she worked as web developer on several closed CRM systems. In years 2012-2015 she worked on MySQL Labs project "JSON UDFs for MySQL". She is active participant in the open source community. Her main interests in recent years is solving DBA problems, finding ways to semi-automate this process and effective backup techniques. Sveta is author of the book "MySQL Troubleshooting" (http://shop.oreilly.com/product/0636920021964.do)

Share this talk