You need to use this command for checking the engine type:
SHOW TABLE STATUS WHERE Name = ‘users’;
Or Use this command for checking the all table’s engine type.
SHOW TABLE STATUS;
Or You can use this command for database:
mysqlshow –status db_name;
I used following URL for creating this commands:
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html
5 
SHOW TABLE STATUS WHERE Name = 'xxx'
Incoming search terms:
- mysql show database engine type
- how to check mysql database engine
- how to find mysql engine of a database
- howto know mysql database engine
Pingback: uberVU - social comments