InnoDB System Variables Maximum Value ( ≥  8.0.14) 1000 The maximum delay between polls for a spin lock. The low-level implementation of this mechanism varies depending on the combination of hardware and operating system, so the delay does not correspond to a fixed time interval. Can be used in combination with the  innodb_spin_wait_pause_multiplier  variable for greater control over the duration of spin-lock polling delays. For more information, see Section 15.8.8, “Configuring Spin Lock Polling” . • innodb_spin_wait_pause_multiplier Command-Line Format --innodb-spin-wait-pause-multiplier=# Introduced 8.0.16 System Variable innodb_spin_wait_pause_multiplier Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 50 Minimum Value 1 Maximum Value 100 Defines a multiplier value used to determine the number of PAUSE instructions in spin-wait loops that occur when a thread waits to acquire a mutex or rw-lock. For more information, see Section 15.8.8, “Configuring Spin Lock Polling” . • innodb_stats_auto_recalc Command-Line Format --innodb-stats-auto-recalc[={OFF|ON}] System Variable innodb_stats_auto_recalc Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value ON Causes  InnoDB  to automatically recalculate persistent statistics after the data in a table is changed substantially. The threshold value is 10% of the rows in the table. This setting applies to tables created when the  innodb_stats_persistent  option is enabled. Automatic statistics recalculation may also be configured by specifying  STATS_PERSISTENT=1  in a  CREATE TABLE  or  ALTER TABLE  statement. The amount of data sampled to produce the statistics is controlled by the innodb_stats_persistent_sample_pages  variable. For more information, see Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters” . 3282