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

Extending indexed VARCHAR column should be instantaneous

Details

    Description

      MySQL 5.7 (which was merged to MariaDB 10.2.2) implements an instantaneous change of the maximum length of a VARCHAR column when the length is increasing and not crossing the 255-byte boundary.

      Alas, when the VARCHAR column was indexed, the indexes would be dropped and added. This should be avoided.

      MySQL 5.7.23 addressed this by changing the storage engine API. We would prefer a less intrusive change. InnoDB should be able to ‘optimize away’ pairs of DROP INDEX and ADD INDEX operations. (While doing that, InnoDB in MariaDB should support the renaming of indexes as well, without introducing the RENAME INDEX syntax from MySQL 5.7.)

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-11424 Instant ALTER TABLE of failure-free record format changes

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

          Task - A task that needs to be done. MDEV-17965 Allow instant VARCHAR increase of indexed fields

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-15563 Instant failure-free data type conversions

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16850 Merge new release of InnoDB 5.7.23 to 10.2

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

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Confirmed
            		3d 6h 40m 1
            Thirunarayanan Balathandayuthapani made transition -
            Confirmed In Progress
            		75d 13h 44m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Review
            		8d 16h 38m 2
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Progress
            		19d 2h 52m 2
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            		7d 7h 36m 3
            Sergei Golubchik made transition -
            In Review Stalled
            		69d 29m 5
            Thirunarayanan Balathandayuthapani made transition -
            Stalled Closed
            		1d 1h 34m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              marko Marko Mäkelä
              Votes:
              0 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.