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

Inplace alter rebuild increases file size

    XMLWordPrintable

    Details

      Description

      After inplace alter table, InnoDB increases the file size. InnoDB does the normal insert
      and file size is 32 mb after flushing all the pages. Inplace Alter table rebuilds the
      table and increases the file size(36MB) by 4MB.

      --source include/have_innodb.inc
      --source include/have_sequence.inc
      create table t1(f1 int not null primary key, b char(255) CHARACTER SET utf8)engine=innodb;
      INSERT INTO t1(f1) SELECT * FROM seq_1_to_1000000;
      --source include/restart_mysqld.inc # Here t1 size is 32 MB
      alter table t1 force, algorithm=inplace; 
      --source include/restart_mysqld.inc# Here t1 size is 36 MB
      drop table t1;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration