From: Sergei Golubchik
Date: June 4 2010 6:32am
Subject: Re: possible to use where clause on show engine status?
List-Archive: http://lists.mysql.com/internals/37931
Message-Id: <20100604063204.GA22628@janus.mylan>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi, Zardosht!

On Jun 03, Zardosht Kasheff wrote:
> Hello all,
> 
> Is it possible to limit the output of "show engine status" by using a
> where clause? I cannot find a way to do it, but I figured before
> ruling it out, I would post this question. For instance, can I filter
> something on the Name column?

No :(
It's one of the few SHOW commands that wasn't changed to use I_S
framework and it accepts no WHERE or LIKE clause.

You can only filter it by the engine name, that's all:
SHOW ENGINE TOKUDB STATUS
 
Regards,
Sergei