Undo Logs In this case, initialize a new MySQL instance and start the data loading procedure again. The  INNODB_REDO_LOG_ENABLE  privilege is required to enable and disable redo logging. The  Innodb_redo_log_enabled  status variable permits monitoring redo logging status. Cloning operations and redo log archiving are not permitted while redo logging is disabled and vice versa. An  ALTER INSTANCE [ENABLE|DISABLE] INNODB REDO_LOG  operation requires an exclusive backup metadata lock, which prevents other  ALTER INSTANCE  operations from executing concurrently. Other ALTER INSTANCE  operations must wait for the lock to be released before executing. The following procedure demonstrates how to disable redo logging when loading data into a new MySQL instance. An undo log is a collection of undo log records associated with a single read-write transaction. An undo log record contains information about how to undo the latest change by a transaction to a clustered index 3078 15.6.6 Undo Logs Related Topics •Redo Log Encryption •Section 8.5.4, “Optimizing InnoDB Redo Logging” •Redo Log File Configuration mysql>  SHOW GLOBAL STATUS LIKE ’Innodb_redo_log_enabled’; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Innodb_redo_log_enabled | ON | +-------------------------+-------+ 6. Check the  Innodb_redo_log_enabled  status variable to ensure that redo logging is enabled. 5. As the  data_load_admin  user, enable redo logging after the data load operation finishes: 4. Run the data load operation. 3. Check the  Innodb_redo_log_enabled  status variable to ensure that redo logging is disabled. 2. As the  data_load_admin  user, disable redo logging: 1. On the new MySQL instance, grant the  INNODB_REDO_LOG_ENABLE  privilege to the user account responsible for disabling redo logging. mysql> GRANT INNODB_REDO_LOG_ENABLE ON *.* to ’data_load_admin’; mysql> ALTER INSTANCE DISABLE INNODB REDO_LOG; mysql>  SHOW GLOBAL STATUS LIKE ’Innodb_redo_log_enabled’; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Innodb_redo_log_enabled | OFF | +-------------------------+-------+ mysql> ALTER INSTANCE ENABLE INNODB REDO_LOG;