lunatechian (lunatech-ian)

one relating to, belonging to, or resembling lunatech

audit for incorrect engine

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');"