content_image/740188.jpg content_image/740193.jpg content_image/740197.jpg
<img src='content_image/740188.jpg'>

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 

<img src='content_image/740193.jpg'>

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 

<img src='content_image/740197.jpg'>

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” . 

