lp:~percona-dev/percona-server/5.5.10

Created by Yasufumi Kinoshita on 2011-03-23 and last modified on 2011-04-12
Get this branch:
bzr branch lp:~percona-dev/percona-server/5.5.10
Members of Percona developers can upload to this branch. Log in for directions.

Branch merges

Related bugs

Related blueprints

Branch information

Recent revisions

95. By Ignacio Nin on 2011-04-12

Merge from release branch

Include changes from release branch in main branch. This includes
HandlerSocket and the UDF functions.

93. 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.

92. By Ignacio Nin on 2011-03-28

Merge text changes to test results

91. By Oleg Tsarev on 2011-03-23

Port Oleg and Alexey patches to 5.5.10

90. By Yasufumi Kinoshita <kinoyasu@rynex6> on 2011-03-23

Yasufumi patches are ported to 5.5.10; Note: option innodb_stats_method was removed from innodb_stats.patch, because implemented officially. And, bug733317 should be fixed before release

89. By Oleg Tsarev on 2011-03-22

The Laurynas's patch (bug #589491)
Add counters into SHOW PROCESSLIST for Rows_examined, Rows_sent, Rows_read
Need documentation update, patch name: processlist_row_stats.patch
Added three new columns to SHOW PROCESSLIST

88. By Yasufumi Kinoshita <kinoyasu@rynex6> on 2011-03-08

fix bug721611 (rename variables)

87. By kinoyasu <kinoyasu@gauntlet4> on 2011-03-03

fix bug727704. -- bug716575 is not for 5.5.x. I dont remember when I fixed already

86. By Oleg Tsarev on 2011-03-02

Fix bug #724674

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.