SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX_RESET; Table Create Table INNODB_CMP_PER_INDEX_RESET CREATE TEMPORARY TABLE `INNODB_CMP_PER_INDEX_RESET` ( `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