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

In ALGORITHM=INPLACE, use a common name for the intermediate tables or partitions

    XMLWordPrintable

    Details

      Description

      DDL operations in MariaDB are known to not be crash-safe. The most unsafe is ALGORITHM=INPLACE, because the .frm file is replaced out of sync with the InnoDB transaction commit.

      One thing that can be improved is that when the server is killed before the InnoDB transaction commit becomes durable, the intermediate table should be removable by executing a statement like

      DROP TABLE `#mysql50##sql-abcd_1.frm`;
      

      Currently, the intermediate table in the InnoDB internal data dictionary is not derived from the .frm file name, and such a DROP TABLE statement would leave orphan entries in the InnoDB internal data dictionary.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: