select TABLE_NAME,TABLE_SCHEMA,engine from information_schema.tables where engine=‘MyISAM‘ and TABLE_SCHEMA not in (‘mysql‘,‘performance_schema‘,‘information_schema‘);
MySQL巡检
原文：http://blog.51cto.com/395469372/2347272
