From: Stewart Smith Date: June 5 2010 12:50am Subject: Re: possible to use where clause on show engine status? List-Archive: http://lists.mysql.com/internals/37934 Message-Id: <877hmeqp50.fsf@willster.local.flamingspork.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii On Fri, 4 Jun 2010 08:32:04 +0200, Sergei Golubchik wrote: > 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 I think Brian has moved this into a table function for us (Drizzle)... although going from memory, using the I_S framework for this could end up with as many problems as you solve. -- Stewart Smith