[MDEV-27253] Reorganize Spider plugin variables regarding table/index stats Created: 2021-12-14  Updated: 2023-12-22

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Fix Version/s: 11.5

Type: Task Priority: Major
Reporter: Nayuta Yanagisawa (Inactive) Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: spider-sts-crd

Issue Links:
Blocks
is blocked by MDEV-27233 Server hangs when using --init-file w... Closed
Relates
relates to MDEV-27228 Deprecate Spider plugin variables tha... Stalled
relates to MDEV-27255 Delete variables, deprecated by MDEV-... Stalled
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
MDEV-27995 Delete Spider plugin variables regard... Technical task Stalled Yuchen Pei  
MDEV-27996 Delete spider_crd_mode and spider_sts... Technical task Stalled Yuchen Pei  
MDEV-27998 Delete spider_table_crd_thread_count ... Technical task Stalled Yuchen Pei  
MDEV-27254 Delete spider_crd_type and spider_crd... Technical task Stalled Yuchen Pei  
MDEV-28355 Deprecate spider_crd_bg_mode, spider_... Technical task Closed Nayuta Yanagisawa  
MDEV-28356 Deprecate spider_crd_interval, spider... Technical task Closed Nayuta Yanagisawa  
MDEV-27997 Introduce spider_sync_stats_enabled p... Technical task Stalled Yuchen Pei  
MDEV-28357 Introduce spider_sync_stats_interval ... Technical task Open Yuchen Pei  

 Description   

Spider has many plugin variables regarding table statistics but they looks redundant. Reorganize them as the following:

New variable Corresponding old variables Comment
  spider_store_last_crd, spider_store_last_sts, spider_load_crd_at_startup, spider_load_sts_at_startup Always persist stats if sync is ON.
  spider_crd_mode, spider_sts_mode Use SHOW TABLE/INDEX always.
spider_sync_stats_enabled spider_crd_bg_mode, spider_crd_sync, spider_bg_sts_mode, spider_sts_sync 0: no sync, 1: sync background
  spider_table_crd_thread_count, spider_table_sts_thread_count A single thread for both crd and sts seems to be enough.
  spider_crd_type, spider_crd_weight Make it adaptive someday.
spider_sync_stats_interval spider_crd_interval, spider_sts_interval  

Some comments:

  • Ultimately, I think all parameters should be removed (the best settings should be applied automatically).
  • Does it make sense to disable stats synchronization, in the first place?

Reference:
Generated at Thu Feb 08 09:51:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.