plausible
Bump clickhouse server version
Fixes excessively high CPU and RAM usage on idling instance
All the following graphs are stacked CPU time / container, and the largest area is the clickhouse server. Spikes are not relevant except for the fact they indicate a restart of the plausible and clickhouse containers.
Upgrading from the latest compose file from the analytics repo caused the following increase in CPU usage from clickhouse
Upgrading clickhouse to the latest version brought it back to a much lower level
Notice how the CPU usage was steadily increasing after I upgraded (even across restarts of the docker container)
After a longer test, the CPU and RAM load are still significantly higher than they were before the update.
Seems like restoring changes that were introduced in https://github.com/plausible/community-edition/pull/13 helps as well, but still nowhere clause the <1% CPU usage it was at before the update
Even though it is much less noticeable, the plausible container itself has doubled its CPU usage since the update.
~~Checking clickhouse's debug log shows that plausible is frequently performing queries in the background, even when there are no visitors to any of my websites~~
I let it run for a while, and I confirm the tweaks from #13 helped decrease the CPU usage further
For reference, here's a graph showing the last 12 hours of CPU use, with numbers before updating, and after updating + applying the tweaks in this pull request