List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:June 28 2004 11:18pm
Subject:Re: MySQL Storage Engines and Table Types.....
View as plain text  
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=1
> 
>
Thread
MySQL Storage Engines and Table Types.....Scott Fletcher28 Jun
RE: MySQL Storage Engines and Table Types.....Victor Pendleton28 Jun
Re: MySQL Storage Engines and Table Types.....SGreen28 Jun
  • Re: MySQL Storage Engines and Table Types.....Eric Bergen29 Jun