innodb_spin_wait_pause_multiplier innodb_stats_auto_recalc innodb_stats_include_delete_marked innodb_stats_method innodb_stats_on_metadata innodb_stats_persistent innodb_stats_persistent_sample_pages innodb_stats_sample_pages innodb_stats_transient_sample_pages Section 15.8.8, “Configuring Spin Lock Polling” Section 15.14, “InnoDB Startup Options and System Variables” Section 1.3, “What Is New in MySQL 8.0” Section 15.8.10, “Configuring Optimizer Statistics for InnoDB” Section 13.1.20, “CREATE TABLE Statement” Section 15.14, “InnoDB Startup Options and System Variables” Configuring Automatic Statistics Calculation for Persistent Optimizer Statistics Configuring Optimizer Statistics Parameters for Individual Tables InnoDB Persistent Statistics Tables Example Including Delete-marked Records in Persistent Statistics Calculations Section 15.14, “InnoDB Startup Options and System Variables” Section 8.3.8, “InnoDB and MyISAM Index Statistics Collection” Section 15.14, “InnoDB Startup Options and System Variables” MySQL Glossary Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters” Section 15.14, “InnoDB Startup Options and System Variables” Section 13.7.3.1, “ANALYZE TABLE Statement” Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters” Section 15.8.10, “Configuring Optimizer Statistics for InnoDB” Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters” Section 13.1.15, “CREATE INDEX Statement” Section 13.1.20, “CREATE TABLE Statement” Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables” Section 15.14, “InnoDB Startup Options and System Variables” Section 8.5.10, “Optimizing InnoDB for Systems with Many Tables” Section 13.7.3.1, “ANALYZE TABLE Statement” Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables” Section 15.14, “InnoDB Startup Options and System Variables” Configuring Optimizer Statistics Parameters for Individual Tables Configuring Optimizer Statistics Parameters for Individual Tables Configuring the Number of Sampled Pages for InnoDB Optimizer Statistics Section 15.14, “InnoDB Startup Options and System Variables” Section 13.7.3.1, “ANALYZE TABLE Statement” Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters” 6073