show create table performance_schema.events_waits_history_long; Table Create Table events_waits_history_long CREATE TABLE `events_waits_history_long` ( `THREAD_ID` bigint unsigned NOT NULL, `EVENT_ID` bigint unsigned NOT NULL, `END_EVENT_ID` bigint unsigned DEFAULT NULL, `EVENT_NAME` varchar(128) NOT NULL, `SOURCE` varchar(64) DEFAULT NULL, `TIMER_START` bigint unsigned DEFAULT NULL, `TIMER_END` bigint unsigned DEFAULT NULL, `TIMER_WAIT` bigint unsigned DEFAULT NULL, `SPINS` int unsigned DEFAULT NULL, `OBJECT_SCHEMA` varchar(64) DEFAULT NULL, `OBJECT_NAME` varchar(512) DEFAULT NULL, `INDEX_NAME` varchar(64) DEFAULT NULL, `OBJECT_TYPE` varchar(64) DEFAULT NULL, `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL, `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL, `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL, `OPERATION` varchar(32) NOT NULL, `NUMBER_OF_BYTES` bigint DEFAULT NULL, `FLAGS` int unsigned DEFAULT NULL ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci select * from INFORMATION_SCHEMA.STATISTICS where TABLE_SCHEMA = "performance_schema" and TABLE_NAME = "events_waits_history_long"; TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IS_VISIBLE EXPRESSION