I ve tried updating the retention period for traces from 2 d

Question

I ve tried updating the retention period for traces from 2 days to 1 month and it has been trying to apply this change since Friday taking 3 days anything i can do to fix this Seems its been retaining data for more than 2 days now but still says its applying

Pranay · Answer

< Vishal Sharma> any insights here

Alexei Zenin · Answer

Previous discussion about this <https signoz community slack com archives C01HWQ1R0BC p1668716164380199>

Alexei Zenin · Answer

I ended up nuking the clickhouse instance to resize it to a larger EC2 instance type and the SigNoz UI seems to have remembered it was still pending on changing retention to 30 days and I can t seem to set it to 30 Is there some kind of timer where it keeps retrying in the signoz app Can i somehow wipe or reset this without nuking the entire signoz DB

Alexei Zenin · Answer

I ended up nuking the SigNoz services + filesystem on EFS to start fresh Hoping this gets looked at as when this actually gets used in PROD would not want to send an invite link to everyone again

Vishal Sharma · Answer

< Alexei Zenin> TTL is an async operation which is why it s taking so long If you want to make the changes faster then you can manually and then reduce `merge with ttl timeout` to 10mins this has performance impact as TTL will be executed frequently Performance impact of this can be reduced by enabling `ttl only drop parts` Also if your table is not too big you could force it using the `OPTIMIZE TABLE db table FINAL` statement However for large tables it is not recommended

Vishal Sharma · Answer

Command to set `merge with ttl timeout` to 10mins ```SET merge with ttl timeout = 600``` Command to enable `ttl only drop parts` ```SET ttl only drop parts = 1``` If you want to run `OPTIMIZE TABLE db table FINAL` for all the trace tables then run below queries one by one 1 `OPTIMIZE TABLE signoz traces signoz error index v2 FINAL` 2 `OPTIMIZE TABLE signoz traces usage explorer FINAL` 3 `OPTIMIZE TABLE signoz traces dependency graph minutes FINAL` 4 `OPTIMIZE TABLE signoz traces signoz spans FINAL` 5 `OPTIMIZE TABLE signoz traces signoz index v2 FINAL` 6 `OPTIMIZE TABLE signoz traces durationSort FINAL`