If you’ve been using EXPLAIN ANALYZE
to analyse your MySQL queries, you may have encountered a little quirk regarding the output format: When we explicitly use FORMAT=TRADITIONAL
in our EXPLAIN ANALYZE
statement, we get an error. But when our explain_format
system variable is set to TRADITIONAL
we don’t get an error.
What’s going on with that? Is this a bug?
First up, no it’s not a bug. It can all be explained by the way EXPLAIN ANALYZE
handles our explain_format
setting.