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

Enhancement: ALTER TABLE ... REBUILD PARTITION ... blocks all writes to the table, including inserts that would go to other partitions

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      At the moment, ALTER TABLE ... REBUILD PARTITION ... results in a table lock being placed. This prevents all operations on the entire table, including operations that would obviously not touch the partition being rebuilt (i.e. where the WHERE clause explicitly specifies a value for a partitioned field that falls outside of the content of the partition being rebuilt.

      It would be really useful if this full table level lock could be avoided by effectively treating each partition as a separate table for purposes of locking.

      Attachments

        Activity

          People

            Unassigned Unassigned
            gordan Gordan Bobic
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.