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.