InnoDB System Variables SET_VAR  Hint Applies No Type Integer Default Value 64 Minimum Value 1 Maximum Value 1000 The increment size (in megabytes) for extending the size of an auto-extending  InnoDB  system tablespace file when it becomes full. The default value is 64. For related information, see System Tablespace Data File Configuration, and Resizing the System Tablespace. The  innodb_autoextend_increment  setting does not affect file-per-table tablespace files or general tablespace files. These files are auto-extending regardless of the  innodb_autoextend_increment setting. The initial extensions are by small amounts, after which extensions occur in increments of 4MB. Command-Line Format --innodb-autoinc-lock-mode=# System Variable innodb_autoinc_lock_mode Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value 2 Valid Values 0 1 2 The lock mode to use for generating auto-increment values. Permissible values are 0, 1, or 2, for traditional, consecutive, or interleaved, respectively. The default setting is 2 (interleaved) as of MySQL 8.0, and 1 (consecutive) before that. The change to interleaved lock mode as the default setting reflects the change from statement-based to row-based replication as the default replication type, which occurred in MySQL 5.7. Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not sensitive to the execution order of SQL statements. For the characteristics of each lock mode, see InnoDB AUTO_INCREMENT Lock Modes. • innodb_background_drop_list_empty • innodb_autoinc_lock_mode Command-Line Format --innodb-background-drop-list- empty[={OFF|ON}] System Variable innodb_background_drop_list_empty Scope Global Dynamic Yes SET_VAR  Hint Applies No 3220