MariaDB ColumnStore Locking

MariaDB ColumnStore locking: lockless reads, table locks for writes, and write metadata locks during cpimport bulk loads, designed to minimize blocking on analytics.

Overview

MariaDB ColumnStore minimizes locking for analytical workloads, bulk data loads, and online schema changes.

Lockless Reads

MariaDB ColumnStore supports lockless reads.

Locking for Writes

MariaDB ColumnStore requires a table lock for write operations.

Locking for Data Loading

MariaDB ColumnStore requires a write metadata lock (MDL) on the table when a bulk data load is performed with cpimport.

When a bulk data load is running:

• Read queries will not be blocked.

• Write queries and concurrent bulk data loads on the same table will be blocked until the bulk data load operation is complete, and the write metadata lock on the table has been released.

• The write metadata lock (MDL) can be monitored with the METADATA_LOCK_INFO plugin.

For additional information, see "MariaDB ColumnStore Data Loading".

Online Schema Changes

MariaDB ColumnStore supports online schema changes, so that supported DDL operations can be performed without blocking reads. The supported DDL operations only require a write metadata lock (MDL) on the target table.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}