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
>
>
