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

Skip the ha_innobase::prepare_inplace_alter_table() phase if no inplace_alter_table() phase is needed

    Details

      Description

      In the ALGORITHM=INPLACE API, if the operation involves data changes, such as adding an index or rebuilding the table, it will be necessary to invoke a "prepare" phase followed by a data transformation phase.

      Currently, the "prepare" phase is unnecessarily being executed for instant ADD COLUMN (MDEV-11369) and possibly other operations. This causes an unnecessary step to acquire and downgrade an exclusive meta-data lock, before upgrading the lock to exclusive again for executing ha_innobase::commit_inplace_alter_table().

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: