lp:~percona-dev/percona-server/bug-759688

Created by Laurynas Biveinis on 2011-04-13 and last modified on 2011-04-13
Get this branch:
bzr branch lp:~percona-dev/percona-server/bug-759688
Members of Percona developers can upload to this branch. Log in for directions.

Branch merges

Related bugs

Related blueprints

Branch information

Recent revisions

220. By Laurynas Biveinis on 2011-04-13

Fix build error on debug configuration

219. By Alexey Kopytov on 2011-04-03

Merge from trunk

218. By Alexey Kopytov on 2011-03-31

Bug #744103: Make use of InnoDB fast index creation in mysqldump, ALTER
TABLE and OPTIMIZE TABLE

Initial implementation of innodb_expand_fast_index_creation.patch.

This patch expands the applicability of InnoDB fast index creation to
mysqldump, ALTER TABLE and OPTIMIZE TABLE as follows:

1. mysqldump has now a new option, --innodb-optimize-keys, which changes
the way InnoDB tables are dumped so that secondary and foreign keys are
created after loading the data thus taking advantage of fast index
creation.

This part of the patch is an implementation of the feature request
reported as MySQL bug #49120.

More specifically:

- KEY, UNIQUE KEY and CONSTRAINT specifications are omitted from CREATE
TABLE corresponding to InnoDB tables.

- an additional ALTER TABLE is issued after dumping the data to create
the previously omitted keys.

Delaying foreign key creation does not introduce any additional risks as
mysqldump always prepends its output with SET FOREIGN_KEY_CHECKS=0 anyway.

2. When ALTER TABLE requires a table copy, secondary keys are now dropped
and recreated later after copying the data. The following restrictions
apply:

- only non-unique keys can be involved in this optimization

- if the table contains foreign keys, or a foreign key is being added as
a part of the current ALTER TABLE statement, the optimization is
disabled for all keys.

This part of the patch is an implementation of the feature request
reported as MySQL bug #57583.

3. As OPTIMIZE TABLE is mapped to ALTER TABLE ... ENGINE=InnoDB for
InnoDB tables, it now also benefits from fast index creation with the
same restrictions as for ALTER TABLE.

217. By Alexey Kopytov on 2011-03-31

Fixed a recently introduced compiler warning in innodb_expand_import.patch

216. By Alexey Kopytov on 2011-03-31

Fixed broken percona-support.patch.

215. By Vadim Tkachenko on 2011-03-21

Added README-windows with basic command to build under Windows, VC 2010 Express

214. By Vadim Tkachenko on 2011-03-21

Renamed script to build on Solaris to README-Solaris

213. By Vadim Tkachenko on 2011-03-21

Added helper script for Solaris build.

212. By Ignacio Nin on 2011-03-18

Merge from bugfix branch

211. By Ignacio Nin on 2011-03-18

Merge changes from release branch

Merge release-related canges from release-5.1.55-12.6 that were merged
into 5.1.55 after branching off 5.1.56.

Branch metadata

Branch format:
Branch format 6
Repository format:
Bazaar pack repository format 1 (needs bzr 0.92)
This branch contains Public information 
Everyone can see this information.