Integrate no log options for Plausible Clikhouse

[LittleBigFrog]

Clickhouse have performance issues on small ram machines, as described here:
plausible/analytics#301
https://theorangeone.net/posts/calming-down-clickhouse/

@RealOrangeOne allows to disable excessive logs:
https://github.com/plausible/hosting/tree/master/clickhouse

is there a way to integrate these settings?

[RealOrangeOne]

coolify/src/routes/services/[id]/plausibleanalytics/start.json.ts

Lines 83 to 106 in 1281a0f

	const clickhouseConfigXml = `
	<yandex>
	<logger>
	<level>warning</level>
	<console>true</console>
	</logger>
	<!-- Stop all the unnecessary logging -->
	<query_thread_log remove="remove"/>
	<query_log remove="remove"/>
	<text_log remove="remove"/>
	<trace_log remove="remove"/>
	<metric_log remove="remove"/>
	<asynchronous_metric_log remove="remove"/>
	</yandex>`;
	const clickhouseUserConfigXml = `
	<yandex>
	<profiles>
	<default>
	<log_queries>0</log_queries>
	<log_query_threads>0</log_query_threads>
	</default>
	</profiles>
	</yandex>`;

[andrasbacsai]

These are integrated. Are you having some problem on small ram machine?

[andrasbacsai]

Due to inactivity, I'm closing this issue. However, if the problem persists, please reopen the issue. Thanks!

[akoenig]

@andrasbacsai I can confirm high spikes in CPU utilization when it comes to the clickhouse server. I checked the /etc/clickhouse-server/config.xml within the container and can confirm that the changes above are not in there.

This is for example the CPU utilization displayed in the Coolify dashboard (the Coolify instance is not hosting anything except Plausible right now):