InnoDB Stats Parameters: InnoDB stats parameter controls the indexed column’s index statistics persistent to disk or not persistence to disk There are two options available to control them, Globally and locally at table level. This parameter needs to be tune according to the nature of the application, DML activities against the database and tables, for stable execution plan of the query or for better performance of the query. There are two options are available to store index statistics persistent to disk or non-persistent to disk. Following parameter available for MySQL InnodB stats, starting from MySQL 8. In older version of MySQL such 5.6 and 5.7 innodb_stats_sample_pages was used. Starting form MySQL 8.0 it is deprecated and we have to use innodb_stats_persistent_sample_pages Ref.: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_stats_auto_recalc • innodb_stats_auto_...
Welcome to explore technology about Kubernetes, MySQL, Machine Learning | Deep Learning - Shrenik Parekh