Information Schema状态

MyRocks公开了几个有用的信息模式表，它们提供了有关数据库当前状态的更多信息。 下面是每个表的说明以及一些示例用法+输出:

rocksdb_global_info

  1. 有关更多用法示例，请参阅rocksdb.information_schema测试用例:
  3. CREATE TABLE t1 (i1 INT, i2 INT, PRIMARY KEY (i1)) ENGINE = ROCKSDB;
  4. INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);
  5. SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
  7. +--------------+--------------+----------------------------------------+
  8. | TYPE         | NAME         | VALUE                                  |
  9. +--------------+--------------+----------------------------------------+
  10. | BINLOG       | FILE         | master-bin.000001                      |
  11. | BINLOG       | POS          | 571                                    |
  12. | BINLOG       | GTID         | 84ca021b-6a47-11e6-87e3-de7cd2a9d83f:2 |
  13. | MAX_INDEX_ID | MAX_INDEX_ID | 260                                    |
  14. | CF_FLAGS     | 0            | default [0]                            |
  15. | CF_FLAGS     | 1            | __system__ [0]                         |
  16. +--------------+--------------+----------------------------------------+
  18. * Binlog - 显示执行的文件，当前pos位置和最后一个gtid
  19. * DDL_DROP_INDEX_ONGOING - 显示当前正在删除的索引（如果有）
  20. * CF_FLAGS - 显示cf id和name
  21. * MAX_INDEX_ID - 显示当前最大索引ID

rocksdb_ddl

rocksdb_ddl包含有关RocksDB中包含的当前现有 表/索引 的信息:

  1. CREATE TABLE t1 (i1 INT, i2 INT, PRIMARY KEY (i1)) ENGINE = ROCKSDB;
  2. CREATE TABLE t2 (a int, b int, c int, d int, e int,
  3.     PRIMARY KEY (a) COMMENT "cf_a",
  4.     KEY (b) COMMENT "cf_b",
  5.     KEY (c) COMMENT "cf_c",
  6.     KEY (d) COMMENT "$per_index_cf",
  7.     KEY (e) COMMENT "rev:cf_d") ENGINE=ROCKSDB;
  8. );
  10. mysql> select * from information_schema.rocksdb_ddl;
  11. +--------------+----------------------+----------------+------------+---------------+--------------+------------+-------------------+-----------+
  12. | TABLE_SCHEMA | TABLE_NAME           | PARTITION_NAME | INDEX_NAME | COLUMN_FAMILY | INDEX_NUMBER | INDEX_TYPE | KV_FORMAT_VERSION | CF        |
  13. +--------------+----------------------+----------------+------------+---------------+--------------+------------+-------------------+-----------+
  14. | mysql        | slave_gtid_info      | NULL           |            |             0 |          259 |          1 |                11 | default   |
  15. | mysql        | slave_relay_log_info | NULL           | PRIMARY    |             0 |          256 |          1 |                11 | default   |
  16. | mysql        | slave_master_info    | NULL           | PRIMARY    |             0 |          257 |          1 |                11 | default   |
  17. | test         | t2                   | NULL           | PRIMARY    |             2 |          263 |          1 |                11 | cf_a      |
  18. | test         | t2                   | NULL           | b          |             3 |          264 |          2 |                11 | cf_b      |
  19. | test         | t2                   | NULL           | c          |             4 |          265 |          2 |                11 | cf_c      |
  20. | test         | t2                   | NULL           | d          |             5 |          266 |          2 |                11 | test.t2.d |
  21. | test         | t2                   | NULL           | e          |             6 |          267 |          2 |                11 | rev:cf_d  |
  22. | mysql        | slave_worker_info    | NULL           | PRIMARY    |             0 |          258 |          1 |                11 | default   |
  23. | test         | t1                   | NULL           | PRIMARY    |             0 |          260 |          1 |                11 | default   |
  24. | test         | t1                   | NULL           | tindex1    |             0 |          261 |          2 |                11 | default   |
  25. | test         | t1                   | NULL           | tindex2    |             0 |          262 |          2 |                11 | default   |
  26. +--------------+----------------------+----------------+------------+---------------+--------------+------------+-------------------+-----------+
  28. * TABLE_SCHEMA - 数据库schema名称
  29. * TABLE_NAME   - 表名称
  30. * PARTITION_NAME - 分区名称(如果有)
  31. * INDEX_NAME - 索引名称
  32. * COLUMN_FAMILY - 索引所属的列族
  33. * INDEX_NUMBER - 索引号
  34. * INDEX_TYPE - 主键索引、二级索引或隐藏索引(对应1、2、3)
  35. * KV_FORMAT_VERSION - 键和值的版本格式
  36. * CF - 列族对应索引

