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

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: 10.1
        • Component/s: None
        • Labels:
          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.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

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

                    Dates

                    • Created:
                      Updated: