[MDEV-29020] Spider spawns unnecessarily many system threads for stats synchronization Created: 2022-07-04  Updated: 2023-12-05  Resolved: 2023-12-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

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


 Description   

Spider spawns 10 stats synchronization system threads per statistics by default. This seems to be too much for many use cases and unnecessarily many threads complicate debugging.

Set the default values of spider_table_crd_thread_count and spider_table_sts_thread_count to 1.



 Comments   
Comment by Yuchen Pei [ 2023-11-22 ]

Hi holyfoot, ptal at this 2-line patch, thanks

upstream/bb-10.4-mdev-28739 00c82482112908e13fffe2b29def817f833de22b
MDEV-29020 Reduce default spider bg sts/crd thread counts

The change will need to be documented on the kb

Comment by Alexey Botchkov [ 2023-12-04 ]

ok to push.

Comment by Yuchen Pei [ 2023-12-05 ]

thanks for the review. pushed 9d15c3e35a30ad4801f00632c194fe2850cd79f1 to 10.4

Generated at Thu Feb 08 10:05:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.