GitHub user DaanHoogland added a comment to the discussion: [MySQL] Pruning / Off-loading Database
> * Its daily processing already takes about 8 hours (roughly 8 PM to 4 AM). > * This suggests it may be processing all historical data each time, rather > than just the incremental changes since the last run. > > * I may be mistaken, but it’s hard to believe our daily data volume alone > would justify this duration. In my experience this indicates some error is encountered during processing and the batch is not marked complete. Next day the processing would start at the same timestamp again, thus incrementally growing each day. Please check that. As for usage pruning, take care only to remove events/intemediate data for resources for which the lifecycle is complete! Usage relies on its own output and hence needs prior data to be able to determine part of the usage. Please check the usage log for errors before proceeding. GitHub link: https://github.com/apache/cloudstack/discussions/12159#discussioncomment-16378482 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
