lp:~tsarev/percona-server/18205_07_slave_type_conversions_error_on_truncate.patch-refactoring

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

217. By Oleg Tsarev on 2012-02-15

I renamed <name>_truncated methods to <name>, and "truncated" argument now has default value (0). I removed <name> methods, because their usage exactly correlate with new methods.

216. By Oleg Tsarev on 2012-02-15

update from lp:~tsarev/percona-server/18205_05_slave_type_conversions_error_on_truncate.patch

215. By Oleg Tsarev on 2012-02-12

Fixed code policy in replication_slave_skip_columns.patch

214. By Oleg Tsarev on 2012-02-12

Fixed code policy in slave_type_conversions_error_on_truncate.patch

213. By Oleg Tsarev on 2012-02-12

Fixed code policy in wl5151.patch. Added missed comments.

212. By Oleg Tsarev on 2012-02-10

Fixed code policy in wl47.patch.
Moved related tests and tests fixes from mysql-test-run.diff to wl47.patch.
Added (missed before) results for tests rpl.rpl_row_annotate_do, rpl.rpl_row_annotate_dont, binlog.binlog_row_annotate.

211. By Oleg Tsarev on 2012-02-07

merge lp:~tsarev/percona-server/18205_01_mysqlbinlog_fix.patch

210. By Oleg Tsarev on 2012-02-05

lp:~tsarev/percona-server/18205_02_wl36.patch

209. By Oleg Tsarev on 2012-02-05

merge lp:~tsarev/percona-server/18205_01_mysqlbinlog_fix.patch

208. By Oleg Tsarev on 2012-01-16

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.