Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19577

Remove dependency on innodb_autoinc_lock_mode for replication and binary log

    Details

      Description

      In MDEV-17073, Marko Mäkelä suggested that innodb_autoinc_lock_mode may only be needed for statement-based replication:

      Note: Comments in MySQL Bug #50413 suggest that innodb_autoinc_lock_mode settings 0 and 1 are equivalent in this respect. I’d also like to know whether this parameter is at all relevant outside statement-based replication (that is, when innodb_autoinc_lock_mode=2 could be safe to use). With the setting 2, InnoDB does not acquire any auto-increment lock within the transaction. With the settings 0 or 1, InnoDB will hold a lock until the end of the current statement. This would suggest that the setting only matters in statement-based replication.

      He wants to remove the innodb_autoinc_lock_mode system variable. For that to happen, the dependency on this variable would have to be removed for replication and binary logging.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Elkin Andrei Elkin
                Reporter:
                GeoffMontee Geoff Montee
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: