My Oracle Support Banner

MEB Backup Freezes: "Redo log writer is waiting for MEB redo log consumer which is currently reading" From MySQL Error (Doc ID 2909451.1)

Last updated on APRIL 24, 2023

Applies to:

MySQL Server - Version 8.0 and later
MySQL Enterprise Backup - Version 8.0 to 8.0 [Release 8.0]
Information in this document applies to any platform.


When starting a backup, a transaction affecting many rows, especially a bulk insert.
Backup did not advance and insert of data did not advance as well.

The following message in the error log is present on MySQL error log:





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Q(1) is the increase of innodb_redo_log_capacity the only way to solve that issue ?
 Q(2) even if the redo space is full, why the flush is not operational ?
 Q(3) Isn't there any way to play on any parameters which lower the time between 2 flush from redo to archive ?
 Q(4) What does the following means: "Redo log writer is waiting for MEB redo log consumer ... ...". What is the redo log writer ? Is it an additional process ? Is it already part of the MySQL instance ?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.