Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
FB/MySQL has added this:
mysql> show engine rocksdb transaction status;
|
 |
| SNAPSHOTS | rocksdb |
|
============================================================
|
2017-09-21 14:28:07 ROCKSDB TRANSACTION MONITOR OUTPUT
|
============================================================
|
---------
|
SNAPSHOTS
|
---------
|
LIST OF SNAPSHOTS FOR EACH SESSION:
|
---SNAPSHOT, ACTIVE 56 sec
|
MySQL thread id 1, OS thread handle 0x7fe65c09c700, query id 8 localhost root
|
lock count 6, write count 3
|
insert count 3, update count 0, delete count 0
|
-----------------------------------------
|
END OF ROCKSDB TRANSACTION MONITOR OUTPUT
|
=========================================
|
There is also INFORMATION_SCHEMA.ROCKSDB_TRX which has similar information but
it's not exactly the same:
mysql> select * from ROCKSDB_TRX\G
|
*************************** 1. row ***************************
|
TRANSACTION_ID: 1
|
STATE: STARTED
|
NAME:
|
WRITE_COUNT: 3
|
LOCK_COUNT: 6
|
TIMEOUT_SEC: 1
|
WAITING_KEY:
|
WAITING_COLUMN_FAMILY_ID: 0
|
IS_REPLICATION: 0
|
SKIP_TRX_API: 0
|
READ_ONLY: 0
|
HAS_DEADLOCK_DETECTION: 0
|
NUM_ONGOING_BULKLOAD: 0
|
THREAD_ID: 1
|
QUERY:
|
1 row in set (0.00 sec)
|