-
Committer:
Oleg Tsarev
-
Date:
2012-01-16 05:47:28 UTC
-
mfrom:
(206.2.3 19957)
-
Revision ID:
zabivator@gmail.com-20120116054728-4oonbhqfzv2ur0hc
Return back Percona's "innodb_stats_method=nulls_ignored" algorithm.
Related Launchpad bug #892405
Related MySQL bug http://bugs.mysql.com/bug.php?id=63320
I added new value "nulls_ignored_exact" for variable innodb_stats_method.
Current upsteam "nulls_ignored" algorithm calculate not_null values on every estimated (random) page, and after that try to approximates total value count.
Unfortunately, this algorithm works incorrectly on mostly null indexes (see MySQL Bug #63320).
Percona'a algorithm excludes from estimation pages with nulls, calculates the count of different values and approximates total value count.
This algorithm works correctly on mostly null indexes, but has limitation - it works correctly just on one-column-key indexes. On compound-keys algorithm can works incorrectly (I didn't test this).
Unfortunately, I can't imagine now how to discard this limitation.