← Back to team overview

maria-discuss team mailing list archive

Re: [Maria-developers] Json Explain


@wlad is completely right!

Workbench introduced a Visual Explain based on JSON EXPLAIN as Blogged
here: http://www.arubin.org/blog/2012/09/26/mysql-visual-explain/

The very reason why JSON EXPLAIN was introduced in MySQL 5.6 could be that
Oracle develops the server and tools (WB, Enterprirse Monitor primarily) in
parallel.  Some recently introduced features in the server could be
introduced for the primary reason that they should be 'exploited' by MEM
and/or WB.  JSON EXPLAIN is one. Another example is the Performance_Schema
table introduced in 5.6.6 (I don't remember the table name)  that records
an 'aggregated summary' of queries' performance. Actually this table has
about the same information as what MONyog 'Query Analyzer' module displays
in its most simple display mode (but MONyog can be 'drilled down' to a more
detailed view).

So Oracle *thinks* the server and their most important tools *as a whole*,
I think. We/Webyog cannot ignore this, as we compete with Oracle (SQLyog
<-> WB, MONyog <-> MEM).  We have to consider to implement a more intuitive
and advisory way of displaying EXPLAIN results (for non-expert users
primarily of course). The JSON format is interesting for us in the context.

-- Peter

On Fri, Sep 28, 2012 at 4:50 PM, Vladislav Vaintroub

> > -----Original Message-----
> > From: maria-discuss-
> > bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx [mailto:maria-
> > discuss-bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx] On Behalf
> > Of Michael Widenius
> > Sent: Freitag, 28. September 2012 16:04
> > To: Peter Laursen; igor@xxxxxxxxxxxx; timour@xxxxxxxxxxxx;
> > psergey@xxxxxxxxxxxx
> > Cc: Maria Discuss; Maria Developers
> > Subject: Re: [Maria-discuss] [Maria-developers] Json Explain
> >
> >
> > For the moment we don't have a plan for that.
> >
> > The main reason is that the MariadB optimizer people don't like the
> > implementation and we are not sure how useful the current output
> > really is.
> >
> I guess json  is not for normal people to read , it is for programs to
> analyze and ,for example, display in a visually pleasing fashion. I believe
> this is the reason why Peter asks, and (I guess) the reason why Workbench
> has visual explain feature now for 5.6+.
> http://www.arubin.org/blog/2012/09/26/mysql-visual-explain/

Follow ups