all tables of type InnoDB

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