Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5114

Add support for SHOW ENGINE ROCKSDB TRANSACTION STATUS

    XMLWordPrintable

    Details

    • Type: Admin & Maintenance Task
    • Status: Done
    • Priority: High
    • Resolution: Won't Fix
    • Affects Version/s: 5.7.24-26
    • Fix Version/s: None
    • Component/s: MyRocks
    • Labels:
      None

      Description

      It seems MyRocks in recent Percona Server still does NOT support SHOW ENGINE ROCKSDB TRANSACTION STATUS statement available upstream (see https://github.com/facebook/mysql-5.6/wiki/Show-Engine-Status).

      Here is my quick test:

      mysql> select version();
      +-----------+
      | version() |
      +-----------+
      | 5.7.24-26 |
      +-----------+
      1 row in set (0.00 sec)
      
      mysql> show plugins;
      +-------------------------------+----------+--------------------+---------------+---------+
      | Name                          | Status   | Type               | Library       | License |
      +-------------------------------+----------+--------------------+---------------+---------+
      | binlog                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL          | GPL     |
      | sha256_password               | ACTIVE   | AUTHENTICATION     | NULL          | GPL     |
      | PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      ...
      | ROCKSDB                       | ACTIVE   | STORAGE ENGINE     | ha_rocksdb.so | GPL     |
      | ROCKSDB_CFSTATS               | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_DBSTATS               | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_PERF_CONTEXT          | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_PERF_CONTEXT_GLOBAL   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_CF_OPTIONS            | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_GLOBAL_INFO           | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_COMPACTION_STATS      | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_DDL                   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_INDEX_FILE_MAP        | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_LOCKS                 | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_TRX                   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_DEADLOCK              | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      +-------------------------------+----------+--------------------+---------------+---------+
      65 rows in set (0.00 sec)
      
      mysql> show engine rocksdb transaction status\G
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'transaction status' at line 1
      

      Please, add this as information_schema.rocksdb_trx table is not really a replacement for troubleshooting deadlocks post factum.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                openxs2 Valerii
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: