Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13859

Add SHOW ENGINE ROCKSDB TRANSACTION STATUS or its equivalent?

    XMLWordPrintable

Details

    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)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            psergei Sergei Petrunia
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.