You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@rocketmq.apache.org by "Aias00 (via GitHub)" <gi...@apache.org> on 2026/08/28 12:20:22 UTC
[I] [Studio][Performance] Bound scheduled query-history and audit cleanup deletes [rocketmq-dashboard]
Aias00 opened a new issue, #2683:
URL: https://github.com/apache/rocketmq-dashboard/issues/2683
## Problem
Scheduled query-history cleanup and audit cleanup delete every expired row in one statement. On large installations this can create long transactions, substantial undo/redo work and lock contention.
## Evidence
- `server/src/main/java/org/apache/rocketmq/studio/instance/message/QueryHistoryService.java:180`
- `server/src/main/java/org/apache/rocketmq/studio/instance/message/QueryHistoryService.java:190`
- `server/src/main/java/org/apache/rocketmq/studio/ops/audit/MybatisPlusAuditRepository.java:98`
## Expected behavior
- Delete expired rows in bounded batches using an indexed ID/time selection.
- Continue until fewer than the configured batch size are removed.
- Bound one scheduled pass to avoid monopolizing the database.
- Preserve failure isolation between message, trace and audit cleanup.
- Add large-inventory and partial-failure regression tests.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@rocketmq.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Studio][Performance] Bound scheduled query-history and audit cleanup deletes [rocketmq-dashboard]
Posted by "lizhimins (via GitHub)" <gi...@apache.org>.
lizhimins commented on issue #2683:
URL: https://github.com/apache/rocketmq-dashboard/issues/2683#issuecomment-5505952439
Resolved by #2966 (merged into rocketmq-studio as 742dad0d).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@rocketmq.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Studio][Performance] Bound scheduled query-history and audit cleanup deletes [rocketmq-dashboard]
Posted by "RockteMQ-AI (via GitHub)" <gi...@apache.org>.
RockteMQ-AI commented on issue #2683:
URL: https://github.com/apache/rocketmq-dashboard/issues/2683#issuecomment-5452926174
**Issue Evaluation**
Category: `enhancement` | Status: **Evaluated**
**Feasibility:** Feasible
**Scope:** `QueryHistoryService`, `MybatisPlusAuditRepository` — scheduled cleanup paths
**Compatibility:** No breaking changes; internal batch sizing is additive.
Well-identified performance concern. Unbounded `DELETE` on large tables can indeed cause long transactions and lock contention. The proposed approach — bounded batch deletion with a configurable pass limit — is a standard pattern for this class of problem.
Key considerations:
- Batch size should be configurable (not hardcoded) to accommodate different deployment scales.
- Failure isolation between message/trace/audit cleanup is important — each should proceed independently.
- Regression tests for partial-failure scenarios will help prevent regressions.
This is a solid improvement for large-scale deployments.
---
*Automated evaluation by RockteMQ-AI*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@rocketmq.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Studio][Performance] Bound scheduled query-history and audit cleanup deletes [rocketmq-dashboard]
Posted by "lizhimins (via GitHub)" <gi...@apache.org>.
lizhimins closed issue #2683: [Studio][Performance] Bound scheduled query-history and audit cleanup deletes
URL: https://github.com/apache/rocketmq-dashboard/issues/2683
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@rocketmq.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org