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

Use condition variables and normal mutexes instead of InnoDB os_event and mutex

    XMLWordPrintable

Details

    Description

      investigation suggested by marko on zulip after reading http://smalldatum.blogspot.com/2020/01/it-is-all-about-constant-factors.html

      no patches - built just straight from 10.4.10 release tag. Built with cmake -DMUTEXTYPE=$type -DCMAKE_PREFIX_INSTALL=/scratch/mariadb-10.4.10-$type $HOME/mariadb-10.4.10
      Distro ubuntu-18.04 compiler.

      TPCCRunner test:

      POWER8, altivec supported - 20 core, 8 thread/core

      $ tail  fullrun-master-fstn4-mariadb-10.4.10-futex-28444.txt   fullrun-master-fstn4-mariadb-10.4.10-event-48215.txt  fullrun-master-fstn4-mariadb-10.4.10-sys-60112.txt
      ==> fullrun-master-fstn4-mariadb-10.4.10-futex-28444.txt <==
       
                    timestamp          tpm      avg_rt      max_rt   avg_db_rt   max_db_rt
                      average  2519939.03       50.01         687       50.00         687
       
         All phase Transactions: 100508512
      Warmup phase Transactions: 24910341
         Run phase Transactions: 75598171
       
      Waiting slaves to terminate users.
      All slaves disconnected.
       
      ==> fullrun-master-fstn4-mariadb-10.4.10-event-48215.txt <==
       
                    timestamp          tpm      avg_rt      max_rt   avg_db_rt   max_db_rt
                      average  1944470.28       63.97         782       63.96         782
       
         All phase Transactions: 466885487
      Warmup phase Transactions: 350217270
         Run phase Transactions: 116668217
       
      Waiting slaves to terminate users.
      All slaves disconnected.
       
      ==> fullrun-master-fstn4-mariadb-10.4.10-sys-60112.txt <==
       
                    timestamp          tpm      avg_rt      max_rt   avg_db_rt   max_db_rt
                      average  2412875.70       51.72         846       51.71         846
       
         All phase Transactions: 579124495
      Warmup phase Transactions: 434351953
         Run phase Transactions: 144772542
       
      Waiting slaves to terminate users.
      All slaves disconnected.
      

      Note: while futex was run for much less time - innodb_buffer_pool_dump_pct=100 from the last run and the 30 minutes was receiving consistent throughput.

      Intel(R) Xeon(R) CPU E5-2699 v4 @ 2.20GHz - 22 core, 4 thread/core

      ==> fullrun-master-ka4-mariadb-10.4.10-event-rr-50070.txt <==
       
                    timestamp          tpm      avg_rt      max_rt   avg_db_rt   max_db_rt
                      average  3354020.40       34.35         487       34.32         487
       
         All phase Transactions: 132952152
      Warmup phase Transactions: 32331540
         Run phase Transactions: 100620612
       
      Waiting slaves to terminate users.
      All slaves disconnected.
       
      ==> fullrun-master-ka4-mariadb-10.4.10-futex-rr-63543.txt <==
       
                    timestamp          tpm      avg_rt      max_rt   avg_db_rt   max_db_rt
                      average  3362135.83       33.50         604       33.48         604
       
         All phase Transactions: 131218680
      Warmup phase Transactions: 30354605
         Run phase Transactions: 100864075
       
      Waiting slaves to terminate users.
      All slaves disconnected.
       
      ==> fullrun-master-ka4-mariadb-10.4.10-sys-rr-56865.txt <==
       
                    timestamp          tpm      avg_rt      max_rt   avg_db_rt   max_db_rt
                      average  3363324.87       34.13         996       34.11         996
       
         All phase Transactions: 132642637
      Warmup phase Transactions: 31742891
         Run phase Transactions: 100899746
       
      Waiting slaves to terminate users.
      All slaves disconnected.
      

      Attachments

        1. master.properties.60
          0.8 kB
          Daniel Black
        2. MDEV-21452.ods
          80 kB
          Daniel Black
        3. MDEV-21452.ods
          60 kB
          Axel Schwenke
        4. MDEV-21452-nbl.ods
          66 kB
          Axel Schwenke
        5. my.cnf
          2 kB
          Daniel Black
        6. Screenshot from 2020-03-26 12-08-54.png
          88 kB
          Krunal Bauskar

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              13 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.