tags:

views:

7184

answers:

3

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?

+9  A: 

SHOW TABLE STATUS WHERE Name = 'xxx'

This will give you (among other things) an Engine column, which is what you want.

Greg
+5  A: 
show create table <tablename>;

less parseable but more readable that show table status.

Javier
+1  A: 

or just

show table status;

just that this will llist all tables on your database.