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

Thread Pool Auto-Scaling Based on CPU Count

Details

    Description

      Implement periodic CPU count detection (e.g., via syscalls or OS notifications).
      See https://jira.mariadb.org/browse/MDEV-36194 for more information on use case.

      Add system variables:
      *thread_pool_auto_scale_method=

      {OFF, CPU_count, hill_climbing}

      (default: OFF).

      1. thread_pool_auto_scale_factor=N (default: 1).
      2. Set thread_pool_size = CPU_count * thread_pool_auto_scale_factor when CPU_count mode is enabled.
      3. Reject manual SET GLOBAL thread_pool_size when auto-scaling is active.
      4. Make polling frequency configurable (e.g., once per second, per minute), defaulting to once per minute.

      Acceptance Criteria

      1. thread_pool_auto_scale_method=CPU_count activates CPU-based scaling.
      2. Example: CPU_count=8, thread_pool_auto_scale_factor=2, thread_pool_size=16.
      3. Manual SET GLOBAL thread_pool_size fails with an error when auto-scaling is enabled.
      4. Polling frequency defaults to once per minute and is configurable.
      5. Ensure the system variables are manually configurable

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-36194 Automatic Scaling for Dynamic Environments

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            adamluciano Adam Luciano created issue -
            adamluciano Adam Luciano made changes -
            Field Original Value New Value
            adamluciano Adam Luciano made changes -
            adamluciano Adam Luciano made changes -
            Labels server Performance kubernetes server
            adamluciano Adam Luciano made changes -
            Description Implement periodic CPU count detection (e.g., via syscalls or OS notifications).
            See https://jira.mariadb.org/browse/MDEV-36194 for more information on use case.

            *Add system variables:*
            *thread_pool_auto_scale_method={OFF, CPU_count, hill_climbing} (default: OFF).
            # thread_pool_auto_scale_factor=N (default: 1).
            # Set thread_pool_size = CPU_count * thread_pool_auto_scale_factor when CPU_count mode is enabled.
            # Reject manual SET GLOBAL thread_pool_size when auto-scaling is active.
            # Make polling frequency configurable (e.g., once per second, per minute), defaulting to once per minute.

            *Acceptance Criteria*
            # thread_pool_auto_scale_method=CPU_count activates CPU-based scaling.
            # Example: CPU_count=8, thread_pool_auto_scale_factor=2, thread_pool_size=16.
            # Manual SET GLOBAL thread_pool_size fails with an error when auto-scaling is enabled.
            # Polling frequency defaults to once per minute and is configurable.             		Implement periodic CPU count detection (e.g., via syscalls or OS notifications).
            See https://jira.mariadb.org/browse/MDEV-36194 for more information on use case.

            *Add system variables:*
            *thread_pool_auto_scale_method={OFF, CPU_count, hill_climbing} (default: OFF).
            # thread_pool_auto_scale_factor=N (default: 1).
            # Set thread_pool_size = CPU_count * thread_pool_auto_scale_factor when CPU_count mode is enabled.
            # Reject manual SET GLOBAL thread_pool_size when auto-scaling is active.
            # Make polling frequency configurable (e.g., once per second, per minute), defaulting to once per minute.

            *Acceptance Criteria*
            # thread_pool_auto_scale_method=CPU_count activates CPU-based scaling.
            # Example: CPU_count=8, thread_pool_auto_scale_factor=2, thread_pool_size=16.
            # Manual SET GLOBAL thread_pool_size fails with an error when auto-scaling is enabled.
            # Polling frequency defaults to once per minute and is configurable.
            # Ensure the system variables are manually configurable

            People

              wlad Vladislav Vaintroub
              adamluciano Adam Luciano
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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