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

better defaults for Windows native threadpool implementation

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.6.0
    • Server
    • None

    Description

      • There is a measurable (on benchmarks) overhead from "auto" priority implementation, which increases prio inside transaction.

      The "auto" implementation shuffles low-priority (outside of transaction) clients into work queue, and handles high prio clients(inside transaction), directly, on socket IO notification. The "shuffle" costs some CPU overhead, and can result in more threads than necessary.

      So, while we still allow "auto", we rather make it non-default here, because of non-zero overhead.

      • As reported by MS folks, setting max.threads too high may have detrimental
        effects on native threadpool, so use native default.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.