Implement BACKUP LOCK [database.]table_name and BACKUP UNLOCK
These commands are needed for external backup tools, like mariabackup, to ensure that all files for a table are from the same generation (ie, was created by the same CREATE, RENAME or ALTER TABLE statement).
The typical usage of this by a backup tools is to do the following when copying a table:
- BACKUP LOCK [database.]table_name
- Open all files related to a table (for example, test.frm, test.MYI and test.MYD)
- BACKUP UNLOCK
- Copy data
- Close files
The idea is that the BACKUP LOCK should be hold as short time as possible.
The time to take an uncontested lock is very short; While testing on a laptop from a perl program, I was able to do more than 50,000 LOCK + UNLOCK per second.
- Internally BACKUP LOCK is implemented by taking a MDLSHARED_HIGH_PRIO on the table object, which protects the table from any DDL operations.
- One should use different connections for BACKUP STAGE ... and BACKUP LOCK commands as one should be able to do BACKUP LOCK commands while waiting to get the new BACKUP STAGE lock.