Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.2, 10.3.0
Description
As part of WL#7277 in MySQL 5.7, redo logging was disabled during ALTER TABLE…ALGORITHM=INPLACE operations that rebuild the table or create indexes (other than spatial indexes).
In Bug#21796691 INNODB REDO LOG DOES NOT INDICATE WHEN REDO LOGGING IS SKIPPED (MySQL 5.7.9, the first GA release) I introduced the redo log record MLOG_INDEX_LOAD for informing backup tools that the backup may be invalid.
For deployments where ALTER TABLE operations may be executed concurrently with backup, it would be simpler to keep writing redo log, and not having backups fail, and not need any --lock-ddl-per-table option that makes backup interfere with the normal operation of the server. This would also remove the need to flush dirty pages from the buffer pool before committing the ALTER TABLE operation.
On the other hand, when bulk loading data (before MDEV-515 is implemented), it can be useful to load the data first, then create secondary indexes. For this use case, omitting the redo logging may be very useful. So, we should have an option that controls whether the redo logging should be disabled.
Attachments
Issue Links
- causes
-
MDEV-20608 innodb_log_optimize_ddl=OFF may omit some redo log
- Closed
-
MDEV-21347 innodb_log_optimize_ddl=OFF is not crash safe
- Closed
- relates to
-
MDEV-16791 mariabackup : allow consistent backup, in presence of concurrent DDL, also without --lock-ddl-per-table
- Closed
-
MDEV-19747 Deprecate and ignore innodb_log_optimize_ddl
- Closed
-
MDEV-23720 Change innodb_log_optimize_ddl=OFF by default
- Closed
-
MDEV-28415 ALTER TABLE on a large table hangs InnoDB
- Closed
-
MDEV-13563 lock DDL for mariabackup in 10.2+
- Closed
-
MDEV-14545 Backup fails due to MLOG_INDEX_LOAD record
- Closed
-
MDEV-15625 Mariabackup cannot prepare backup
- Closed