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, `table_name` varchar(64) NOT NULL, `index_name` varchar(64) NOT NULL, `compress_ops` int(11) NOT NULL, `compress_ops_ok` int(11) NOT NULL, `compress_time` int(11) NOT NULL, `uncompress_ops` int(11) NOT NULL, `uncompress_time` int(11) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci