My Oracle Support Banner

How can backup tool (mysqlbackup, mysqldump) block other session's queries ? (Doc ID 2222462.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

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

Symptoms

 mysqlbackup or mysqldump can block following DML at specific circumstance.

Cause

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
Symptoms
Cause
 General use of 'FLUSH TABLES WITH READ LOCK'
 
 Case 1 "mysqlbackup"
 Case 2 "mysqldump"
Solution
References


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