From: Eric Bergen
Date: June 28 2004 11:18pm
Subject: Re: MySQL Storage Engines and Table Types.....
List-Archive: http://lists.mysql.com/mysql/168049
Message-Id: <11b1bd9904062816183209d3ba@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Show table status\G 
Will give you a list of tables the Type: field for each table is the
storage engine. Your installation probably defaults to MyISAM

-Eric 

On Mon, 28 Jun 2004 11:51:40 -0400, sgreen@stripped <sgreen@stripped> wrote:
> 
> 
> You can see a list of the available storage types with  SHOW ENGINES
> 
> To see which engine is in use for any table you can SHOW TABLE STATUS or
> SHOW CREATE TABLE <tablename>
> 
> All of these commands, and more, are documented at :
> http://dev.mysql.com/doc/mysql/en/SHOW.html
> 
> Yours,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
>                       "Scott Fletcher"
>                       <SFletcher@abcoa.        To:       <mysql@stripped>
>                       com>                     cc:
>                                                Fax to:
>                       06/28/2004 11:27         Subject:  MySQL Storage Engines and Table Types.....
>                       AM
> 
> 
> 
> 
> Hi!
> 
>     How do I know which of the storage engine am I using or running, or
> whatever that use the databases/tables?
> 
> Thanks,
>  Scott F.
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
>