--lock-ddl-per-table

This page is part of MariaDB's Documentation.

The parent of this page is: mariadb-backup & mariabackup

Topics on this page:

• Overview

• USAGE

• DETAILS

  • SYNONYMS

  • SCHEMA

  • PARAMETERS

  • SKYSQL

  • PRIVILEGES

• EXAMPLES

• ERROR HANDLING

• FEATURE INTERACTION

• RESPONSES

• DIAGNOSIS

• ISO 9075:2016

• CHANGE HISTORY

• RELATED TOPICS

• EXTERNAL REFERENCES

Overview

This is a command-line option for the mariadb-backup & mariabackup commands.

This option tells MariaDB Backup to obtain a read metadata lock for each table, which can prevent concurrent DDL from occurring during the backup. Before the backup starts, MariaDB Backup acquires a metadata lock for each individual table on the system. The metadata locks are released when the backup completes.

See also: Options for mariadb-backup & mariabackup in MariaDB Enterprise Server 23.08, in 23.07 ES, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS