lunatechian (lunatech-ian)

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

The tragedy of the San Francisco city is that it is always crowded. And if the weather is even remotely sunny, it gets even more crowded.