MyRocks公开了几个有用的信息模式表，它们提供了有关数据库当前状态的更多信息。 下面是每个表的说明以及一些示例用法+输出:
有关更多用法示例，请参阅rocksdb.information_schema测试用例:
CREATE TABLE t1 (i1 INT, i2 INT, PRIMARY KEY (i1)) ENGINE = ROCKSDB;
INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);
SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
+--------------+--------------+----------------------------------------+
| TYPE | NAME | VALUE |
+--------------+--------------+----------------------------------------+
| BINLOG | FILE | master-bin.000001 |
| BINLOG | POS | 571 |
| BINLOG | GTID | 84ca021b-6a47-11e6-87e3-de7cd2a9d83f:2 |
| MAX_INDEX_ID | MAX_INDEX_ID | 260 |
| CF_FLAGS | 0 | default [0] |
| CF_FLAGS | 1 | __system__ [0] |
+--------------+--------------+----------------------------------------+
* Binlog - 显示执行的文件，当前pos位置和最后一个gtid
* DDL_DROP_INDEX_ONGOING - 显示当前正在删除的索引（如果有）
* CF_FLAGS - 显示cf id和name
* MAX_INDEX_ID - 显示当前最大索引ID
rocksdb_ddl包含有关RocksDB中包含的当前现有 表/索引 的信息:
CREATE TABLE t1 (i1 INT, i2 INT, PRIMARY KEY (i1)) ENGINE = ROCKSDB;
CREATE TABLE t2 (a int, b int, c int, d int, e int,
PRIMARY KEY (a) COMMENT "cf_a",
KEY (b) COMMENT "cf_b",
KEY (c) COMMENT "cf_c",
KEY (d) COMMENT "$per_index_cf",
KEY (e) COMMENT "rev:cf_d") ENGINE=ROCKSDB;
);
mysql> select * from information_schema.rocksdb_ddl;
+--------------+----------------------+----------------+------------+---------------+--------------+------------+-------------------+-----------+
| TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | INDEX_NAME | COLUMN_FAMILY | INDEX_NUMBER | INDEX_TYPE | KV_FORMAT_VERSION | CF |
+--------------+----------------------+----------------+------------+---------------+--------------+------------+-------------------+-----------+
| mysql | slave_gtid_info | NULL | | 0 | 259 | 1 | 11 | default |
| mysql | slave_relay_log_info | NULL | PRIMARY | 0 | 256 | 1 | 11 | default |
| mysql | slave_master_info | NULL | PRIMARY | 0 | 257 | 1 | 11 | default |
| test | t2 | NULL | PRIMARY | 2 | 263 | 1 | 11 | cf_a |
| test | t2 | NULL | b | 3 | 264 | 2 | 11 | cf_b |
| test | t2 | NULL | c | 4 | 265 | 2 | 11 | cf_c |
| test | t2 | NULL | d | 5 | 266 | 2 | 11 | test.t2.d |
| test | t2 | NULL | e | 6 | 267 | 2 | 11 | rev:cf_d |
| mysql | slave_worker_info | NULL | PRIMARY | 0 | 258 | 1 | 11 | default |
| test | t1 | NULL | PRIMARY | 0 | 260 | 1 | 11 | default |
| test | t1 | NULL | tindex1 | 0 | 261 | 2 | 11 | default |
| test | t1 | NULL | tindex2 | 0 | 262 | 2 | 11 | default |
+--------------+----------------------+----------------+------------+---------------+--------------+------------+-------------------+-----------+
* TABLE_SCHEMA - 数据库schema名称
* TABLE_NAME - 表名称
* PARTITION_NAME - 分区名称(如果有)
* INDEX_NAME - 索引名称
* COLUMN_FAMILY - 索引所属的列族
* INDEX_NUMBER - 索引号
* INDEX_TYPE - 主键索引、二级索引或隐藏索引(对应1、2、3)
* KV_FORMAT_VERSION - 键和值的版本格式
* CF - 列族对应索引
包含有关当前现有列系列的统计信息:
CREATE TABLE t1 (i INT, PRIMARY KEY (i) COMMENT 'cf_t1') ENGINE = ROCKSDB;
mysql> select * from information_schema.rocksdb_cfstats;
+------------+-------------------------------+-------+
| CF_NAME | STAT_TYPE | VALUE |
+------------+-------------------------------+-------+
| __system__ | NUM_IMMUTABLE_MEM_TABLE | 0 |
| __system__ | MEM_TABLE_FLUSH_PENDING | 0 |
| __system__ | COMPACTION_PENDING | 0 |
| __system__ | CUR_SIZE_ACTIVE_MEM_TABLE | 1160 |
| __system__ | CUR_SIZE_ALL_MEM_TABLES | 1160 |
| __system__ | NUM_ENTRIES_ACTIVE_MEM_TABLE | 24 |
| __system__ | NUM_ENTRIES_IMM_MEM_TABLES | 0 |
| __system__ | NON_BLOCK_CACHE_SST_MEM_USAGE | 0 |
| __system__ | NUM_LIVE_VERSIONS | 1 |
| cf_t1 | NUM_IMMUTABLE_MEM_TABLE | 0 |
| cf_t1 | MEM_TABLE_FLUSH_PENDING | 0 |
| cf_t1 | COMPACTION_PENDING | 0 |
| cf_t1 | CUR_SIZE_ACTIVE_MEM_TABLE | 192 |
| cf_t1 | CUR_SIZE_ALL_MEM_TABLES | 192 |
| cf_t1 | NUM_ENTRIES_ACTIVE_MEM_TABLE | 0 |
| cf_t1 | NUM_ENTRIES_IMM_MEM_TABLES | 0 |
| cf_t1 | NON_BLOCK_CACHE_SST_MEM_USAGE | 0 |
| cf_t1 | NUM_LIVE_VERSIONS | 1 |
| default | NUM_IMMUTABLE_MEM_TABLE | 0 |
| default | MEM_TABLE_FLUSH_PENDING | 0 |
| default | COMPACTION_PENDING | 0 |
| default | CUR_SIZE_ACTIVE_MEM_TABLE | 192 |
| default | CUR_SIZE_ALL_MEM_TABLES | 192 |
| default | NUM_ENTRIES_ACTIVE_MEM_TABLE | 0 |
| default | NUM_ENTRIES_IMM_MEM_TABLES | 0 |
| default | NON_BLOCK_CACHE_SST_MEM_USAGE | 0 |
| default | NUM_LIVE_VERSIONS | 1 |
+------------+-------------------------------+-------+
提供有关数据库的信息，例如后台错误，当前打开的快照数，当前快照打开的时间以及阻止缓存使用情况:
mysql> SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_DBSTATS;
+-------------------------+-------+
| STAT_TYPE | VALUE |
+-------------------------+-------+
| DB_BACKGROUND_ERRORS | 0 |
| DB_NUM_SNAPSHOTS | 0 |
| DB_OLDEST_SNAPSHOT_TIME | 0 |
| DB_BLOCK_CACHE_USAGE | 295 |
+-------------------------+-------+
包含RocksDB的性能统计信息。可以通过rocksdb_perf_context_level变量启用这些计数器。
有关更多用法示例，请参阅rocksdb.perf_context测试用例。
CREATE TABLE t1 (i INT, j INT, PRIMARY KEY (i)) ENGINE = ROCKSDB;
CREATE TABLE t2 (k INT, PRIMARY KEY (k)) ENGINE = ROCKSDB;
INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
mysql> SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT WHERE TABLE_NAME = 't1';
+--------------+------------+----------------+---------------------------------+-------+
| TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | STAT_TYPE | VALUE |
+--------------+------------+----------------+---------------------------------+-------+
| test | t1 | NULL | USER_KEY_COMPARISON_COUNT | 15 |
| test | t1 | NULL | BLOCK_CACHE_HIT_COUNT | 0 |
| test | t1 | NULL | BLOCK_READ_COUNT | 0 |
| test | t1 | NULL | BLOCK_READ_BYTE | 0 |
| test | t1 | NULL | BLOCK_READ_TIME | 0 |
| test | t1 | NULL | BLOCK_CHECKSUM_TIME | 0 |
| test | t1 | NULL | BLOCK_DECOMPRESS_TIME | 0 |
| test | t1 | NULL | INTERNAL_KEY_SKIPPED_COUNT | 0 |
| test | t1 | NULL | INTERNAL_DELETE_SKIPPED_COUNT | 0 |
| test | t1 | NULL | GET_SNAPSHOT_TIME | 3010 |
| test | t1 | NULL | GET_FROM_MEMTABLE_TIME | 0 |
| test | t1 | NULL | GET_FROM_MEMTABLE_COUNT | 0 |
| test | t1 | NULL | GET_POST_PROCESS_TIME | 3029 |
| test | t1 | NULL | GET_FROM_OUTPUT_FILES_TIME | 5670 |
| test | t1 | NULL | SEEK_ON_MEMTABLE_TIME | 0 |
| test | t1 | NULL | SEEK_ON_MEMTABLE_COUNT | 0 |
| test | t1 | NULL | SEEK_CHILD_SEEK_TIME | 0 |
| test | t1 | NULL | SEEK_CHILD_SEEK_COUNT | 0 |
| test | t1 | NULL | SEEK_IN_HEAP_TIME | 0 |
| test | t1 | NULL | SEEK_INTERNAL_SEEK_TIME | 0 |
| test | t1 | NULL | FIND_NEXT_USER_ENTRY_TIME | 0 |
| test | t1 | NULL | WRITE_WAL_TIME | 32111 |
| test | t1 | NULL | WRITE_MEMTABLE_TIME | 16537 |
| test | t1 | NULL | WRITE_DELAY_TIME | 0 |
| test | t1 | NULL | WRITE_PRE_AND_POST_PROCESS_TIME | 13775 |
| test | t1 | NULL | DB_MUTEX_LOCK_NANOS | 0 |
| test | t1 | NULL | DB_CONDITION_WAIT_NANOS | 0 |
| test | t1 | NULL | MERGE_OPERATOR_TIME_NANOS | 0 |
| test | t1 | NULL | READ_INDEX_BLOCK_NANOS | 0 |
| test | t1 | NULL | READ_FILTER_BLOCK_NANOS | 0 |
| test | t1 | NULL | NEW_TABLE_BLOCK_ITER_NANOS | 0 |
| test | t1 | NULL | NEW_TABLE_ITERATOR_NANOS | 0 |
| test | t1 | NULL | BLOCK_SEEK_NANOS | 0 |
| test | t1 | NULL | FIND_TABLE_NANOS | 0 |
| test | t1 | NULL | IO_THREAD_POOL_ID | 2 |
| test | t1 | NULL | IO_BYTES_WRITTEN | 173 |
| test | t1 | NULL | IO_BYTES_READ | 0 |
| test | t1 | NULL | IO_OPEN_NANOS | 0 |
| test | t1 | NULL | IO_ALLOCATE_NANOS | 0 |
| test | t1 | NULL | IO_WRITE_NANOS | 23209 |
| test | t1 | NULL | IO_READ_NANOS | 0 |
| test | t1 | NULL | IO_RANGE_SYNC_NANOS | 0 |
| test | t1 | NULL | IO_LOGGER_NANOS | 0 |
+--------------+------------+----------------+---------------------------------+-------+
mysql> SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT_GLOBAL;
+---------------------------------+-------+
| STAT_TYPE | VALUE |
+---------------------------------+-------+
| USER_KEY_COMPARISON_COUNT | 15 |
| BLOCK_CACHE_HIT_COUNT | 0 |
| BLOCK_READ_COUNT | 0 |
| BLOCK_READ_BYTE | 0 |
| BLOCK_READ_TIME | 0 |
| BLOCK_CHECKSUM_TIME | 0 |
| BLOCK_DECOMPRESS_TIME | 0 |
| INTERNAL_KEY_SKIPPED_COUNT | 0 |
| INTERNAL_DELETE_SKIPPED_COUNT | 0 |
| GET_SNAPSHOT_TIME | 3010 |
| GET_FROM_MEMTABLE_TIME | 0 |
| GET_FROM_MEMTABLE_COUNT | 0 |
| GET_POST_PROCESS_TIME | 3029 |
| GET_FROM_OUTPUT_FILES_TIME | 5670 |
| SEEK_ON_MEMTABLE_TIME | 0 |
| SEEK_ON_MEMTABLE_COUNT | 0 |
| SEEK_CHILD_SEEK_TIME | 0 |
| SEEK_CHILD_SEEK_COUNT | 0 |
| SEEK_IN_HEAP_TIME | 0 |
| SEEK_INTERNAL_SEEK_TIME | 0 |
| FIND_NEXT_USER_ENTRY_TIME | 0 |
| WRITE_WAL_TIME | 32111 |
| WRITE_MEMTABLE_TIME | 16537 |
| WRITE_DELAY_TIME | 0 |
| WRITE_PRE_AND_POST_PROCESS_TIME | 13775 |
| DB_MUTEX_LOCK_NANOS | 0 |
| DB_CONDITION_WAIT_NANOS | 0 |
| MERGE_OPERATOR_TIME_NANOS | 0 |
| READ_INDEX_BLOCK_NANOS | 0 |
| READ_FILTER_BLOCK_NANOS | 0 |
| NEW_TABLE_BLOCK_ITER_NANOS | 0 |
| NEW_TABLE_ITERATOR_NANOS | 0 |
| BLOCK_SEEK_NANOS | 0 |
| FIND_TABLE_NANOS | 0 |
| IO_THREAD_POOL_ID | 2 |
| IO_BYTES_WRITTEN | 173 |
| IO_BYTES_READ | 0 |
| IO_OPEN_NANOS | 0 |
| IO_ALLOCATE_NANOS | 0 |
| IO_WRITE_NANOS | 23209 |
| IO_READ_NANOS | 0 |
| IO_RANGE_SYNC_NANOS | 0 |
| IO_LOGGER_NANOS | 0 |
+---------------------------------+-------+
INTERNAL_KEY_SKIPPED_COUNT ==> 跟踪迭代器遍历索引需要跳过的键数。正常范围扫描可能导致此计数器增加。 但是，如果点查找导致此增加或者如果跳过的键数明显高于查询返回的行数，则LSM可能存在太多陈旧键。 INTERNAL_DELETE_SKIPPED_COUNT ==> 跟踪迭代器扫描期间需要跳过的删除键的数量。
有关为每个列族设置的选项的信息: 有关可用选项的完整列表，请参阅https://github.com/facebook/rocksdb/blob/master/examples/rocksdb_option_file_example.ini
create table t1 (a int, primary key (a) comment 'cf1') engine=rocksdb;
create table t2 (a int, primary key (a) comment 'cf2') engine=rocksdb;
select cf_name, option_type, value
from information_schema.rocksdb_cf_options
where option_type in ('WRITE_BUFFER_SIZE',
'TARGET_FILE_SIZE_BASE',
'MAX_BYTES_FOR_LEVEL_MULTIPLIER')
order by cf_name, option_type;
+------------+--------------------------------+----------+
| cf_name | option_type | value |
+------------+--------------------------------+----------+
| cf1 | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10 |
| cf1 | TARGET_FILE_SIZE_BASE | 67108864 |
| cf1 | WRITE_BUFFER_SIZE | 4194304 |
| cf2 | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10 |
| cf2 | TARGET_FILE_SIZE_BASE | 67108864 |
| cf2 | WRITE_BUFFER_SIZE | 4194304 |
| default | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10 |
| default | TARGET_FILE_SIZE_BASE | 67108864 |
| default | WRITE_BUFFER_SIZE | 4194304 |
| __system__ | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10 |
| __system__ | TARGET_FILE_SIZE_BASE | 67108864 |
| __system__ | WRITE_BUFFER_SIZE | 4194304 |
+------------+--------------------------------+----------+
有关更多用法示例，请参阅rocksdb.index_file_map测试用例。
CREATE TABLE t1 (i INT PRIMARY KEY, j INT, INDEX(j)) ENGINE = ROCKSDB;
INSERT INTO t1 VALUES (1,2), (2,4), (3,6), (4,8), (5,10);
SET GLOBAL rocksdb_force_flush_memtable_now = 1;
SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP
WHERE INDEX_NUMBER =
(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.ROCKSDB_DDL
WHERE TABLE_NAME = 't1' AND INDEX_NAME = "PRIMARY");
+---------------+--------------+------------+----------+-----------+---------------+---------------------+--------------+--------------+----------------------+
| COLUMN_FAMILY | INDEX_NUMBER | SST_NAME | NUM_ROWS | DATA_SIZE | ENTRY_DELETES | ENTRY_SINGLEDELETES | ENTRY_MERGES | ENTRY_OTHERS | DISTINCT_KEYS_PREFIX |
+---------------+--------------+------------+----------+-----------+---------------+---------------------+--------------+--------------+----------------------+
| 0 | 261 | 000026.sst | 5 | 65 | 0 | 0 | 0 | 0 | 10 |
+---------------+--------------+------------+----------+-----------+---------------+---------------------+--------------+--------------+----------------------+
* COLUMN_FAMILY => SST文件中包含的索引列系列
* INDEX_NUMBER => SST文件中包含的索引ID
* SST_NAME => 包含一些索引的SST文件的名称
* NUM_ROWS => 此SST文件中此索引ID的条目数
* DATA_SIZE => 此SST文件中存储的此索引ID的数据大小
* ENTRY_DELETES => 删除标记的数量
* ENTRY_SINGLEDELETES => 单个删除标记的数量 (https://github.com/facebook/rocksdb/wiki/Single-Delete)
* ENTRY_MERGES => 合并操作键的数量
* ENTRY_OTHERS => 不是上述键的键数
* DISTINCT_KEYS_PREFIX => 用于计算索引的基数
information_schema.rocksdb_lock保存有关rocksdb当前持有的行锁的信息。下面的输出显示MyRocks服务器被来自mysqlslap的20个客户端命中。
+------------------+----------------+--------------------------+
| COLUMN_FAMILY_ID | TRANSACTION_ID | KEY |
+------------------+----------------+--------------------------+
| 0 | 428664 | 0000010a0000000000000051 |
| 0 | 428680 | 0000010a0000000000000060 |
| 0 | 428682 | 0000010a0000000000000013 |
| 0 | 428679 | 0000010a000000000000005e |
| 0 | 428674 | 0000010a0000000000000033 |
| 0 | 428675 | 0000010a0000000000000056 |
| 0 | 428673 | 0000010a0000000000000001 |
| 0 | 428662 | 0000010a0000000000000026 |
| 0 | 428668 | 0000010a000000000000003c |
| 0 | 428661 | 0000010a0000000000000039 |
| 0 | 428663 | 0000010a000000000000003b |
+------------------+----------------+--------------------------+
* COLUMN_FAMILY_ID => 锁应用的列族ID。
* TRANSACTION_ID => 持有锁的RocksDB事务的ID。
* KEY => 键值被锁定。
information_schema.rocksdb_trx保存有关未完成事务的信息。下面的输出显示MyRocks服务器被来自mysqlslap的20个客户端命中。
+----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| TRANSACTION_ID | STATE | NAME | WRITE_COUNT | LOCK_COUNT | TIMEOUT_SEC | WAITING_TXN_ID | IS_REPLICATION | SKIP_TRX_API | READ_ONLY | HAS_DEADLOCK_DETECTION | NUM_ONGOING_BULKLOAD | THREAD_ID | QUERY |
+----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 35990 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 33 | UPDATE t1 SET intcol1 = 454571106,intcol2 = 1393317211,intcol3 = 252017441,intcol4 = 586514477,charcol1 = 'fhZnfjGOcxYnvzotO1c8108WQgrY3Zij6FWdzm1Rba6XPmGpnspgkyAAeubhRHGZOn3NP4j1WhOwSgl7PRo9Pq |
| 36008 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 32 | UPDATE t1 SET intcol1 = 2083904078,intcol2 = 1021132792,intcol3 = 1731877697,intcol4 = 88420244,charcol1 = 'fhDPAmcKQDP1EBjHXJlopMeh3WJaMTIuANBLAnhStyT714PZO2LDGrmKMxmcQ4MTKaqMDNq6DK6FGXggPtlil |
| 35988 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 29 | UPDATE t1 SET intcol1 = 489651069,intcol2 = 688718835,intcol3 = 1944307748,intcol4 = 1148327382,charcol1 = 'zllWpWy2lw3iY3wGsBGP4nAe6PRFYRxX4autwknihqODuCTmNm3KP5qXNHevcbRY1DQyxDYewokq05SNjNj1T |
| 35996 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 28 | UPDATE t1 SET intcol1 = 454571106,intcol2 = 1393317211,intcol3 = 252017441,intcol4 = 586514477,charcol1 = 'fhZnfjGOcxYnvzotO1c8108WQgrY3Zij6FWdzm1Rba6XPmGpnspgkyAAeubhRHGZOn3NP4j1WhOwSgl7PRo9Pq |
| 35998 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | UPDATE t1 SET intcol1 = 2083904078,intcol2 = 1021132792,intcol3 = 1731877697,intcol4 = 88420244,charcol1 = 'fhDPAmcKQDP1EBjHXJlopMeh3WJaMTIuANBLAnhStyT714PZO2LDGrmKMxmcQ4MTKaqMDNq6DK6FGXggPtlil |
| 36003 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | UPDATE t1 SET intcol1 = 1216519605,intcol2 = 431597338,intcol3 = 478877569,intcol4 = 706304871,charcol1 = 'a96IMhZWQinEXjsquXru75md77hsxXjYgiiuF7HhiwvDgfvQAmLHk7mr6Rk3qJRMt9H8HQhzMSCu77L9liITh4 |
| 36005 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 23 | UPDATE t1 SET intcol1 = 1226116727,intcol2 = 1452633425,intcol3 = 1212779992,intcol4 = 24489812,charcol1 = 'pjpfEcpBJEN8bDhryzPNoYZRwEgjBOF17xgDZLOkcot3tamka47McghYmL7ydFzc4fpds6MKmFNfhANFENTi3 |
| 36009 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | UPDATE t1 SET intcol1 = 1771697433,intcol2 = 1502025558,intcol3 = 530144513,intcol4 = 472216034,charcol1 = 'XbGi91gPhcakdnvPRHCpXYzYANKbhDq5o6nyzKFgwqOZdJq5SumzQlNc8j4ioundsQRrmiYiOw7u8xrSrdSAM |
| 36000 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | UPDATE t1 SET intcol1 = 1062408960,intcol2 = 920014793,intcol3 = 444232010,intcol4 = 1352821223,charcol1 = 'f6JQyqQtJxce4syBopyPwr36MIvNBleqjx8hnabzN3TKoRXc9TtxCw4bEzqHkKzJH70wZRnoXH8Bcffd1Yb5S |
| 35994 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | UPDATE t1 SET intcol1 = 1290231115,intcol2 = 1812323518,intcol3 = 1098103666,intcol4 = 596397028,charcol1 = 'mlEFfJSAer0otk7zEdOtSDXBYINJ89nmm11QDLSjDKXy5WyB7MwRSResd1Cl3rYhtPzyfJhkg5ilRgoRvkuF |
| 35983 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | UPDATE t1 SET intcol1 = 1400431444,intcol2 = 1779021253,intcol3 = 1805489001,intcol4 = 2065787639,charcol1 = 'Xne6orFPQHkAHId5Mml2xNFFot9l6McW1ESq5b7NsrP2237GhkJe7QloJnPH11n3F7lCisRbcldeocuLK5s |
| 36006 | STARTED | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | UPDATE t1 SET intcol1 = 940475515,intcol2 = 940488537,intcol3 = 453000314,intcol4 = 1334851382,charcol1 = 'AmTMXFym7hgOoJzcyfYPYQRsYGxJDBDNpieCqSzx9XLqiCQYryxFPG7pY40l8E1pwX2mztc0Opqy28WlzJ1Gc8 |
| 35982 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | UPDATE t1 SET intcol1 = 2083904078,intcol2 = 1021132792,intcol3 = 1731877697,intcol4 = 88420244,charcol1 = 'fhDPAmcKQDP1EBjHXJlopMeh3WJaMTIuANBLAnhStyT714PZO2LDGrmKMxmcQ4MTKaqMDNq6DK6FGXggPtlil |
| 35995 | STARTED | | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | UPDATE t1 SET intcol1 = 1290231115,intcol2 = 1812323518,intcol3 = 1098103666,intcol4 = 596397028,charcol1 = 'mlEFfJSAer0otk7zEdOtSDXBYINJ89nmm11QDLSjDKXy5WyB7MwRSResd1Cl3rYhtPzyfJhkg5ilRgoRvkuF |
| 36010 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | UPDATE t1 SET intcol1 = 940475515,intcol2 = 940488537,intcol3 = 453000314,intcol4 = 1334851382,charcol1 = 'AmTMXFym7hgOoJzcyfYPYQRsYGxJDBDNpieCqSzx9XLqiCQYryxFPG7pY40l8E1pwX2mztc0Opqy28WlzJ1Gc8 |
| 36011 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | UPDATE t1 SET intcol1 = 922853379,intcol2 = 2140129284,intcol3 = 1668837037,intcol4 = 1822691713,charcol1 = 'DXvMI4p6lcDtlGDsvD16QYa3fdiItBN7bALl6Bsrn5cOLpG9u97KaiFDJxNC1mBcoPLucDeFAEfOwoZixg3N |
| 36001 | STARTED | | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | UPDATE t1 SET intcol1 = 1516731140,intcol2 = 56808506,intcol3 = 191141678,intcol4 = 1949641710,charcol1 = '1R6QK511IkdItN4lwdNKsIZC3vjFLEmMhkg1phvzPYIAnEobkBwcLLgP9GgWWIlBvP5cz0cGOmRBsFeSIa4gwl |
+----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
* TRANSACTION_ID => RocksDB分配的事务ID。
* STATE => RocksDB事务的状态。其中一个状态
[STARTED，AWAITING_PREPARE，PREPARED，AWAITING_COMMIT，COMMITED，AWAITING_ROLLBACK，ROLLEDBACK]
* NAME => 事务名称，仅用于两阶段提交。
* WRITE_COUNT => 此事务的写入次数。
* LOCK_COUNT => 此事务持有的行锁数。
* TIMEOUT_SEC => 此事务的超时时间（以秒为单位）
* WAITING_TXN_ID => 此事务正在等待的事务的RocksDB ID。
* IS_REPLICATION => 这是一个复制线程。
* SKIP_TRX_API => 这是一个跳过RocksDB的事务/锁定层的复制线程。
* READ_ONLY => 这是一个只读事务。
* HAS_DEADLOCK_DETECTION => 此事务是否尝试检测死锁。
* NUM_ONGOING_BULKLOAD => 此事务正在处理的批量加载数。
* THREAD_ID => 事务的系统线程ID。
* QUERY => 正在执行的SQL查询。