Queuing 表频繁在线收集统计信息导致相关 SQL 的执行计划频繁重新生成

[2025-02-26 18:50:20.429302] INFO  [SQL.PC] check_after_get_plan (ob_plan_cache.cpp:546) [3178125][T1006_L0_G0][T1006][xxxxx-xxxxx-xxxxx-xxxxx] [lt=0] the statistics of table is stale and evict plan.(plan->stat_={plan_id:0, sql_text:"delete from tmp_xxx_merge_result where batch_id = ? and ytenant_id=?", raw_sql:"delete from tmp_xxx_merge_result where batch_id = 'xxx' and ytenant_id='xxx'", gen_time:1740567020394424, schema_version:1740539898476376, last_active_time:1740567020395836, hit_count:0, mem_used:282360, slow_count:0, slowest_exec_time:1740567020395836, slowest_exec_usec:94122, execute_times:1, disk_reads:0, direct_writes:0, buffer_gets:38, application_wait_time:0, concurrency_wait_time:0, user_io_wait_time:0, rows_processed:16, elapsed_time:94122, cpu_time:94112, large_querys:0, delayed_large_querys:0, outline_version:1740474935831736, outline_id:1638777, is_evolution:false, is_last_exec_succ:true, is_bind_sensitive:false, is_bind_aware:false, is_last_exec_succ:true, timeout_count:0, evolution_stat:{executions:0, cpu_time:0, elapsed_time:0, error_cnt:0, last_exec_ts:0}, plan_hash_value:8600446970471666667, hints_all_worked:true})
[2025-02-26 18:50:20.739576] INFO  [SQL.PC] inner_add_cache_obj (ob_pcv_set.cpp:247) [3178125][T1006_L0_G0][T1006][xxxxx-xxxxx-xxxxx-xxxxx] [lt=1] has identical pcv(is_same=true, pcv=0x7f605e1bc600)

T1: insert into tmp_xxx_merge_result select ...
T2: delete from tmp_xxx_merge_result where ...
T3: insert into tmp_xxx_merge_result select ...
T4: delete from tmp_xxx_merge_result where ...
T5: insert into tmp_xxx_merge_result select ...
T6: delete from tmp_xxx_merge_result where ...
...
...
...

MySQL [xxx]> select * from oceanbase.dba_ob_table_stat_stale_info where database_name='xxx' and table_name='tmp_xxx_merge_result'\G
*************************** 1. row ***************************
     DATABASE_NAME: xxx
        TABLE_NAME: tmp_xxx_merge_result
    PARTITION_NAME: NULL
 SUBPARTITION_NAME: NULL
LAST_ANALYZED_ROWS: 631568
LAST_ANALYZED_TIME: 2025-02-26 20:09:01.779062
           INSERTS: 32027
           UPDATES: 0
           DELETES: 30563
     STALE_PERCENT: 10
          IS_STALE: NO
1 row in set (0.317 sec)

MySQL [xxx]> select * from oceanbase.dba_ob_table_stat_stale_info where database_name='xxx' and table_name='tmp_xxx_merge_result'\G
*************************** 1. row ***************************
     DATABASE_NAME: xxx
        TABLE_NAME: tmp_xxx_merge_result
    PARTITION_NAME: NULL
 SUBPARTITION_NAME: NULL
LAST_ANALYZED_ROWS: 631984
LAST_ANALYZED_TIME: 2025-02-26 20:09:07.065829
           INSERTS: 36778
           UPDATES: 0
           DELETES: 34634
     STALE_PERCENT: 10
          IS_STALE: YES
1 row in set (0.313 sec)

MySQL [xxx]> select * from oceanbase.dba_ob_table_stat_stale_info where database_name='xxx' and table_name='tmp_xxx_merge_result'\G
*************************** 1. row ***************************
     DATABASE_NAME: xxx
        TABLE_NAME: tmp_xxx_merge_result
    PARTITION_NAME: NULL
 SUBPARTITION_NAME: NULL
LAST_ANALYZED_ROWS: 632416
LAST_ANALYZED_TIME: 2025-02-26 20:09:12.199433
           INSERTS: 41450
           UPDATES: 0
           DELETES: 39431
     STALE_PERCENT: 10
          IS_STALE: YES
1 row in set (0.274 sec)

MySQL [xxx]> select * from oceanbase.dba_ob_table_stat_stale_info where database_name='xxx' and table_name='tmp_xxx_merge_result'\G
*************************** 1. row ***************************
     DATABASE_NAME: xxx
        TABLE_NAME: tmp_xxx_merge_result
    PARTITION_NAME: NULL
 SUBPARTITION_NAME: NULL
LAST_ANALYZED_ROWS: 648064
LAST_ANALYZED_TIME: 2025-02-26 20:16:43.011552
           INSERTS: 415652
           UPDATES: 0
           DELETES: 413770
     STALE_PERCENT: 10
          IS_STALE: YES
1 row in set (0.298 sec)