Percona Server moved to https://jira.percona.com/projects/PS

Merge lp:~hrvojem/percona-server/rn-5.5.27-29.0 into lp:percona-server/5.5

  1. rn-5.5.27-29.0
  2. Merge into 5.5
Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Alexey Kopytov
Approved revision: no longer in the source branch.
Merged at revision: 314
Proposed branch: lp:~hrvojem/percona-server/rn-5.5.27-29.0
Merge into: lp:percona-server/5.5
Diff against target: 135 lines (+76/-5)
5 files modified
doc/source/diagnostics/slow_extended_55.rst (+3/-3)
doc/source/flexibility/max_binlog_files.rst (+30/-0)
doc/source/index.rst (+1/-0)
doc/source/performance/handlersocket.rst (+2/-2)
doc/source/release-notes/Percona-Server-5.5.27-29.0.rst (+40/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.5.27-29.0
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Needs Fixing
Alexey Kopytov (community) Approve
Review via email: mp+128722@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) wrote :

- s/hash index/adaptive hash index/, s/partition sizes are allocated initially/partition sizes are calculated initially/

- s/Fixed by using different SSL library for building the packages/Fixed by building RPM packages with OpenSSL support rather than the bundled YaSSL library/

- s/Flashcache would throw an error/Flashcache support resulted in confusing messages in the error log/

- I suggest the following text for bug #1042517:

Custom server builds would crash when compiled with a non-default maximum number of indexes per table. Upstream MySQL bugs: `#54127 <http://bugs.mysql.com/bug.php?id=54127>`_, `#61178 <http://bugs.mysql.com/bug.php?id=61178>`_, `#61179 <http://bugs.mysql.com/bug.php?id=61179>`_ and `#61180 <http://bugs.mysql.com/bug.php?id=61180>`_. Bug fixed :bug:`1042517` (*Sergei Glushchenko*).

review: Needs Fixing
Revision history for this message
Alexey Kopytov (akopytov) wrote :

Approved after s/ reports RPM/RPM/.

review: Approve
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

For bug 1013644, let's say that the innodb-sys-stats-root-page is a debugging variable only present in debug builds. Or we might get questions about it :)

review: Needs Fixing

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc/source/diagnostics/slow_extended_55.rst'
--- doc/source/diagnostics/slow_extended_55.rst 2012-09-18 05:04:43 +0000
+++ doc/source/diagnostics/slow_extended_55.rst 2012-10-09 15:13:33 +0000
@@ -42,8 +42,8 @@
4242
43Filters the slow log by the query's execution plan. The value is a comma-delimited string, and can contain any combination of the following values:43Filters the slow log by the query's execution plan. The value is a comma-delimited string, and can contain any combination of the following values:
4444
45 * ``qc_hit``:45 * ``qc_miss``:
46 The query was found in the query cache.46 The query was not found in the query cache.
4747
48 * ``full_scan``:48 * ``full_scan``:
49 The query performed a full table scan.49 The query performed a full table scan.
@@ -55,7 +55,7 @@
55 The query created an implicit internal temporary table.55 The query created an implicit internal temporary table.
5656
57 * ``tmp_table_on_disk``:57 * ``tmp_table_on_disk``:
58 The query``s temporary table was stored on disk.58 The query's temporary table was stored on disk.
5959
60 * ``filesort``:60 * ``filesort``:
61 The query used a filesort.61 The query used a filesort.
6262
=== added file 'doc/source/flexibility/max_binlog_files.rst'
--- doc/source/flexibility/max_binlog_files.rst 1970-01-01 00:00:00 +0000
+++ doc/source/flexibility/max_binlog_files.rst 2012-10-09 15:13:33 +0000
@@ -0,0 +1,30 @@
1.. _maximum_binlog_files:
2
3========================================
4 Restricting the number of binlog files
5========================================
6
7Maximum number of binlog files can now be restricted in |Percona Server| with :variable:`max_binlog_files`. This means maximum disk usage of binlogs can be set rather than time.
8This option can be combined with already existing :variable:`expire_logs_days` as they are both taken into the account when rotating the binlog. For example if :variable:`expire_logs_days` is set to 10 days and :variable:`max_binlog_files` to 1GB, if binlog reaches 1GB it will be rotated, or if it hasn't been rotated for 10 days it will be rotated.
9
10
11Version Specific Information
12============================
13
14 * 5.5.27-29.0:
15 Variable :variable:`max_binlog_files` introduced.
16
17System Variables
18================
19
20.. variable:: max_binlog_files
21
22 :version 5.5.27-29.0: Introduced.
23 :cli: Yes
24 :conf: Yes
25 :scope: Global
26 :dyn: No
27 :vartype: ULONG
28 :default: 0
29 :range: 0-102400
30
031
=== modified file 'doc/source/index.rst'
--- doc/source/index.rst 2012-09-27 09:13:48 +0000
+++ doc/source/index.rst 2012-10-09 15:13:33 +0000
@@ -90,6 +90,7 @@
90 flexibility/buff_read_ahead_area90 flexibility/buff_read_ahead_area
91 flexibility/innodb_fast_shutdown91 flexibility/innodb_fast_shutdown
92 flexibility/improved_memory_engine92 flexibility/improved_memory_engine
93 flexibility/max_binlog_files
9394
94Reliability Improvements95Reliability Improvements
95========================96========================
9697
=== modified file 'doc/source/performance/handlersocket.rst'
--- doc/source/performance/handlersocket.rst 2012-09-27 09:13:48 +0000
+++ doc/source/performance/handlersocket.rst 2012-10-09 15:13:33 +0000
@@ -75,13 +75,13 @@
75 PRIMARY KEY (id)75 PRIMARY KEY (id)
76 ) ENGINE=InnoDB;76 ) ENGINE=InnoDB;
7777
78Insert a row with *HandlerSocket* (fields are separated by tabs): ::78Insert a row with *HandlerSocket* (fields are separated by comma): ::
7979
80 $ telnet 127.0.0.1 999980 $ telnet 127.0.0.1 9999
81 Trying 127.0.0.1...81 Trying 127.0.0.1...
82 Connected to 127.0.0.1.82 Connected to 127.0.0.1.
83 Escape character is '^]'.83 Escape character is '^]'.
84 P 1 test t PRIMARY id col84 P 1 test t PRIMARY id,col
85 0 185 0 1
86 1 + 2 1 test value86 1 + 2 1 test value
87 0 187 0 1
8888
=== added file 'doc/source/release-notes/Percona-Server-5.5.27-29.0.rst'
--- doc/source/release-notes/Percona-Server-5.5.27-29.0.rst 1970-01-01 00:00:00 +0000
+++ doc/source/release-notes/Percona-Server-5.5.27-29.0.rst 2012-10-09 15:13:33 +0000
@@ -0,0 +1,40 @@
1.. rn:: 5.5.27-29.0
2
3===============================
4 |Percona Server| 5.5.27-29.0
5===============================
6
7Percona is glad to announce the release of |Percona Server| 5.5.27-29.0 on October 11th, 2012 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.27-29.0/>`_ and from the `Percona Software Repositories <http://www.percona.com/docs/wiki/repositories:start>`_).
8
9Based on `MySQL 5.5.27 <http://dev.mysql.com/doc/refman/5.5/en/news-5-5-27.html>`_, including all the bug fixes in it, |Percona Server| 5.5.27-29.0 is now the current stable release in the 5.5 series. All of |Percona|'s software is open-source and free, all the details of the release can be found in the `5.5.27-29.0 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.5.27-29.0>`_.
10
11New Features
12============
13
14 * |Percona Server| now supports :ref:`changed_page_tracking`. This feature will be used for implementing faster incremental backups that use this information to avoid full data scans.
15
16 * Number of binlog files can be restricted when using |Percona Server| with the new :variable:`max_binlog_files` option.
17
18Bug Fixes
19=========
20
21 * Fixed server assertion error related to buffer pool, only visible in debug builds. Bug fixed :bug:`905334` (*Stewart Smith*).
22
23 * Fix for bug :bug:`978036` introduced the :variable:`innodb_sys_stats_root_page` option, rendering the previously-existing innodb_sys_stats option its prefix. As such, it became unsettable from command line. Fixed by renaming :variable:`innodb_sys_stats_root_page` to :variable:`innodb_persistent_stats_root_page`. Bug fixed :bug:`1013644` (*Laurynas Biveinis*).
24
25 * Multiple adaptive hash index partitions would cause overly large hash index. Fixed by changing the way partition sizes are calculated initially. Bug fixed :bug:`1018264` (*George Ormond Lorch III*).
26
27 * Postfix would crash on CentOS/RHEL 6.x when using shared dependency (``libmysqlclient.so``). Fixed by building packages with OpenSSL support rather than the bundled YaSSL library. Bug fixed :bug:`1028240` (*Ignacio Nin*).
28
29 * Fixed the issue where LRU dump would hold LRU_list_mutex during the entire dump process. Now the mutex is periodically released in order not to block server while the dump is in progress. Bug fixed :bug:`686534` (*George Ormond Lorch III*).
30
31 * Option :variable:`expire_logs_days` was broken by group_commit patch introduced in |Percona Server| :rn:`5.5.18-23.0`. Bug fixed :bug:`1006214` (*Stewart Smith*).
32
33 * Fixed issue where :variable:`innodb_blocking_lru_restore` did not take an optional bool argument similar to other bool options. Bug fixed :bug:`881001` (*George Ormond Lorch III*).
34
35 * The binlog shouldn't be rotated while it contains XA transactions in the PREPARED state. Bug fixed :bug:`1036040` (*Stewart Smith*).
36
37 * Flashcache support resulted in confusing messages in the error log on |Percona Server| startup even when flashcache was not used. This was fixed by adding new variable :variable:`have_flashcache`. When set to 0 (default), flashcache checks are disabled and when set to 0 checks are enabled. Bug fixed :bug:`747032` (*Sergei Glushchenko*).
38
39 * Custom server builds would crash when compiled with a non-default maximum number of indexes per table. Upstream MySQL bugs: `#54127 <http://bugs.mysql.com/bug.php?id=54127>`_, `#61178 <http://bugs.mysql.com/bug.php?id=61178>`_, `#61179 <http://bugs.mysql.com/bug.php?id=61179>`_ and `#61180 <http://bugs.mysql.com/bug.php?id=61180>`_. Bug fixed :bug:`1042517` (*Sergei Glushchenko*).
40

Subscribers

People subscribed via source and target branches