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

performance regression with threadpool

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.0.25, 10.1.14
    • Fix Version/s: 10.1.25
    • Component/s: OTHER
    • Labels:
    • Environment:
      Ubuntu x86_64
    • Sprint:
      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

            People

            • Assignee:
              axel Axel Schwenke
              Reporter:
              axel Axel Schwenke
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: