This message was deleted.
# troubleshootings
Slackbot
11/08/2022, 8:13 PMThis message was deleted.
g
Gian Merlino
11/09/2022, 5:40 AMat the risk of sounding silly, it improves performance in the situations where your performance is limited by lack of replication 🙂
Gian Merlino
11/09/2022, 5:41 AMin particular, if all your Historical process CPUs are at 100% during a query, then increasing replication won't do anything useful
Gian Merlino
11/09/2022, 5:42 AMbut if they are less than that, it may help, if it means you get to use more Historicals
Gian Merlino
11/09/2022, 5:42 AMclassic case where replication is helpful for query perf is where you have a small number of hotspot segments (certain segments that get more queries than others)
Gian Merlino
11/09/2022, 5:43 AMlike, if you have 5 hotspot segments, with the default replicas of 2, they will replicate to at most 10 servers.
Gian Merlino
11/09/2022, 5:43 AMin this scenario, let's say you have 50 servers. then, increasing replicas can improve perf b/c those hotspot segments can go out to more servers
d
Didip Kerabat
11/09/2022, 5:47 AMi see i see, that makes sense
2 Views