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:
Source Article : http://wpapi.com/how-to-find-the-mysql-database-engine-type