Tag - An optimized(without redo logging) DDLoperation has been performed

Avoiding the “An optimized (without redo logging) DDL operation has been performed” Error with Percona XtraBackup

Percona XtraBackup

This blog discusses newly added options for Percona XtraBackup 2.4.8 and how they can impact your database backups.
To avoid issues with MySQL 5.7 skipping the redo log for DDL, Percona XtraBackup has implemented three new options (
xtrabackup –lock-ddl,
xtrabackup –lock-ddl-timeout,
xtrabackup –lock-ddl-per-table) that can be used to place MDL locks on tables while they […]

Read more