Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-2636

[compaction] Compaction affects query performance

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Cannot Reproduce
    • 0.13.0-SNAPSHOT
    • None
    • Core/Compaction
    • None
    • 2022-3-Dragon

    Description

      master-pre3
      测试环境:
      私有云8C32G,16Gheap,无乱序,长测配置。
      1. master 关合并/开合并对比
      cwt代表参数 merge_write_throughput_mb_per_sec
      master开合并会导致查询性能下降约20%。

      2. master-pre3和0.12.5-pre6开合并对比
      merge_write_throughput_mb_per_sec均为8
      master总体比0.12慢70%

      这个查询对应的写入性能(作为查询基于的数据量的参照),master查询的数据不大于0.12.5:

      Attachments

        1. 0.13-disable-compaction-query.png
          14 kB
          Liuxuxin
        2. 0.12-disable-compaction-query.png
          14 kB
          Liuxuxin
        3. 0.13-write.png
          76 kB
          Liuxuxin
        4. 0.13_group_by.png
          82 kB
          Liuxuxin
        5. 0.12_write.png
          84 kB
          Liuxuxin
        6. 0.12_group_by-1.png
          84 kB
          Liuxuxin
        7. 0.12_group_by.png
          84 kB
          Liuxuxin
        8. image-2022-03-10-10-33-26-233.png
          1.57 MB
          Liuxuxin
        9. load-file.log
          1.10 MB
          Liuxuxin
        10. image-2022-03-01-14-44-37-559.png
          15 kB
          刘珍
        11. image-2022-03-01-14-37-30-548.png
          13 kB
          刘珍
        12. image-2022-03-01-14-30-59-082.png
          23 kB
          刘珍

        Activity

          People

            ThuLiuxuxin Liuxuxin
            刘珍 刘珍
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: