Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29020

Spider spawns unnecessarily many system threads for stats synchronization

Details

    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.

      Attachments

        Activity

          ycp Yuchen Pei added a comment -

          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

          ycp Yuchen Pei added a comment - 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

          ok to push.

          holyfoot Alexey Botchkov added a comment - ok to push.
          ycp Yuchen Pei added a comment -

          thanks for the review. pushed 9d15c3e35a30ad4801f00632c194fe2850cd79f1 to 10.4

          ycp Yuchen Pei added a comment - thanks for the review. pushed 9d15c3e35a30ad4801f00632c194fe2850cd79f1 to 10.4

          People

            ycp Yuchen Pei
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.