Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.22
-
CentOS 7 x86_64
Description
I have MariaDB replica server for making consistent database dumps, and after the latest update I noticed that mysqldump with --single-transaction option does not stop applying binary logs, e.g. Seconds_Behind_Master not increasing and Exec_Master_Log_Pos counter increasing during dump. I have all data in INNODB tables, and such --single-transaction behaviour looks odd. My mysqldump options are:
--force --quick --single-transaction --routines --triggers
Changing --single-transaction to --lock-all-tables - locking tables, and I see correct blocking database from changes during mysqldump.
Please check current mysqldump with --single-transaction option behaviour.