【已解决】OverSizeTablets如何解决

Viewed 75

执行命令
SHOW PROC '/cluster_health/tablet_health/10064';
image.png
建表语句

CREATE TABLE `table_name` (
  `id` int(11) NULL COMMENT '主键id'
) ENGINE=OLAP
UNIQUE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"in_memory" = "false",
"storage_format" = "V2",
"estimate_partition_size" = "10G",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false"
);

sho data from table 结果
image.png

是否应该调整estimate_partition_size大小?

2 Answers

fe.conf 的配置参数。默认2GB
min_bytes_indicate_replica_too_large

默认超过2GB(这个阈值)的tablet,就会记录到里面,主要是为了观察是否有太大的tablet的。如果tablet太大,可能要调整分区分桶数,同时注意是否有数据清倾斜