Debian Codegraph @

mysql-test/suite/perfschema/r/idx_innodb_redo_log_files.result

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