Excessive Lock Time With Large History List Length And Repeated "Switching to log file" Log Messages (Doc ID 2179642.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Enterprise Backup - Version 3.12 and later
Information in this document applies to any platform.

Symptoms

The amount of time the lock is held during a backup is much longer than usual.

The backup log contains information similar to:

 

Eventually the backup may fail as too much redo log has been generated.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms