diff options
| author | alex <alex@pdp7.net> | 2024-05-25 11:36:38 +0200 |
|---|---|---|
| committer | alex <alex@pdp7.net> | 2024-05-25 11:36:38 +0200 |
| commit | b4a292901d152256591d814de18136b14ce4e3b6 (patch) | |
| tree | 33919a34f271d33e90a45c4991fd8e6666ed6438 /personal_infra/puppet | |
| parent | f58fc841399ce486e5919863f021e83b6471e113 (diff) | |
Try to control ClickHouse log table size
Diffstat (limited to 'personal_infra/puppet')
| -rw-r--r-- | personal_infra/puppet/modules/clickhouse/manifests/init.pp | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/personal_infra/puppet/modules/clickhouse/manifests/init.pp b/personal_infra/puppet/modules/clickhouse/manifests/init.pp index 37c6bb6f..60ab3877 100644 --- a/personal_infra/puppet/modules/clickhouse/manifests/init.pp +++ b/personal_infra/puppet/modules/clickhouse/manifests/init.pp @@ -22,7 +22,7 @@ class clickhouse { -> package {['clickhouse-server', 'clickhouse-client', 'clickhouse-keeper']:} -> - [File['/etc/clickhouse-server/config.d/network.xml']] + [File['/etc/clickhouse-server/config.d/network.xml'], File['/etc/clickhouse-server/config.d/logs.xml']] ~> service {['clickhouse-server', 'clickhouse-keeper']: ensure => running, @@ -37,4 +37,21 @@ class clickhouse { | EOT , } + + file {'/etc/clickhouse-server/config.d/logs.xml': + content => @(EOT) + <clickhouse> + <asynchronous_metric_log> + <ttl>event_date + INTERVAL 3 DAY DELETE</ttl> + </asynchronous_metric_log> + <trace_log> + <ttl>event_date + INTERVAL 3 DAY DELETE</ttl> + </trace_log> + <metric_log> + <ttl>event_date + INTERVAL 3 DAY DELETE</ttl> + </metric_log> + </clickhouse> + | EOT + , + } } |