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

Poor RBR update performance with partitioned tables

    XMLWordPrintable

Details

    Description

      This is related to the following upstream bug:

      https://bugs.mysql.com/bug.php?id=73648

      When binlog_format=ROW is set and a partitioned table is updated, the update seems to perform much slower than an equivalent update of a non-partitioned table.

      Some MTR tests have been contributed to demonstrate this problem. They are in the attached zip archive. The results were reported as the following:

      mariadb-10.1.31

      bug.test 'innodb_plugin,row' [ pass ] 114205
      bug.test_no_partition 'innodb_plugin,row' [ pass ] 22101

      bug.test 'row,xtradb' [ pass ] 429822
      bug.test_no_partition 'row,xtradb' [ pass ] 65829

      mariadb 10.2.12

      bug.test 'innodb,row' [ pass ] 161739
      bug.test_no_partition 'innodb,row' [ pass ] 28501

      mysql-5.6.39

      bug.test [ pass ] 158594
      bug.test_no_partition [ pass ] 20350

      mysql 5.7.21

      bug.test [ pass ] 37490
      bug.test_no_partition [ pass ] 26441

      MySQL 5.7 most likely performs better because of the introduction of native partitioning. Native partitioning was removed from MariaDB 10.2 during the 5.7 InnoDB merge. See MDEV-15223.

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              9 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.