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

Windows: Opt-out of Win11 automatic CPU throttling (LowQOS)

    XMLWordPrintable

Details

    Description

      The new Win11 feature - autodetection of QoS misclassifies MariaDB server as "EcoQos", i.e a background application that should be power throttled.

      In special case of hybrid CPU design, such as Alder Lake Intel processor, mariadbd.exe will be put into low-performance "efficiency cores". This does not happen if mariadb server runs in a visible window (or runs with higher priority, or runs under powerful admin user) . But in our default setting, MariaDB is a service - no visible windows, runs under low-privileged user, normal priority - in this case misdetection happens.

      The effect of this is reduced performance - on my own machine with Alder Lake processor,
      sysbench benchmark (oltp_point_select/20 users, 1 table, 1 mio rows, in-memory) runs with approx 260K qps instead of 450 kps.

      Documentation states, that this EcoQOS should not be used with performance critical applications. As we like to think of mariadb as performance critical, we should to opt-out of autodetection feature. Those user who find that they need it, can force EcoQOS themselves , e.g via task manager

      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.