-
Notifications
You must be signed in to change notification settings - Fork 712
MyRocks Information Schema
Reid Horuff edited this page Apr 7, 2017
·
2 revisions
MyRocks exposes several helpful information schema tables that provide more information about the current state of the database. Below is a description for each of the tables as well as some example usage + output.
See rocksdb.information_schema test case for more usage examples.
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 - shows file, current position, and last gtid executed
- DDL_DROP_INDEX_ONGOING - Shows index currently being dropped, if any
- CF_FLAGS - Shows cf id and name
- MAX_INDEX_ID - Shows current max index id
Rocksdb_ddl contains information about the currently existing tables/indexes contained in 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 - database for index entry
- TABLE_NAME - table for index entry
- PARTITION_NAME - partition name, if any
- INDEX_NAME - index name
- COLUMN_FAMILY - column family the index belongs to
- INDEX_NUMBER - index number
- INDEX_TYPE - primary, secondary, or hidden index (corresponds to 1,2,3)
- KV_FORMAT_VERSION - format version of the key and value
- CF - column family corresponding to index
Contains statistics about currently existing column families.
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 |
+------------+-------------------------------+-------+
Provides information about the database such as background errors, number of snapshots currently open, how long the current snapshot has been open, and block cache usage.
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 |
+-------------------------+-------+
Contains performance statistics for RocksDB. These counters can be enabled through the rocksdb_perf_context_level variable.
See rocksdb.perf_context test case for more usage examples.
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** => tracks the number of keys which needed to be skipped over by an iterator walking an index. Normal range scans can cause this counter to increase. However, if point lookups are causing this to increase or if the number of keys skipped is significantly higher than the number of rows returned by a query, then there may be too many stale keys with the LSM.
- INTERNAL_DELETE_SKIPPED_COUNT => tracks the number of delete keys which needed to be skipped over during an iterator scan.
Information about the options set for each column family.
See https://github.com/facebook/rocksdb/blob/master/examples/rocksdb_option_file_example.ini for a full list of available options.
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 |
+------------+--------------------------------+----------+
See rocksdb.index_file_map test case for more usage examples.
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 => the index's column family contained in the SST file
- INDEX_NUMBER => the index id contained in the SST file
- SST_NAME => the name of the SST file containing some indexes
- NUM_ROWS => the number of entries of this index id in this SST file
- DATA_SIZE => the data size stored in this SST file for this index id
- ENTRY_DELETES => the number of delete markers
- ENTRY_SINGLEDELETES => the number of single delete markers
- ENTRY_MERGES => the number of merge operator keys
- ENTRY_OTHERS => number of keys that are not the above
- DISTINCT_KEYS_PREFIX => used for calculating cardinality of an index
information_schema.rocksdb_lockholds information about row locks currently being held by rocksdb. The output below shows a MyRocks server being hit with 20 clients from mysqlslap.
+------------------+----------------+--------------------------+
| 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 => the column family id to which the lock applies.
- TRANSACTION_ID => the id of the Rocksdb transaction holding the lock.
- KEY => the key value being locked.
information_schema.rocksdb_trxholds information about outstanding transactions. The output below shows a MyRocks server being hit with 20 clients from mysqlslap.
+----------------+---------+------+-------------+------------+-------------+----------------+----------------+--------------+-----------+------------------------+----------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 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 => the RocksDB assigned transaction id.
- STATE => The state of the RocksDB transaction. One of [STARTED, AWAITING_PREPARE, PREPARED, AWAITING_COMMIT, COMMITED, AWAITING_ROLLBACK, ROLLEDBACK]
- NAME => The name of the transaction. Only used in two-phase commit.
- WRITE_COUNT => How many writes this transaction is making.
- LOCK_COUNT => The number of row locks this transaction is holding.
- TIMEOUT_SEC => The timeout period, in seconds, for this transaction.
- WAITING_TXN_ID => The RocksDB ID of the transaction this transaction is waiting on.
- IS_REPLICATION => Is this a replication thread.
- SKIP_TRX_API => Is this a replication thread which skips RocksDB's transaction/locking layer.
- READ_ONLY => Is a read-only transaction.
- HAS_DEADLOCK_DETECTION => Does this transaction attempt to detect deadlocks.
- NUM_ONGOING_BULKLOAD => Number of bulkloads this transaction is processing.
- THREAD_ID => The system thread id for the transaction.
- QUERY => The SQL query being executed.
Documentation license here.
Installation
MyRocks
- Overview
- Transaction
- Backup
- Performance Tuning
- Monitoring
- Migration
- Internals
- Vector Database
DocStore
- Document column type
- Document Path: a new way to query JSON data
- Built-in Functions for JSON documents
MySQL/InnoDB Enhancements