rocksdb_cfstats

包含有关当前现有列系列的统计信息:

  1. CREATE TABLE t1 (i INT, PRIMARY KEY (i) COMMENT 'cf_t1') ENGINE = ROCKSDB;
  3. mysql> select * from information_schema.rocksdb_cfstats;
  4. +------------+-------------------------------+-------+
  5. | CF_NAME    | STAT_TYPE                     | VALUE |
  6. +------------+-------------------------------+-------+
  7. | __system__ | NUM_IMMUTABLE_MEM_TABLE       |     0 |
  8. | __system__ | MEM_TABLE_FLUSH_PENDING       |     0 |
  9. | __system__ | COMPACTION_PENDING            |     0 |
  10. | __system__ | CUR_SIZE_ACTIVE_MEM_TABLE     |  1160 |
  11. | __system__ | CUR_SIZE_ALL_MEM_TABLES       |  1160 |
  12. | __system__ | NUM_ENTRIES_ACTIVE_MEM_TABLE  |    24 |
  13. | __system__ | NUM_ENTRIES_IMM_MEM_TABLES    |     0 |
  14. | __system__ | NON_BLOCK_CACHE_SST_MEM_USAGE |     0 |
  15. | __system__ | NUM_LIVE_VERSIONS             |     1 |
  16. | cf_t1      | NUM_IMMUTABLE_MEM_TABLE       |     0 |
  17. | cf_t1      | MEM_TABLE_FLUSH_PENDING       |     0 |
  18. | cf_t1      | COMPACTION_PENDING            |     0 |
  19. | cf_t1      | CUR_SIZE_ACTIVE_MEM_TABLE     |   192 |
  20. | cf_t1      | CUR_SIZE_ALL_MEM_TABLES       |   192 |
  21. | cf_t1      | NUM_ENTRIES_ACTIVE_MEM_TABLE  |     0 |
  22. | cf_t1      | NUM_ENTRIES_IMM_MEM_TABLES    |     0 |
  23. | cf_t1      | NON_BLOCK_CACHE_SST_MEM_USAGE |     0 |
  24. | cf_t1      | NUM_LIVE_VERSIONS             |     1 |
  25. | default    | NUM_IMMUTABLE_MEM_TABLE       |     0 |
  26. | default    | MEM_TABLE_FLUSH_PENDING       |     0 |
  27. | default    | COMPACTION_PENDING            |     0 |
  28. | default    | CUR_SIZE_ACTIVE_MEM_TABLE     |   192 |
  29. | default    | CUR_SIZE_ALL_MEM_TABLES       |   192 |
  30. | default    | NUM_ENTRIES_ACTIVE_MEM_TABLE  |     0 |
  31. | default    | NUM_ENTRIES_IMM_MEM_TABLES    |     0 |
  32. | default    | NON_BLOCK_CACHE_SST_MEM_USAGE |     0 |
  33. | default    | NUM_LIVE_VERSIONS             |     1 |
  34. +------------+-------------------------------+-------+

rocksdb_dbstats

提供有关数据库的信息，例如后台错误，当前打开的快照数，当前快照打开的时间以及阻止缓存使用情况:

  1. mysql> SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_DBSTATS;
  2. +-------------------------+-------+
  3. | STAT_TYPE               | VALUE |
  4. +-------------------------+-------+
  5. | DB_BACKGROUND_ERRORS    |     0 |
  6. | DB_NUM_SNAPSHOTS        |     0 |
  7. | DB_OLDEST_SNAPSHOT_TIME |     0 |
  8. | DB_BLOCK_CACHE_USAGE    |   295 |
  9. +-------------------------+-------+

