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

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33087 ALTER TABLE...ALGORITHM=COPY should build indexes more efficiently

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-16281 Implement parallel CREATE INDEX, ALTER TABLE, or bulk load

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-29035 review InnoDB page fill factor

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34096 REPAIR sometimes de-optimizes an InnoDB table

          • Major - Major loss of function.
          • Open

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.