Link You Today
Bookmark your Free, Libre software & tech link

Updating InnoDB Table Statistics Manually

mariadb, mysql, percona

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.

Link