rocksdb_perf_context

包含RocksDB的性能统计信息。可以通过rocksdb_perf_context_level变量启用这些计数器。

  1. 有关更多用法示例，请参阅rocksdb.perf_context测试用例。
  3. CREATE TABLE t1 (i INT, j INT, PRIMARY KEY (i)) ENGINE = ROCKSDB;
  4. CREATE TABLE t2 (k INT, PRIMARY KEY (k)) ENGINE = ROCKSDB;
  6. INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
  8. mysql> SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT WHERE TABLE_NAME = 't1';
  9. +--------------+------------+----------------+---------------------------------+-------+
  10. | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | STAT_TYPE                       | VALUE |
  11. +--------------+------------+----------------+---------------------------------+-------+
  12. | test         | t1         | NULL           | USER_KEY_COMPARISON_COUNT       |    15 |
  13. | test         | t1         | NULL           | BLOCK_CACHE_HIT_COUNT           |     0 |
  14. | test         | t1         | NULL           | BLOCK_READ_COUNT                |     0 |
  15. | test         | t1         | NULL           | BLOCK_READ_BYTE                 |     0 |
  16. | test         | t1         | NULL           | BLOCK_READ_TIME                 |     0 |
  17. | test         | t1         | NULL           | BLOCK_CHECKSUM_TIME             |     0 |
  18. | test         | t1         | NULL           | BLOCK_DECOMPRESS_TIME           |     0 |
  19. | test         | t1         | NULL           | INTERNAL_KEY_SKIPPED_COUNT      |     0 |
  20. | test         | t1         | NULL           | INTERNAL_DELETE_SKIPPED_COUNT   |     0 |
  21. | test         | t1         | NULL           | GET_SNAPSHOT_TIME               |  3010 |
  22. | test         | t1         | NULL           | GET_FROM_MEMTABLE_TIME          |     0 |
  23. | test         | t1         | NULL           | GET_FROM_MEMTABLE_COUNT         |     0 |
  24. | test         | t1         | NULL           | GET_POST_PROCESS_TIME           |  3029 |
  25. | test         | t1         | NULL           | GET_FROM_OUTPUT_FILES_TIME      |  5670 |
  26. | test         | t1         | NULL           | SEEK_ON_MEMTABLE_TIME           |     0 |
  27. | test         | t1         | NULL           | SEEK_ON_MEMTABLE_COUNT          |     0 |
  28. | test         | t1         | NULL           | SEEK_CHILD_SEEK_TIME            |     0 |
  29. | test         | t1         | NULL           | SEEK_CHILD_SEEK_COUNT           |     0 |
  30. | test         | t1         | NULL           | SEEK_IN_HEAP_TIME               |     0 |
  31. | test         | t1         | NULL           | SEEK_INTERNAL_SEEK_TIME         |     0 |
  32. | test         | t1         | NULL           | FIND_NEXT_USER_ENTRY_TIME       |     0 |
  33. | test         | t1         | NULL           | WRITE_WAL_TIME                  | 32111 |
  34. | test         | t1         | NULL           | WRITE_MEMTABLE_TIME             | 16537 |
  35. | test         | t1         | NULL           | WRITE_DELAY_TIME                |     0 |
  36. | test         | t1         | NULL           | WRITE_PRE_AND_POST_PROCESS_TIME | 13775 |
  37. | test         | t1         | NULL           | DB_MUTEX_LOCK_NANOS             |     0 |
  38. | test         | t1         | NULL           | DB_CONDITION_WAIT_NANOS         |     0 |
  39. | test         | t1         | NULL           | MERGE_OPERATOR_TIME_NANOS       |     0 |
  40. | test         | t1         | NULL           | READ_INDEX_BLOCK_NANOS          |     0 |
  41. | test         | t1         | NULL           | READ_FILTER_BLOCK_NANOS         |     0 |
  42. | test         | t1         | NULL           | NEW_TABLE_BLOCK_ITER_NANOS      |     0 |
  43. | test         | t1         | NULL           | NEW_TABLE_ITERATOR_NANOS        |     0 |
  44. | test         | t1         | NULL           | BLOCK_SEEK_NANOS                |     0 |
  45. | test         | t1         | NULL           | FIND_TABLE_NANOS                |     0 |
  46. | test         | t1         | NULL           | IO_THREAD_POOL_ID               |     2 |
  47. | test         | t1         | NULL           | IO_BYTES_WRITTEN                |   173 |
  48. | test         | t1         | NULL           | IO_BYTES_READ                   |     0 |
  49. | test         | t1         | NULL           | IO_OPEN_NANOS                   |     0 |
  50. | test         | t1         | NULL           | IO_ALLOCATE_NANOS               |     0 |
  51. | test         | t1         | NULL           | IO_WRITE_NANOS                  | 23209 |
  52. | test         | t1         | NULL           | IO_READ_NANOS                   |     0 |
  53. | test         | t1         | NULL           | IO_RANGE_SYNC_NANOS             |     0 |
  54. | test         | t1         | NULL           | IO_LOGGER_NANOS                 |     0 |
  55. +--------------+------------+----------------+---------------------------------+-------+
  57. mysql> SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_PERF_CONTEXT_GLOBAL;
  58. +---------------------------------+-------+
  59. | STAT_TYPE                       | VALUE |
  60. +---------------------------------+-------+
  61. | USER_KEY_COMPARISON_COUNT       |    15 |
  62. | BLOCK_CACHE_HIT_COUNT           |     0 |
  63. | BLOCK_READ_COUNT                |     0 |
  64. | BLOCK_READ_BYTE                 |     0 |
  65. | BLOCK_READ_TIME                 |     0 |
  66. | BLOCK_CHECKSUM_TIME             |     0 |
  67. | BLOCK_DECOMPRESS_TIME           |     0 |
  68. | INTERNAL_KEY_SKIPPED_COUNT      |     0 |
  69. | INTERNAL_DELETE_SKIPPED_COUNT   |     0 |
  70. | GET_SNAPSHOT_TIME               |  3010 |
  71. | GET_FROM_MEMTABLE_TIME          |     0 |
  72. | GET_FROM_MEMTABLE_COUNT         |     0 |
  73. | GET_POST_PROCESS_TIME           |  3029 |
  74. | GET_FROM_OUTPUT_FILES_TIME      |  5670 |
  75. | SEEK_ON_MEMTABLE_TIME           |     0 |
  76. | SEEK_ON_MEMTABLE_COUNT          |     0 |
  77. | SEEK_CHILD_SEEK_TIME            |     0 |
  78. | SEEK_CHILD_SEEK_COUNT           |     0 |
  79. | SEEK_IN_HEAP_TIME               |     0 |
  80. | SEEK_INTERNAL_SEEK_TIME         |     0 |
  81. | FIND_NEXT_USER_ENTRY_TIME       |     0 |
  82. | WRITE_WAL_TIME                  | 32111 |
  83. | WRITE_MEMTABLE_TIME             | 16537 |
  84. | WRITE_DELAY_TIME                |     0 |
  85. | WRITE_PRE_AND_POST_PROCESS_TIME | 13775 |
  86. | DB_MUTEX_LOCK_NANOS             |     0 |
  87. | DB_CONDITION_WAIT_NANOS         |     0 |
  88. | MERGE_OPERATOR_TIME_NANOS       |     0 |
  89. | READ_INDEX_BLOCK_NANOS          |     0 |
  90. | READ_FILTER_BLOCK_NANOS         |     0 |
  91. | NEW_TABLE_BLOCK_ITER_NANOS      |     0 |
  92. | NEW_TABLE_ITERATOR_NANOS        |     0 |
  93. | BLOCK_SEEK_NANOS                |     0 |
  94. | FIND_TABLE_NANOS                |     0 |
  95. | IO_THREAD_POOL_ID               |     2 |
  96. | IO_BYTES_WRITTEN                |   173 |
  97. | IO_BYTES_READ                   |     0 |
  98. | IO_OPEN_NANOS                   |     0 |
  99. | IO_ALLOCATE_NANOS               |     0 |
  100. | IO_WRITE_NANOS                  | 23209 |
  101. | IO_READ_NANOS                   |     0 |
  102. | IO_RANGE_SYNC_NANOS             |     0 |
  103. | IO_LOGGER_NANOS                 |     0 |
  104. +---------------------------------+-------+

