1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
show create table performance_schema.innodb_redo_log_files;
Table Create Table
innodb_redo_log_files CREATE TABLE `innodb_redo_log_files` (
`FILE_ID` bigint NOT NULL COMMENT 'Id of the file.',
`FILE_NAME` varchar(2000) NOT NULL COMMENT 'Path to the file.',
`START_LSN` bigint NOT NULL COMMENT 'LSN of the first block in the file.',
`END_LSN` bigint NOT NULL COMMENT 'LSN after the last block in the file.',
`SIZE_IN_BYTES` bigint NOT NULL COMMENT 'Size of the file (in bytes).',
`IS_FULL` tinyint NOT NULL COMMENT '1 iff file has no free space inside.',
`CONSUMER_LEVEL` int NOT NULL COMMENT 'All redo log consumers registered on smaller levels than this value, have already consumed this file.'
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from INFORMATION_SCHEMA.STATISTICS
where TABLE_SCHEMA = "performance_schema"
and TABLE_NAME = "innodb_redo_log_files";
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
|
