Increase the value of max_concurrent_queries
As a developer against my Aiven for Clickhouse instance,
I would like to increase the value of maxconcurrentqueries,
to facilitate the query pattern of my existing workload.
4
votes
We have increased the number of concurrent connections, in ratio with the memory available, to retain stability, with 100 concurrent queries for each 16GiB of RAM, with a minimum of 100.
This doesn’t change hobbyist, startup-16, business-16 or premium-Nx-16 but increases the value for the larger node sizes with 32GiB or 64GiB or RAM.