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

performance regression for mass update

    XMLWordPrintable

    Details

      Description

      Updating a column in all rows of an InnoDB table has become slower in MariaDB 10.3, compared to 10.2. Test case

      drop table if exists t1;
      create table t1 (id serial, c1 int, c2 char(10) default 'foobar');
      insert into t1 (c1) values (rand()*1000);
      insert into t1 (c1) select rand()*1000 from t1;
      ... (19 more times)
      update t1 set c2='x';
      

      The final UPDATE touches 1 mio rows. There is no index involved. The update can be done in place. In 10.2.14 the updates takes 2 seconds on average, in 10.3.5 it takes 3 seconds on average. More numbers in related MDEV-15213.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              axel Axel Schwenke
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: