db engine type 확인방법

SELECT TABLE_NAME,
       ENGINE
FROM   information_schema.TABLES
WHERE  TABLE_SCHEMA = '{db 스키마명}';

SHOW TABLE STATUS;