all tables of type MyISAM

SELECT TABLE_SCHEMA as DbName ,TABLE_NAME ,ENGINE FROM information_schema.TABLES WHERE ENGINE='MyISAM' AND TABLE_SCHEMA NOT IN('mysql','information_schema','performance_schema');