Comments on: What is innodb_autoinc_lock_mode? https://www.percona.com/blog/what-is-innodb_autoinc_lock_mode-and-why-should-i-care/ Sun, 26 Apr 2020 15:26:58 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Eugene Kazakov https://www.percona.com/blog/what-is-innodb_autoinc_lock_mode-and-why-should-i-care/#comment-10972161 Sun, 26 Apr 2020 15:26:58 +0000 https://www.percona.com/blog/?p=44388#comment-10972161 In reply to Jake.

The mixed format uses row-based replication for any statements that are unsafe for statement-based replication, i.e. all of the auto-increment lock modes are safe with this format.

]]> By: Jake https://www.percona.com/blog/what-is-innodb_autoinc_lock_mode-and-why-should-i-care/#comment-10972081 Sat, 11 Apr 2020 21:12:52 +0000 https://www.percona.com/blog/?p=44388#comment-10972081 What is recommended value of innodb_autoinc_lock_mode in combination with BINLOG_FORMAT=MIXED?

]]>