I – Table Statistics – Why? When you execute a SQL query that uses an index, creates a join, or another complex operation, MySQL will read the statistics linked to these tables, which will allows it to chose the optimal plan of execution. For InnoDB for example, this behaviour is controlled by innodb_stats_% type variables: show variables LIKE […]