Compter le nombres de tables en InnoDB/MyISAM

SELECT engine, COUNT(engine) AS 'nb tables
FROM information_schema.tables
WHERE engine NOT IN ('NULL','CSV','MEMORY','PERFORMANCE_SCHEMA')
GROUP BY engine;