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

[Hrvoje Matijakovic]

[Alexey Kopytov (akopytov)]

- 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

[Alexey Kopytov (akopytov)]

Approved after s/ reports RPM/RPM/.

review: Approve

[Laurynas Biveinis (laurynas-biveinis)]

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

=== 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 @@
 
 Filters 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:
 
-  * ``qc_hit``:
-    The query was found in the query cache.
+  * ``qc_miss``:
+    The query was not found in the query cache.
 
   * ``full_scan``:
     The query performed a full table scan.
@@ -55,7 +55,7 @@
     The query created an implicit internal temporary table.
 
   * ``tmp_table_on_disk``:
-    The query``s temporary table was stored on disk.
+    The query's temporary table was stored on disk.
 
   * ``filesort``:
     The query used a filesort.

=== 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 @@
+.. _maximum_binlog_files:
+
+========================================
+ Restricting the number of binlog files
+========================================
+
+Maximum 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. 
+This 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.
+
+
+Version Specific Information
+============================
+
+  * 5.5.27-29.0:
+    Variable :variable:`max_binlog_files` introduced.
+
+System Variables
+================
+
+.. variable:: max_binlog_files
+
+     :version 5.5.27-29.0: Introduced.
+     :cli: Yes
+     :conf: Yes
+     :scope: Global
+     :dyn: No
+     :vartype: ULONG
+     :default: 0
+     :range: 0-102400
+

=== 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 @@
    flexibility/buff_read_ahead_area
    flexibility/innodb_fast_shutdown
    flexibility/improved_memory_engine
+   flexibility/max_binlog_files
 
 Reliability Improvements
 ========================

=== 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 @@
     PRIMARY KEY (id)
   ) ENGINE=InnoDB;
 
-Insert a row with *HandlerSocket* (fields are separated by tabs): ::
+Insert a row with *HandlerSocket* (fields are separated by comma): ::
 
   $ telnet 127.0.0.1 9999
   Trying 127.0.0.1...
   Connected to 127.0.0.1.
   Escape character is '^]'.
-  P     1	test	t	PRIMARY	id	col
+  P     1	test	t	PRIMARY	id,col
   0	1
   1	+	2	1       test value
   0	1

=== 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 @@
+.. rn:: 5.5.27-29.0
+
+===============================
+ |Percona Server| 5.5.27-29.0
+===============================
+
+Percona 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>`_).
+
+Based 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>`_. 
+
+New Features
+============
+
+  * |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.
+
+  * Number of binlog files can be restricted when using |Percona Server| with the new :variable:`max_binlog_files` option.
+
+Bug Fixes
+=========
+
+  * Fixed server assertion error related to buffer pool, only visible in debug builds. Bug fixed :bug:`905334` (*Stewart Smith*).
+
+  * 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*).
+
+  * 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*).
+
+  * 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*).
+
+  * 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*).
+
+  * 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*).
+
+  * 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*).
+
+  * The binlog shouldn't be rotated while it contains XA transactions in the PREPARED state. Bug fixed :bug:`1036040` (*Stewart Smith*).
+
+  * 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*).
+
+  * 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*).
+