innodb_stats_auto_recalc
Fun fact: disabling this will fuck up join optimizer. Since it doesn’t have the InnoDB stats, the optimizer can wrongly estimate the usage of certain indexes. I disabled this option when remaking a MariaDB 10.3 server. The problem is not that you don’t see anymore the InnoDB rows estimate, but same queries that worked fine … Read more