设置Analyze最大流量
SET global "stats.service.max_bytes_per_sec"='10m'
log filter
SET GLOBAL "stats.jobs_log_filter" = 'ended - started > 100';
ALTER TABLE .. REROUTE PROMOTE REPLICA
Routing失败重试
ALTER CLUSTER REROUTE RETRY FAILED
设置 recovery并行数量
SET GLOBAL "cluster.routing.allocation.node_concurrent_recoveries" = '100';
设置recovery写入量
SET GLOBAL "indices.recovery.max_bytes_per_sec" = '50mb';
设置并行rebalance个分片个数
cluster.routing.allocation.cluster_concurrent_rebalance
Default: 2
Runtime: yes
Defines how many concurrent rebalancing tasks are allowed across all nodes
设置一个节点主分片并行恢复数量
cluster.routing.allocation.node_initial_primaries_recoveries
Default: 4
Runtime: yes
Defines how many concurrent primary shard recoveries are allowed on a node.
Since primary recoveries use data that is already on disk (as opposed to inter-node recoveries), recovery should be fast and so this setting can be higher than
并行数
cluster.routing.allocation.node_concurrent_recoveries
Default: 2
Runtime: yes
Defines how many concurrent recoveries are allowed on a node.
decrease shards
alter table test.test_dt set ("routing.allocation.require._name"="10.10.3.19");
alter table test.test_dt set ("blocks.write"=true);
alter table test.test_dt set (number_of_shards = 21);
alter table test.test_dt set ("blocks.write" = false);
建表设置路由分片
CLUSTERED INTO 12 SHARDS WITH ( "number_of_routing_shards" = 48 )
切换表名
SWAP TABLE source TO target [ WITH ( expr = expr [ , ... ] ) ]
切表名
alter table user_voice.da_vocust_hotel_voice rename to da_vocust_hotel_voice_bk;
alter table user_voice.da_vocust_hotel_voice_tmp rename to da_vocust_hotel_voice;
Query Breaker
SET GLOBAL "indices.breaker.query.limit" = '3.0gb';
