Alexei Zenin
12/12/2022, 3:08 PMPranay
Alexei Zenin
12/12/2022, 4:23 PMVishal Sharma
12/13/2022, 2:49 AMmerge_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.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