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

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: Not 5.6.x, Not 5.7.x, 8.0.21-12
    • Fix Version/s: 8.0.NEXT
    • Component/s: Documentation, MyRocks
    • Labels:
      None
    • Needs Review:
      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

            Assignee:
            Unassigned
            Reporter:
            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