有同学表示,默认innodb引擎,初始库里部分表是myisam,如何找到所有非innodb的业务表呢?
查看默认引擎
SHOW VARIABLES LIKE 'storage_engine';
查看非InnoDB引擎的业务表:
select table_name,table_schema,engine from information_schema.tables where engine!='innodb' and table_schema not in('mysql','information_schema','performance_schema');
SHOW VARIABLES LIKE 'storage_engine';
查看非InnoDB引擎的业务表:
select table_name,table_schema,engine from information_schema.tables where engine!='innodb' and table_schema not in('mysql','information_schema','performance_schema');