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

performance regression with threadpool

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.25, 10.1.14
    • 10.1.25
    • OTHER
    • Ubuntu x86_64
    • 10.0.26, 10.0.28, 5.5.55, 10.0.30

    Description

      Enabling the thread pool leads to about 5% performance loss in MariaDB 10.0 and 10.1, but not in MariaDB 5.5. I tested 5.5.49 vs. 10.0.25 vs. 10.1.14.

      The benchmark is sysbench OLTP read-only with 1000 point-selects per transaction. The benchmark machine has 16 cores (32 hyperthreads).

      my.cnf:

      [mysqld]
      max_connections = 1300
      table_open_cache = 2600
      query_cache_type = 0
       
      innodb_buffer_pool_size = 512M
      innodb_buffer_pool_instances = 10
      innodb_adaptive_hash_index_partitions = 20
       
      thread_handling=pool-of-threads
      

      See attached spread sheet for numbers.

      Attachments

        1. one_thread.txt
          77 kB
        2. pool.txt
          77 kB
        3. threadpool.ods
          56 kB
        4. tp10.png
          tp10.png
          60 kB
        5. tp1000.png
          tp1000.png
          57 kB

        Activity

          Transition Time In Source Status Execution Times
          Vladislav Vaintroub made transition -
          Open In Progress
          41d 4h 43m 1
          Axel Schwenke made transition -
          In Progress Stalled
          390d 18h 50m 1
          Axel Schwenke made transition -
          Stalled In Progress
          1d 17m 1
          Axel Schwenke made transition -
          In Progress Closed
          4d 20h 11m 1

          People

            axel Axel Schwenke
            axel Axel Schwenke
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.