Details
Minor
Description
We should output the information that mysql.innodb_table_stats or mysql.innodb_index_stats not found only once and similarly only once the fact that persistent statictics can-t be fetched or recalculated. E.g:
2014-07-22 17:20:53 7f5ee72c1700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2014-07-22 17:20:53 7f5ee72c1700 InnoDB: Error: Fetch of persistent statistics requested for table "new_db"."files_text" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2014-07-22 17:21:03 7f5ebeffd700 InnoDB: Recalculation of persistent statistics requested for table "new_db"."files_text" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2014-07-22 18:12:05 7f31be749700 InnoDB: Error: Table "mysql"."innodb_index_stats" not found.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
revno: 4302
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 10.0-innodb
timestamp: Tue 2014-07-22 19:31:45 +0300
message:
MDEV-6470: Restrict number of error messages about persistent statictic tables not foundIf mysql.innodb_table_stats or mysql.innodb_index_stats is not found or has
unexpected structure output that error only once and no other error for
every table trying to use them. If they do exists, then print fetch or
recalculation errors only once / table or index.