Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.7.18-14
    • Component/s: MyRocks
    • Labels:

      Description

      Similar to MYR-70 needs to be re-recorded due to some extra and missing values in INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO and INFORMATION_SCHEMA.ROCKSDB_COMPACTION_STATS

      Also, state of CF_FLAGS and MAX_INDEX_ID in ROCKSDB_GLOBAL_INFO is missing and needs investigating:

      @@ -3,26 +3,22 @@
       DROP TABLE IF EXISTS t3;
       select * from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       TYPE NAME  VALUE
      -MAX_INDEX_ID MAX_INDEX_ID  max_index_id
      -CF_FLAGS 0 default [0]
      -CF_FLAGS 1 __system__ [0]
      +CF_FLAGS 0 default [3288336800]
      +CF_FLAGS 1 __system__ [3288336800]
       select count(*) from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       count(*)
      -3
      +2
       select VALUE into @keysIn from INFORMATION_SCHEMA.ROCKSDB_COMPACTION_STATS where CF_NAME = 'default' and LEVEL = 'Sum' and TYPE = 'KeyIn';
       CREATE TABLE t1 (i1 INT, i2 INT, PRIMARY KEY (i1)) ENGINE = ROCKSDB;
       INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);
       select * from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       TYPE NAME  VALUE
      -BINLOG FILE  master-bin.000001
      -BINLOG POS 1066
      -BINLOG GTID  uuid:5
       MAX_INDEX_ID MAX_INDEX_ID  max_index_id
       CF_FLAGS 0 default [0]
       CF_FLAGS 1 __system__ [0]
       select count(*) from INFORMATION_SCHEMA.ROCKSDB_GLOBAL_INFO;
       count(*)
      -6
      +3
       set global rocksdb_force_flush_memtable_now = true;
       set global rocksdb_compact_cf='default';
       select case when VALUE-@keysIn >= 3 then 'true' else 'false' end from INFORMATION_SCHEMA.ROCKSDB_COMPACTION_STATS where CF_NAME = 'default' and LEVEL = 'Sum' and TYPE = 'KeyIn';
      @@ -69,7 +65,7 @@
       Variable_name  Value
       rocksdb_pause_background_work  ON
       DROP TABLE t3;
      -cf_id:0,index_id:268
      +cf_id:0,index_id:264
       SET GLOBAL ROCKSDB_PAUSE_BACKGROUND_WORK=0;
       SHOW GLOBAL VARIABLES LIKE 'ROCKSDB_PAUSE_BACKGROUND_WORK';
       Variable_name  Value
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                george.lorch George Lorch
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: