Updating InnoDB Table Statistics Manually.md 526 B
Title: "Updating InnoDB Table Statistics Manually" Date: 2017-11-16 12:23:08 Categories: [data base] tags: [mysql, mariadb, percona]
Authors: sedlav
In this post, we will discuss how to fix cardinality for InnoDB tables manually.
As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default.