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

Inplace alter rebuild increases file size

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

          New Feature - A new feature of the product, which has yet to be developed. 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

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Confirmed
            		4d 1h 59m 1
            Thirunarayanan Balathandayuthapani made transition -
            Confirmed In Progress
            		804d 19h 36m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            		3h 27m 1
            Marko Mäkelä made transition -
            In Review Stalled
            		22h 8m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Testing
            		15d 23h 9m 1
            Matthias Leich made transition -
            In Testing Stalled
            		5d 7h 21m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled Closed
            		4d 17h 14m 1

            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.