Re: Count Table rows using Stored Procedure

[Peter Brawley]

The provided link is valid & live, says in part ...

"Optimizer statistics are not persisted to disk when innodb_stats_persistent is disabled or when individual tables are created or altered with STATS_PERSISTENT=0. For more information, see Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”.

"When innodb_stats_on_metadata is enabled, InnoDB updates non-persistent statistics when metadata statements such as SHOW TABLE STATUS or when accessing the INFORMATION_SCHEMA.TABLES or INFORMATION_SCHEMA.STATISTICS tables. (These updates are similar to what happens for ANALYZE TABLE.) When disabled, InnoDB does not update statistics during these operations. Leaving the setting disabled can improve access speed for schemas that have a large number of tables or indexes. It can also improve the stability of execution plans for queries that involve InnoDB tables."

Consider reading about all settings there whose names like 'innodb_stat%'.



Edited 1 time(s). Last edit at 02/12/2018 02:08PM by Peter Brawley.