INTERNAL_KEY_SKIPPED_COUNT ==> 跟踪迭代器遍历索引需要​​跳过的键数。正常范围扫描可能导致此计数器增加。 但是，如果点查找导致此增加或者如果跳过的键数明显高于查询返回的行数，则LSM可能存在太多陈旧键。 INTERNAL_DELETE_SKIPPED_COUNT ==> 跟踪迭代器扫描期间需要跳过的删除键的数量。

rocksdb_cf_options

有关为每个列族设置的选项的信息: 有关可用选项的完整列表，请参阅https://github.com/facebook/rocksdb/blob/master/examples/rocksdb_option_file_example.ini

  1. create table t1 (a int, primary key (a) comment 'cf1') engine=rocksdb;
  2. create table t2 (a int, primary key (a) comment 'cf2') engine=rocksdb;
  4. select cf_name, option_type, value
  5. from information_schema.rocksdb_cf_options
  6. where option_type in ('WRITE_BUFFER_SIZE',
  7.                         'TARGET_FILE_SIZE_BASE',
  8.                         'MAX_BYTES_FOR_LEVEL_MULTIPLIER')
  9. order by cf_name, option_type;
  11. +------------+--------------------------------+----------+
  12. | cf_name    | option_type                    | value    |
  13. +------------+--------------------------------+----------+
  14. | cf1        | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10       |
  15. | cf1        | TARGET_FILE_SIZE_BASE          | 67108864 |
  16. | cf1        | WRITE_BUFFER_SIZE              | 4194304  |
  17. | cf2        | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10       |
  18. | cf2        | TARGET_FILE_SIZE_BASE          | 67108864 |
  19. | cf2        | WRITE_BUFFER_SIZE              | 4194304  |
  20. | default    | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10       |
  21. | default    | TARGET_FILE_SIZE_BASE          | 67108864 |
  22. | default    | WRITE_BUFFER_SIZE              | 4194304  |
  23. | __system__ | MAX_BYTES_FOR_LEVEL_MULTIPLIER | 10       |
  24. | __system__ | TARGET_FILE_SIZE_BASE          | 67108864 |
  25. | __system__ | WRITE_BUFFER_SIZE              | 4194304  |
  26. +------------+--------------------------------+----------+

