SELECT * FROM information_schema.engines
WHERE ENGINE = 'MyISAM';
ENGINE	MyISAM
SUPPORT	YES
COMMENT	MyISAM storage engine
TRANSACTIONS	NO
XA	NO
SAVEPOINTS	NO