v.21.1Improvements

Less Locking in ALTER Command

Less locking in ALTER command. #31010 (Amos Bird).
Reduced locking during the ALTER command to improve concurrency and performance.

Why it matters

This feature minimizes the duration and scope of locks held when executing ALTER commands, allowing other queries and operations to proceed with less waiting. It addresses the problem of contention and performance bottlenecks during schema changes or table alterations, enhancing overall system responsiveness and throughput.

How to use it

Users benefit from this improvement automatically when running ALTER commands, with no additional configuration required.