[MDEV-13859] Add SHOW ENGINE ROCKSDB TRANSACTION STATUS or its equivalent? Created: 2017-09-21  Updated: 2017-09-21

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sergei Petrunia Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: 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)



 Comments   
Comment by Sergei Petrunia [ 2017-09-21 ]

I've discussed this with various ppl before. Summary

  • There is a pushback to changing the SQL grammar just for one storage engine
  • Why don't we add an I_S table instead?
Comment by Sergei Petrunia [ 2017-09-21 ]

Checked the current Percona Server. They don't seem to have either SHOW ENGINE TRANSACTION STATUS or any equivalent

Comment by Elena Stepanova [ 2017-09-21 ]

Or, maybe just add this output to SHOW ENGINE ROCKSDB STATUS? InnoDB shows all kinds of things in SHOW ENGINE STATUS, transactions included.

Generated at Thu Feb 08 08:08:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.