SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX; Table Create Table INNODB_CMP_PER_INDEX CREATE TEMPORARY TABLE `INNODB_CMP_PER_INDEX` ( `database_name` varchar(64) NOT NULL DEFAULT '', `table_name` varchar(64) NOT NULL DEFAULT '', `index_name` varchar(64) NOT NULL DEFAULT '', `compress_ops` int(11) NOT NULL DEFAULT 0, `compress_ops_ok` int(11) NOT NULL DEFAULT 0, `compress_time` int(11) NOT NULL DEFAULT 0, `uncompress_ops` int(11) NOT NULL DEFAULT 0, `uncompress_time` int(11) NOT NULL DEFAULT 0 ) ENGINE=MEMORY DEFAULT CHARSET=utf8