Backup MySQL in a single transaction?
When this option is set to Yes, MySQL backups will be performed in a
single transaction to ensure consistency. However, this can consume more RAM
when backing up a large and changing database. It can also fail with the
error Couldn't execute 'FLUSH TABLES WITH READ LOCK' on some MySQL
versions or Amazon RDS. In this case, you should change this to No
instead.