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

QPS drops by 11% for one point-query test from sysbench

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.1.1
    • 12.2
    • None
    • None
    • Ubuntu 24.04, 48-core server

    Description

      The relative QPS for the points-covered-si test that I run via sysbench drops by about 20% starting in 11.0.6, it then improved a bit in 11.8.3 and the QPS in 12.1.1 is about 11% less than 10.2.30 (rQPS was 1.05 in 10.11.14, drops to 0.83 in 11.0.6, rises to 0.91 in 11.8.3 and is now 0.89 in 12.1.1 – relative QPS is (QPS for my version / QPS for 10.2.30). The numbers are here.

      A repro script that runs all tests, including points-covered-si, is here. I ran it with 40 clients, 8 tables and 10M rows per table on a 48-core server.

      From vmstat metrics the CPU overhead increases by about 1.27X in 11.0.6. I don't see an increase in context switches. See cpu/o here

      Attachments

        Activity

          People

            axel Axel Schwenke
            mdcallag Mark Callaghan
            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.