Clickhouse eating up all my server's resources

[DeveloperLewis]

Past Issues Searched

• [x] I have searched open and closed issues to make sure that the bug has not yet been reported

Issue is a Bug Report

• [x] This is a bug report and not a feature request, nor asking for self-hosted support

Using official Plausible Cloud hosting or self-hosting?

Plausible Cloud from plausible.io

Describe the bug

Clickhouse is constantly accessing it's config.xml and just breaking. I'm not entirely sure what's happening but there are multiple instances of it and its bringing down my server. If I turn off my plausable docker contianer, it doesn't happen anymore and I get back 50-80% of all my server resources. So I know it's plausable.

Expected behavior

I don't think it should be using THIS much memory/cpu usage.

Screenshots

Environment

- OS: Ubuntu
- Browser:
- Browser Version:

[ruslandoga]

👋 @DeveloperLewis

ClickHouse isn't accessing config.xml, it's just the command that was used to start the process :)

[DeveloperLewis]

👋 @DeveloperLewis

ClickHouse isn't accessing config.xml, it's just the command that was used to start the process :)

I see! I guess this is more of a clickhouse issue then?

[ruslandoga]

Maybe there are more knobs to tune to try to make ClickHouse consume less in Plausible CE. Prev discussion: https://github.com/plausible/community-edition/issues/185

[palockocz]

I have exactly the same problem. CPU is running at 95-100%, RAM is at about 40% - which is fine.

@DeveloperLewis Have you solved it somehow?