Doris 4.0.5 查询冷数据超级慢,查磁盘数据是1s左右,查询s3是10倍不止

Viewed 12
  1. PROPERTIES (
    "file_cache_ttl_seconds" = "172800",
    "bloom_filter_columns" = "device_sn",
    "is_being_synced" = "false",
    "partition.retention_count" = "3650",
    "storage_medium" = "hdd",
    "storage_format" = "V2",
    "inverted_index_storage_format" = "V3",
    "compression" = "LZ4F",
    "enable_unique_key_merge_on_write" = "true",
    "enable_unique_key_skip_bitmap_column" = "true",
    "light_schema_change" = "true",
    "storage_vault_id" = "1",
    "storage_vault_name" = "prod_s3_vault",
    "disable_auto_compaction" = "false",
    "enable_single_replica_compaction" = "false",
    "group_commit_interval_ms" = "10000",
    "group_commit_data_bytes" = "134217728",
    "enable_mow_light_delete" = "false"
    );
    Unique 表,按主键和分区建查询

  2. 把profile 给AI分析:
    image.png

0 Answers