Aias00 opened a new issue, #2682: URL: https://github.com/apache/rocketmq-dashboard/issues/2682
## Problem Window aggregation queries metric snapshots by instance, metric, domain, labels hash, optional cluster, availability and collection time. The current lookup index only contains `(instance_id, metric_key, collected_at)`, leaving high-cardinality scope filters outside the index. ## Evidence - `server/src/main/java/org/apache/rocketmq/studio/cluster/metrics/MybatisPlusMetricSnapshotRepository.java:58` - `server/src/main/java/org/apache/rocketmq/studio/ops/alert/NativeAlertProcessor.java:116` - `server/src/main/resources/db/schema.sql:290` ## Expected behavior - Add an index matching the actual `findRecent` equality filters followed by `collected_at`. - Keep retention deletion supported by the existing time index. - Update fresh schema and existing-database migration contracts. - Add schema/index regression coverage and document the MySQL query-plan expectation. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
