Open BohuTANG opened 4 months ago
@ZhiHanZ this task_advice table need your advices :/
SHOW ADVICES FOR TABLE xxx;
The compaction service needs to know the endpoints of the query nodes to fetch the result from advice table. But the query nodes are serverless and multi-tenant.
Since the compaction service must depend on S3 and metaservice, why not fetch the advice in the compaction service on schedule?
why not fetch the advice in the compaction service on schedule?
We can execute the advices in the cloud background service. However, this issue extends beyond just background services; Aims to give some advices for the tables in databases, and tell the user how to do next.
Reference: Oracle Database Advisors: https://blogs.oracle.com/coretec/post/oracle-database-advisors-overview
Summary
Add a system table for advice the background serivice: