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

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

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.

Merged branch lp://staging/~percona-dev/percona-server/release-5.5.10-20.1

94. By Alexey Kopytov on 2011-04-03

Merge from lp:percona-server/5.5

Merged branch lp://staging/~percona-dev/percona-server/5.5-bug744103

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

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.

Merged branch lp://staging/~percona-dev/percona-server/5.5.10-fix_bug733317

Bug #733317: SYS_STATS internal table should be expanded for the official innodb_stats_method support

92. By Ignacio Nin on 2011-03-28

Merge text changes to test results

Merged branch lp://staging/~percona-dev/percona-server/5.5.10-test-text-changes

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