Note
This feature is an experimental feature in the current version.
This topic describes the operation, maintenance, and tuning of Agent hybrid search scenario. Operations such as deleting Collections or Namespaces are asynchronous background tasks. You can view the progress through system views and adjust the deletion concurrency and the hot Namespace cache TTL via tenant-level parameters.
Monitoring
You can query relevant views via SQL to view the progress of background tasks.
View |
Note |
|---|---|
| oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS | Background tasks currently in progress for the tenant (such as deletions or hot namespace expirations). |
| oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY | The history of completed background tasks in the current tenant. |
| oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS | All tenants: background tasks in progress (such as deletions or hot namespace expirations). |
| oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY | The history of completed background tasks for all tenants. |
Maintenance
Parameter |
Type |
Default value |
Note |
|---|---|---|---|
| enable_agent_db_background_task | bool | True | Whether to enable background deletion tasks for logical tables. |
| agent_db_background_delete_thread_score | int | 0 (indicating the use of the default value 2) | Number of background deletion threads. Range: [0, 100]. A larger value means faster data deletion but more resource consumption. |
| agent_db_hot_namespace_ttl | Time | 1h |
Hot namespace cache (vector index cluster centers) lifetime. Expired and unused caches are automatically evicted. Range: [1s, 180d]. After eviction, the data is reloaded on first access. You can use ns.prewarm() to preheat it. |