search

go-graphite / carbon-clickhouse

Graphite metrics receiver with ClickHouse as storage
MIT License
186 stars 48 forks source link

Quick Question above Clickhouse Storage Growth #12

Closed beegmon closed 6 years ago

beegmon commented 6 years ago

Hello,

I recently deployed this and its working great. I am so glad to be moving away from worrying about whisper files exploding!!!

However, I have a quick question.

Since clickhouse doesn't support something like a TTL (at least yet). How is space growth in the DB managed over time. Is this handled by the defined Rollup?

lomik commented 6 years ago

Rollup rules can't remove old data. You should delete them manually using ALTER TABLE DROP PARTITION

beegmon commented 6 years ago

Yeah I did more reading last night and refreshed my memory on how clickhouse works, and came to the same conclusion. Sorry for the noise, should have dug around more before asking.

Thanks for getting back to me though!