1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
|
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA='INFORMATION_SCHEMA'
AND TABLE_NAME LIKE 'ROCKSDB%'
ORDER BY TABLE_NAME;
TABLE_NAME
ROCKSDB_CFSTATS
ROCKSDB_CF_OPTIONS
ROCKSDB_COMPACTION_STATS
ROCKSDB_DBSTATS
ROCKSDB_DDL
ROCKSDB_DEADLOCK
ROCKSDB_GLOBAL_INFO
ROCKSDB_INDEX_FILE_MAP
ROCKSDB_LOCKS
ROCKSDB_PERF_CONTEXT
ROCKSDB_PERF_CONTEXT_GLOBAL
ROCKSDB_SST_PROPS
ROCKSDB_TRX
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_CF_OPTIONS;
Table Create Table
ROCKSDB_CF_OPTIONS CREATE TEMPORARY TABLE `ROCKSDB_CF_OPTIONS` (
`CF_NAME` varchar(193) NOT NULL,
`OPTION_TYPE` varchar(193) NOT NULL,
`VALUE` varchar(193) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_CFSTATS;
Table Create Table
ROCKSDB_CFSTATS CREATE TEMPORARY TABLE `ROCKSDB_CFSTATS` (
`CF_NAME` varchar(193) NOT NULL,
`STAT_TYPE` varchar(193) NOT NULL,
`VALUE` bigint(21) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_COMPACTION_STATS;
Table Create Table
ROCKSDB_COMPACTION_STATS CREATE TEMPORARY TABLE `ROCKSDB_COMPACTION_STATS` (
`CF_NAME` varchar(193) NOT NULL,
`LEVEL` varchar(513) NOT NULL,
`TYPE` varchar(513) NOT NULL,
`VALUE` double NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_DBSTATS;
Table Create Table
ROCKSDB_DBSTATS CREATE TEMPORARY TABLE `ROCKSDB_DBSTATS` (
`STAT_TYPE` varchar(193) NOT NULL,
`VALUE` bigint(21) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_DDL;
Table Create Table
ROCKSDB_DDL CREATE TEMPORARY TABLE `ROCKSDB_DDL` (
`TABLE_SCHEMA` varchar(193) NOT NULL,
`TABLE_NAME` varchar(193) NOT NULL,
`PARTITION_NAME` varchar(193),
`INDEX_NAME` varchar(193) NOT NULL,
`COLUMN_FAMILY` int(11) NOT NULL,
`INDEX_NUMBER` int(11) NOT NULL,
`INDEX_TYPE` smallint(6) NOT NULL,
`KV_FORMAT_VERSION` smallint(6) NOT NULL,
`TTL_DURATION` bigint(21) NOT NULL,
`INDEX_FLAGS` bigint(21) NOT NULL,
`CF` varchar(193) NOT NULL,
`AUTO_INCREMENT` bigint(21) unsigned
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_DEADLOCK;
Table Create Table
ROCKSDB_DEADLOCK CREATE TEMPORARY TABLE `ROCKSDB_DEADLOCK` (
`DEADLOCK_ID` bigint(21) NOT NULL,
`TIMESTAMP` bigint(21) NOT NULL,
`TRANSACTION_ID` bigint(21) NOT NULL,
`CF_NAME` varchar(193) NOT NULL,
`WAITING_KEY` varchar(513) NOT NULL,
`LOCK_TYPE` varchar(193) NOT NULL,
`INDEX_NAME` varchar(193) NOT NULL,
`TABLE_NAME` varchar(193) NOT NULL,
`ROLLED_BACK` bigint(21) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
Table Create Table
ROCKSDB_GLOBAL_INFO CREATE TEMPORARY TABLE `ROCKSDB_GLOBAL_INFO` (
`TYPE` varchar(513) NOT NULL,
`NAME` varchar(513) NOT NULL,
`VALUE` varchar(513) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP;
Table Create Table
ROCKSDB_INDEX_FILE_MAP CREATE TEMPORARY TABLE `ROCKSDB_INDEX_FILE_MAP` (
`COLUMN_FAMILY` int(11) NOT NULL,
`INDEX_NUMBER` int(11) NOT NULL,
`SST_NAME` varchar(193) NOT NULL,
`NUM_ROWS` bigint(21) NOT NULL,
`DATA_SIZE` bigint(21) NOT NULL,
`ENTRY_DELETES` bigint(21) NOT NULL,
`ENTRY_SINGLEDELETES` bigint(21) NOT NULL,
`ENTRY_MERGES` bigint(21) NOT NULL,
`ENTRY_OTHERS` bigint(21) NOT NULL,
`DISTINCT_KEYS_PREFIX` varchar(800) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_LOCKS;
Table Create Table
ROCKSDB_LOCKS CREATE TEMPORARY TABLE `ROCKSDB_LOCKS` (
`COLUMN_FAMILY_ID` int(11) NOT NULL,
`TRANSACTION_ID` int(11) NOT NULL,
`KEY` varchar(513) NOT NULL,
`MODE` varchar(32) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT;
Table Create Table
ROCKSDB_PERF_CONTEXT CREATE TEMPORARY TABLE `ROCKSDB_PERF_CONTEXT` (
`TABLE_SCHEMA` varchar(193) NOT NULL,
`TABLE_NAME` varchar(193) NOT NULL,
`PARTITION_NAME` varchar(193),
`STAT_TYPE` varchar(193) NOT NULL,
`VALUE` bigint(21) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT_GLOBAL;
Table Create Table
ROCKSDB_PERF_CONTEXT_GLOBAL CREATE TEMPORARY TABLE `ROCKSDB_PERF_CONTEXT_GLOBAL` (
`STAT_TYPE` varchar(193) NOT NULL,
`VALUE` bigint(21) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_SST_PROPS;
Table Create Table
ROCKSDB_SST_PROPS CREATE TEMPORARY TABLE `ROCKSDB_SST_PROPS` (
`SST_NAME` varchar(193) NOT NULL,
`COLUMN_FAMILY` int(11) NOT NULL,
`DATA_BLOCKS` bigint(21) NOT NULL,
`ENTRIES` bigint(21) NOT NULL,
`RAW_KEY_SIZE` bigint(21) NOT NULL,
`RAW_VALUE_SIZE` bigint(21) NOT NULL,
`DATA_BLOCK_SIZE` bigint(21) NOT NULL,
`INDEX_BLOCK_SIZE` bigint(21) NOT NULL,
`INDEX_PARTITIONS` int(11) NOT NULL,
`TOP_LEVEL_INDEX_SIZE` bigint(21) NOT NULL,
`FILTER_BLOCK_SIZE` bigint(21) NOT NULL,
`COMPRESSION_ALGO` varchar(193) NOT NULL,
`CREATION_TIME` bigint(21) NOT NULL,
`FILE_CREATION_TIME` bigint(21) NOT NULL,
`OLDEST_KEY_TIME` bigint(21) NOT NULL,
`FILTER_POLICY` varchar(193) NOT NULL,
`COMPRESSION_OPTIONS` varchar(193) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE INFORMATION_SCHEMA.ROCKSDB_TRX;
Table Create Table
ROCKSDB_TRX CREATE TEMPORARY TABLE `ROCKSDB_TRX` (
`TRANSACTION_ID` bigint(21) NOT NULL,
`STATE` varchar(193) NOT NULL,
`NAME` varchar(193) NOT NULL,
`WRITE_COUNT` bigint(21) NOT NULL,
`LOCK_COUNT` bigint(21) NOT NULL,
`TIMEOUT_SEC` int(11) NOT NULL,
`WAITING_KEY` varchar(513) NOT NULL,
`WAITING_COLUMN_FAMILY_ID` int(11) NOT NULL,
`IS_REPLICATION` int(11) NOT NULL,
`SKIP_TRX_API` int(11) NOT NULL,
`READ_ONLY` int(11) NOT NULL,
`HAS_DEADLOCK_DETECTION` int(11) NOT NULL,
`NUM_ONGOING_BULKLOAD` int(11) NOT NULL,
`THREAD_ID` int(11) NOT NULL,
`QUERY` varchar(193) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
|