SELECT * FROM information_schema.engines
WHERE ENGINE = 'ARCHIVE';
ENGINE	ARCHIVE
SUPPORT	YES
COMMENT	gzip-compresses tables for a low storage footprint
TRANSACTIONS	NO
XA	NO
SAVEPOINTS	NO