mysql> select variable_value from information_schema.global_status where variable_name like 'Slave_open_temp_tables';
+----------------+
| variable_value |
+----------------+
| 0 |
+----------------+
1 row in set (0,00 sec)
Restricting the number of retries IMHO makes no sense in that the backup is not fit for PIT recovery in any case.
Restricting the number of retries makes sense when you fail with an error, not making a backup, after x retries.
mysql> select variable_value from information_ schema. global_ status where variable_name like 'Slave_ open_temp_ tables' ;
+----------------+
| variable_value |
+----------------+
| 0 |
+----------------+
1 row in set (0,00 sec)
Restricting the number of retries IMHO makes no sense in that the backup is not fit for PIT recovery in any case.
Restricting the number of retries makes sense when you fail with an error, not making a backup, after x retries.
Retry delay should be configureable.