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

Document MyRocks Information Schema Tables ROCKSDB_ACTIVE_COMPACTION_STATS and ROCKSDB_COMPACTION_HISTORY

Details

    • New Feature
    • Status: Done
    • Medium
    • Resolution: Fixed
    • Not 5.6.x, Not 5.7.x, 8.0.21-12
    • 8.0.23-14 (Q1 2021)
    • Documentation, MyRocks
    • None
    • Yes

    Description

      https://github.com/percona/percona-server/pull/4136

      Add new MyRocks Information Schema Tables `ROCKSDB_ACTIVE_COMPACTION_STATS` and `ROCKSDB_COMPACTION_HISTORY` to https://www.percona.com/doc/percona-server/LATEST/myrocks/information-schema-tables.html

      CREATE TABLE `ROCKSDB_ACTIVE_COMPACTION_STATS` (
        `THREAD_ID` bigint NOT NULL DEFAULT '0',
        `CF_NAME` varchar(513) NOT NULL DEFAULT '',
        `INPUT_FILES` varchar(513) NOT NULL DEFAULT '',
        `OUTPUT_FILES` varchar(513) NOT NULL DEFAULT '',
        `COMPACTION_REASON` varchar(513) NOT NULL DEFAULT ''
      ) ENGINE=MEMORY DEFAULT CHARSET=utf8
      
      CREATE TEMPORARY TABLE `ROCKSDB_COMPACTION_HISTORY` (
        `THREAD_ID` bigint NOT NULL DEFAULT '0',
        `CF_NAME` varchar(513) NOT NULL DEFAULT '',
        `INPUT_LEVEL` int NOT NULL DEFAULT '0',
        `OUTPUT_LEVEL` int NOT NULL DEFAULT '0',
        `INPUT_FILES` varchar(513) NOT NULL DEFAULT '',
        `OUTPUT_FILES` varchar(513) NOT NULL DEFAULT '',
        `COMPACTION_REASON` varchar(513) NOT NULL DEFAULT '',
        `START_TIMESTAMP` bigint NOT NULL DEFAULT '0',
        `END_TIMESTAMP` bigint NOT NULL DEFAULT '0'
      ) ENGINE=MEMORY DEFAULT CHARSET=utf8
      
      

      Attachments

        Activity

          People

            patrick.birch Patrick Birch
            przemyslaw.skibinski Przemyslaw Skibinski
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1 hour
                1h

                Smart Checklist