MySQL Forums
Forum List  »  Stored Procedures

Re: Count Table rows using Stored Procedure
Posted by: Peter Brawley
Date: February 12, 2018 11:08AM

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, “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.

Options: ReplyQuote

Written By
Re: Count Table rows using Stored Procedure
February 12, 2018 11:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.