1

Different cardinality after each ALTER TABLE;

There is no new entries in this table. Same error on 10.3.8-MariaDB and 10.2.6 What could cause that?

Also have noticed that

Also this is strange too.

Community
  • 1
Ollie
  • 78

1 Answers1

2

Given that the InnoDB persistent statistics are only an estimate statistic, the values could be expected to change. Increasing innodb_stats_persistent_sample_pages should improve the accuracy.

markusjm
  • 367