A lightweight backup lock has been added in MySQL8.x to allow DML operation during online backup and prevent inconsistent snapshots. This lock prohibits some operations, including:

File creation, deletion, renaming account management Repair table truncation table optimization table backup lock by? Lock the instance for backup? And then what? Unlock instance? Grammatical composition. Use of these statements requires BACKUP_ADMIN permission.