rocksdb_index_file_map

有关更多用法示例，请参阅rocksdb.index_file_map测试用例。

  1. CREATE TABLE t1 (i INT PRIMARY KEY, j INT, INDEX(j)) ENGINE = ROCKSDB;
  2. INSERT INTO t1 VALUES (1,2), (2,4), (3,6), (4,8), (5,10);
  3. SET GLOBAL rocksdb_force_flush_memtable_now = 1;
  5. SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP
  6. WHERE INDEX_NUMBER =
  7.     (SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.ROCKSDB_DDL
  8.      WHERE TABLE_NAME = 't1' AND INDEX_NAME = "PRIMARY");
  9. +---------------+--------------+------------+----------+-----------+---------------+---------------------+--------------+--------------+----------------------+
  10. | COLUMN_FAMILY | INDEX_NUMBER | SST_NAME   | NUM_ROWS | DATA_SIZE | ENTRY_DELETES | ENTRY_SINGLEDELETES | ENTRY_MERGES | ENTRY_OTHERS | DISTINCT_KEYS_PREFIX |
  11. +---------------+--------------+------------+----------+-----------+---------------+---------------------+--------------+--------------+----------------------+
  12. |             0 |          261 | 000026.sst |        5 |        65 |             0 |                   0 |            0 |            0 | 10                   |
  13. +---------------+--------------+------------+----------+-----------+---------------+---------------------+--------------+--------------+----------------------+
  16. * COLUMN_FAMILY => SST文件中包含的索引列系列
  17. * INDEX_NUMBER => SST文件中包含的索引ID
  18. * SST_NAME => 包含一些索引的SST文件的名称
  19. * NUM_ROWS => 此SST文件中此索引ID的条目数
  20. * DATA_SIZE => 此SST文件中存储的此索引ID的数据大小
  21. * ENTRY_DELETES => 删除标记的数量
  22. * ENTRY_SINGLEDELETES => 单个删除标记的数量 (https://github.com/facebook/rocksdb/wiki/Single-Delete)
  23. * ENTRY_MERGES => 合并操作键的数量
  24. * ENTRY_OTHERS => 不是上述键的键数
  25. * DISTINCT_KEYS_PREFIX => 用于计算索引的基数

rocksdb_lock

  1. information_schema.rocksdb_lock保存有关rocksdb当前持有的行锁的信息。下面的输出显示MyRocks服务器被来自mysqlslap的20个客户端命中。
  3. +------------------+----------------+--------------------------+
  4. | COLUMN_FAMILY_ID | TRANSACTION_ID | KEY                      |
  5. +------------------+----------------+--------------------------+
  6. |                0 |         428664 | 0000010a0000000000000051 |
  7. |                0 |         428680 | 0000010a0000000000000060 |
  8. |                0 |         428682 | 0000010a0000000000000013 |
  9. |                0 |         428679 | 0000010a000000000000005e |
  10. |                0 |         428674 | 0000010a0000000000000033 |
  11. |                0 |         428675 | 0000010a0000000000000056 |
  12. |                0 |         428673 | 0000010a0000000000000001 |
  13. |                0 |         428662 | 0000010a0000000000000026 |
  14. |                0 |         428668 | 0000010a000000000000003c |
  15. |                0 |         428661 | 0000010a0000000000000039 |
  16. |                0 |         428663 | 0000010a000000000000003b |
  17. +------------------+----------------+--------------------------+
  19. * COLUMN_FAMILY_ID => 锁应用的列族ID。 
  20. * TRANSACTION_ID => 持有锁的RocksDB事务的ID。
  21. * KEY => 键值被锁定。

rocksdb_trx

information_schema.rocksdb_trx保存有关未完成事务的信息。下面的输出显示MyRocks服务器被来自mysqlslap的20个客户端命中。

  1. +----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  2. | 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                                                                                                                                                                                             |
  3. +----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  4. |          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 |
  5. |          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 |
  6. |          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 |
  7. |          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 |
  8. |          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 |
  9. |          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 |
  10. |          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 |
  11. |          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 |
  12. |          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 |
  13. |          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 |
  14. |          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 |
  15. |          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 |
  16. |          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 |
  17. |          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 |
  18. |          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 |
  19. |          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 |
  20. |          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 |
  21. +----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  23. * TRANSACTION_ID => RocksDB分配的事务ID。
  24. * STATE => RocksDB事务的状态。其中一个状态
  25.            [STARTED，AWAITING_PREPARE，PREPARED，AWAITING_COMMIT，COMMITED，AWAITING_ROLLBACK，ROLLEDBACK]
  26. * NAME => 事务名称，仅用于两阶段提交。
  27. * WRITE_COUNT => 此事务的写入次数。
  28. * LOCK_COUNT => 此事务持有的行锁数。
  29. * TIMEOUT_SEC => 此事务的超时时间（以秒为单位）
  30. * WAITING_TXN_ID => 此事务正在等待的事务的RocksDB ID。
  31. * IS_REPLICATION => 这是一个复制线程。
  32. * SKIP_TRX_API => 这是一个跳过RocksDB的事务/锁定层的复制线程。
  33. * READ_ONLY => 这是一个只读事务。
  34. * HAS_DEADLOCK_DETECTION => 此事务是否尝试检测死锁。
  35. * NUM_ONGOING_BULKLOAD => 此事务正在处理的批量加载数。
  36. * THREAD_ID => 事务的系统线程ID。
  37. * QUERY => 正在执行的SQL查询。