lp:~akopytov/percona-server/bugs-1039536-1081003-5.1

Created by Alexey Kopytov on 2012-11-20 and last modified on 2012-11-20
Get this branch:
bzr branch lp:~akopytov/percona-server/bugs-1039536-1081003-5.1
Only Alexey Kopytov can upload to this branch. If you are Alexey Kopytov please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information

Recent revisions

503. By Alexey Kopytov on 2012-11-20

Bug #1039536: mysqldump --innodb-optimize-keys can generate invalid
              table definitions
Bug #1081003: mysqldump --innodb-optimize-keys handles AUTO_INCREMENT
              columns inefficiently

The problem in bug #1039536 was that mysqldump --innodb-optimize-keys
did not handle composite indexes correctly when verifying if the
optimization is applicable with respect to AUTO_INCREMENT columns. When
an AUTO_INCREMENT column was encountered in the SHOW CREATE TABLE
output, the column was marked so that subsequent index specifications
involving that column would not be used in deferred index creation
mechanism, as MySQL does not allow creating tables with unindexed
AUTO_INCREMENT columns. However, the code checking if an index
specification involves a previously marked AUTO_INCREMENT column failed
to handle composite keys correctly, so those keys were optimized away
resulting in an invalid table definition.

A closely related problem in bug #1081003 was that even in cases where
indexes with AUTO_INCREMENT columns where correctly detected, mysqldump
prevented all such keys from optimization, even though it is sufficient
to skip just one (e.g. the first one).

Fixed by refactoring the AUTO_INCREMENT handling code in mysqldump
--innodb-optimize-keys to:

- process composite keys correctly

- prevent only the first key indexing an AUTO_INCREMENT columns from
  optimization

- use a simple pointer instead of the hash table to keep track of
  AUTO_INCREMENT column with a simple pointer, as the server only allows
  one such column per table anyway

502. By Stewart Smith on 2012-11-16

merge fix for Bug #719386: Query_time is increasing for every query a stored procedure logs to the slow log

501. By Stewart Smith on 2012-11-16

merge fi xfor Bug #1064326: Fake changes blocking real changes due to locking

500. By Stewart Smith on 2012-11-16

merge fix for Bug #890404: valgrind warning from innodb_fake_changes patch

499. By Stewart Smith on 2012-11-16

merge introduction of debian dbg packages

498. By Stewart Smith on 2012-11-16

merge packaging fixes: bug 908620

497. By Stewart Smith on 2012-11-16

merge
PS5.1 Deprecate innodb_fast_checksum

496. By Stewart Smith on 2012-11-16

merge fix for Bug #1012715: Crash resistant replication breaks with binlog XA transaction recovery

495. By Hrvoje Matijakovic on 2012-10-31

Bug fix for Bug#1056658

494. By Stewart Smith on 2012-10-23

merge 5.1.66-14.1 release notes

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
lp:percona-server/5.5
This branch contains Public information 
Everyone can see this information.

Subscribers