audit for incorrect engine
Posted by on No comments
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');"
No comments