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

Significant performance regression using TokuDB tables in mariadb.org builds

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.36, 10.0.8
    • 5.5.37, 10.0.10
    • None
    • Ubuntu 13.10, (2) x Intel Xeon E5540, 48GB, 8 x 10K SAS in RAID10, 256MB Cache, XFS

    Description

      In testing the performance of TokuDB tables using the MariaDB builds (available from mariadb.org) I noticed significant performance regressions. The following is for Sysbench (data > cache, IO bound):
      workload = read/write
      tables = 16
      distribution = uniform
      rows / table = 10 million
      tokudb_cache_size = 8G
      tokudb_directio = 1
      tokudb_read_block_size = 64K
      tokudb_row_format = tokudb_lzma
      performance_schema=off

      Table are bulk-loaded, then ran the test for 64 and 128 client threads, 5 minutes per thread count. Results as follows:

      MariaDB 10.0.8 : source = mariadb.org
      64 threads, 78.0 tps
      128 threads, 95.6 tps

      MariaDB 5.5.36 : source = mariadb.org
      64 threads, 78.4 tps
      128 threads, 95.8 tps

      MariaDB 5.5.30 : source = tokutek.com
      64 threads, 132.3 tps
      128 threads, 161.5 tps

      MySQL 5.5.30 : source = tokutek.com
      64 threads, 134.8 tps
      128 threads, 164.1 tps

      MySQL 5.5.36 : source = tokutek.com
      64 threads, 131.2 tps
      128 threads, 161.4 tps

      Attachments

        1. global-variables.diff.txt
          5 kB
        2. oltp_ro_5.5.30.gif
          oltp_ro_5.5.30.gif
          10 kB
        3. oltp_ro_5.5.35.gif
          oltp_ro_5.5.35.gif
          10 kB
        4. series53.ods
          28 kB
        5. series54.ods
          23 kB
        6. tokudb_oltp.gif
          tokudb_oltp.gif
          14 kB

        Activity

          People

            serg Sergei Golubchik
            tmcallaghan Tim Callaghan (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            14 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.