Clickhouse Server CPU Core Configuration

By default, Click house server uses 8 CPU cores. If CPU cores increase beyond 8 than below line needs to add in the Click house server configuration file in order to make the extra cores in use.

Click House configuration file path: /etc/clickhouse-server/config.xml

Add below line anywhere in the file,

<max_threads>no of cores</max_threads>

For example, if CPU cores are increased to 16 then add like below,

<max_threads>16</max_threads>