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

ALTER TABLE IMPORT enhancement

    XMLWordPrintable

Details

    Description

      The feature introduces simplified workflow:

      FLUSH TABLES t1 FOR EXPORT;
      		 
      --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t2.cfg
      		 
      --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm
      		 
      --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t2.ibd
      		 
      UNLOCK TABLES;
      		 
      ALTER TABLE t2 IMPORT TABLESPACE;

      Previously, CREATE TABLE and ALTER TABLE…DISCARD TABLESPACE had to be executed, and the exact table definition from an existing .frm file could not be reused. This simplification addresses MDEV-15225.

      ha_innodb::open() should check for .ibd and .cfg files before actually opening a table.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11658 Simpler, faster IMPORT of InnoDB tables

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15225 Can't import .ibd file with temporal type format differing from mysql56_temporal_format

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-18762 Support easy restore of partial backup

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-31010 Q2 2023 release merge

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33226 ALTER TABLE IMPORT enhancement for Partitioned tables

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10568 Implement support for ALTER TABLE ... {DISCARD|IMPORT} PARTITION

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15225 Can't import .ibd file with temporal type format differing from mysql56_temporal_format

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26155 Mangled data after IMPORT tablespace up till assert for DDL

          • Major - Major loss of function.
          • Open

          Activity

            People

              ycp Yuchen Pei
              kevg Eugene Kosov (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: