Merge lp:~hrvojem/percona-server/rn-5.1.66-14.2 into lp:percona-server/5.1

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Stewart Smith
Approved revision: 504
Merged at revision: 509
Proposed branch: lp:~hrvojem/percona-server/rn-5.1.66-14.2
Merge into: lp:percona-server/5.1
Diff against target: 62 lines (+47/-0)
2 files modified
doc/source/performance/innodb_fast_checksum.rst (+5/-0)
doc/source/release-notes/Percona-Server-5.1.66-14.2.rst (+42/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.1.66-14.2
Reviewer Review Type Date Requested Status
Stewart Smith (community) Approve
Review via email: mp+139875@code.launchpad.net
To post a comment you must log in.
Stewart Smith (stewart) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/performance/innodb_fast_checksum.rst'
2--- doc/source/performance/innodb_fast_checksum.rst 2012-04-02 07:06:54 +0000
3+++ doc/source/performance/innodb_fast_checksum.rst 2012-12-14 11:54:42 +0000
4@@ -4,6 +4,11 @@
5 Fast |InnoDB| Checksum
6 ========================
7
8+.. warning::
9+
10+ This feature has been deprecated after |Percona Server| :rn:`5.1.66-14.2`.
11+
12+
13 |InnoDB| writes a checksum at the end of each data page in order to detect data files corruption. However computing this checksum requires CPU cycles and in some circumstances this extra overhead can become significant.
14
15 |XtraDB| can use a more CPU-efficient algorithm, based on 4-byte words, which can be beneficial for some workloads (for instance write-heavy workloads on servers that can perform lots of IO).
16
17=== added file 'doc/source/release-notes/Percona-Server-5.1.66-14.2.rst'
18--- doc/source/release-notes/Percona-Server-5.1.66-14.2.rst 1970-01-01 00:00:00 +0000
19+++ doc/source/release-notes/Percona-Server-5.1.66-14.2.rst 2012-12-14 11:54:42 +0000
20@@ -0,0 +1,42 @@
21+.. rn:: 5.1.66-14.2
22+
23+=================================================
24+ |Percona Server| 5.1.66-14.2 [not yet released]
25+=================================================
26+
27+Based on `MySQL 5.1.66 <http://dev.mysql.com/doc/refman/5.1/en/news-5-1-66.html>`_, this release will include all the bug fixes in it. All of |Percona|'s software is open-source and free, all the details of the release can be found in the `5.1.66-14.2 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.1.66-14.2>`_.
28+
29+New Features
30+============
31+
32+ :ref:`handlersocket_page` has been updated to version 1.1.0 (rev. 83d8f3af176e1698acd9eb3ac5174700ace40fe0).
33+
34+ :ref:`innodb_fast_checksum_page` feature has now been deprecated.
35+
36+ :ref:`innodb_fake_changes_page` has been improved by fetching the sibling pages.
37+
38+Bug Fixes
39+=========
40+
41+ ``Rows_read`` was calculated in a way which lead to a negative value being printed in the slow query log. Fixed by making ``Rows_read`` to be a synonym for ``Rows_examined`` in the slow query log. Bug fixed :bug:`830286` (*Alexey Kopytov*).
42+
43+ Fixed the package dependencies for CentOS 6, that caused conflicts during the install. Bug fixed :bug:`908620` (*Ignacio Nin*).
44+
45+ :variable:`innodb_fake_changes` would allocate too many extents on ``UPDATE``. In some cases this could cause infinite loop. Bug fixed :bug:`917942` (*Mark Callaghan*, *Laurynas Biveinis*).
46+
47+ Crash-resistant replication would break with binlog XA transaction recovery. If a crash would happened between XA PREPARE and COMMIT stages, the prepared |InnoDB| transaction would not have the slave position recorded and thus would fail to update it once it is replayed during binlog crash recovery. Bug fixed :bug:`1012715` (*Laurynas Biveinis*).
48+
49+ Although fake change transactions downgrade the requested exclusive (X) row locks to shared (S) locks, these S locks prevent X locks from being taken and block the real changes. This fix introduces a new option :variable:`innodb_locking_fake_changes` which, when set to ``FALSE``, makes fake transactions not to take any row locks. Bug fixed :bug:`1064326` (*Mark Callaghan*, *Laurynas Biveinis*).
50+
51+ Fake changes were increasing the changed row and userstat counters. Bug fixed :bug:`1064333` (*Laurynas Biveinis*).
52+
53+ Temporary files created by binary log cache were not purged after transaction commit. Fixed by truncating the temporary file, if used for a binary log transaction cache, when committing or rolling back a statement or a transaction. Bug fixed :bug:`1070856` (*Alexey Kopytov*).
54+
55+ There is no need to scan buffer pool for AHI entries after the B-trees for the tablespace have been dropped, as that will already clean them. Bug fixed :bug:`1076215` (*Laurynas Biveinis*).
56+
57+ When :command:`mysqldump` was used with :option:`--innodb-optimize-keys`, it did not handle composite indexes correctly when verifying if the optimization is applicable with respect to ``AUTO_INCREMENT`` columns. Bug fixed :bug:`1039536` (*Alexey Kopytov*).
58+
59+ In cases where indexes with ``AUTO_INCREMENT`` columns where correctly detected, :command:`mysqldump` prevented all such keys from optimization, even though it is sufficient to skip just one (e.g. the first one). Bug fixed :bug:`1081003` (*Alexey Kopytov*).
60+
61+Other bug fixes: bug fixed :bug:`719386` (*Alexey Kopytov*), bug fixed :bug:`890404` (*Laurynas Biveinis*), bug fixed :bug:`1061118` (*Hrvoje Matijakovic*).
62+

Subscribers

People subscribed via source and target branches