If you use innodb engine exclusively, and want to audit your databases for any tables that might have an incorrect engine, use the command below -
mysql -u root -p information_schema -e \
"select TABLE_SCHEMA,TABLE_NAME, ENGINE from TABLES where\
ENGINE != 'Innodb' \
and TABLE_SCHEMA not in ('mysql','information_schema');"