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

[Hrvoje Matijakovic]

[Laurynas Biveinis (laurynas-biveinis)]

For bug 1038225, an user-relevant description would be "Percona Server 5.5.27-28.0 would crash or deadlock in XtraDB buffer pool code. This was caused by incorrect mutex handling in recently introduced InnoDB code." or similar.

review: Needs Fixing

[Laurynas Biveinis (laurynas-biveinis)]

review: Approve

=== modified file 'doc/source/conf.py'
--- doc/source/conf.py	2012-08-24 06:31:08 +0000
+++ doc/source/conf.py	2012-09-03 13:35:24 +0000
@@ -54,7 +54,7 @@
 # The short X.Y version.
 version = '5.5'
 # The full version, including alpha/beta/rc tags.
-release = '5.5.27-28.0'
+release = '5.5.27-28.1'
 
 # The language for content autogenerated by Sphinx. Refer to documentation
 # for a list of supported languages.

=== modified file 'doc/source/diagnostics/innodb_show_lock_names.rst'
--- doc/source/diagnostics/innodb_show_lock_names.rst	2011-10-07 23:38:41 +0000
+++ doc/source/diagnostics/innodb_show_lock_names.rst	2012-09-03 13:35:24 +0000
@@ -4,11 +4,11 @@
  Show Lock Names
 =================
 
-This feature is curently undocumented except for the following example.
+This feature is currently undocumented except for the following example.
 
 Example: ::
 
-  mysql> show mutex status;
+  mysql> SHOW ENGINE INNODB MUTEX;
   +--------+---------------------------+---------------+
   | Type   | Name                      | Status        |
   +--------+---------------------------+---------------+

=== modified file 'doc/source/management/expanded_program_option_modifiers.rst'
--- doc/source/management/expanded_program_option_modifiers.rst	2012-08-22 14:34:42 +0000
+++ doc/source/management/expanded_program_option_modifiers.rst	2012-09-03 13:35:24 +0000
@@ -7,17 +7,26 @@
 |MySQL| has the concept of `options modifiers <http://dev.mysql.com/doc/refman/5.5/en/option-modifiers.html>`_ which is a simple way to modify either the way that |MySQL| interprets an option or the way the option behaves. Option modifiers are used by simply prepending the name of the modifier and a dash "-" before the actual configuration option name. For example specifying --maximum-query_cache_size=4M on the mysqld commad line or specifying maximum-query_cache_size=4M in the :file:`my.cnf` will prevent any client from setting the :variable:`query_cache_size` value larger than 4MB.
 
 Currently MySQL supports five existing option modifiers:
-  * disable: disables or ignores option_name.
-  * enable: enables option_name.
-  * loose: mysqld will not exit with an error if it does not recognize option_name, but instead it will issue only a warning.
-  * maximum: indicates that a client can not set the value of option_name greater than the limit specified. If the client does attempt to set the value of option_name greater than the limit, the option_name will simply be set to the defined limit.
-  * skip: skips or ignores option_name.
+  * disable [disable-<option_name>] disables or ignores option_name.
+  * enable [enable-<option_name>] enables option_name.
+  * loose [loose-<option_name>] - mysqld will not exit with an error if it does not recognize option_name, but instead it will issue only a warning.
+  * maximum [maximum-<option_name>=<value>] indicates that a client can not set the value of option_name greater than the limit specified. If the client does attempt to set the value of option_name greater than the limit, the option_name will simply be set to the defined limit.
+  * skip [skip-<option_name>] skips or ignores option_name.
 
 In order to offer more control over option visibility, access and range limits, the following new option modifiers have been added by |Percona Server|:
   * minimum [minimum-<option_name>=<value>] indicates that clients can not set the value of option_name to less than the limit specified. If the client does attempt to set the value of option_name lesser than the limit, the option_name will simply be set to the defined limit.
   * hidden [hidden-<option_name>=<TRUE/FALSE>] indicates that clients can not see or modify the value of option_name.
   * readonly [readonly-<option_name>=<TRUE/FALSE>] indicates that clients can see the value of option_name but can not modify the value.
 
+Combining the options
+=====================
+
+Some of the option modifiers may be used together in the same option specification, example: ::
+
+ --skip-loose-<option_name>
+ --loose-readonly-<option_name>=<T/F>
+ --readonly-<option_name>=<T/F> 
+ --hidden-<option_name>=<T/F>
 
 Version Specific Information
 ============================

=== modified file 'doc/source/management/utility_user.rst'
--- doc/source/management/utility_user.rst	2012-08-22 14:34:42 +0000
+++ doc/source/management/utility_user.rst	2012-09-03 13:35:24 +0000
@@ -52,7 +52,7 @@
 .. variable:: utility_user
 
      :version 5.5.27-28.0: Implemented
-     :cli: No
+     :cli: Yes
      :conf: utility_user=<user@host>
      :scope: Global
      :dyn: No
@@ -64,7 +64,7 @@
 .. variable:: utility_user_password
 
      :version 5.5.27-28.0: Implemented
-     :cli: No
+     :cli: Yes
      :conf: utility_user_password=<password>
      :scope: Global
      :dyn: No
@@ -76,7 +76,7 @@
 .. variable:: utility_user_schema_access
 
      :version 5.5.27-28.0: Implemented
-     :cli: No
+     :cli: Yes
      :conf: utility_user_schema_access=<schema>,<schema>,<schema>
      :scope: Global
      :dyn: No

=== modified file 'doc/source/percona-theme/layout.html'
--- doc/source/percona-theme/layout.html	2012-08-22 14:34:42 +0000
+++ doc/source/percona-theme/layout.html	2012-09-03 13:35:24 +0000
@@ -214,7 +214,7 @@
       <div class="searchlink"><a onmouseover="SEARCH.Open()"><img id="searchlink-anchor" src="http://s2.percona.com/ui-search.png" alt="" /></a></div>
       <span class="inv"><![CDATA[<noindex>]]></span>
      	<div class="navicontainer"><div class="navi">
-		      
+		<span id="navilink-span-about-us" ><a id="navilink-a-about-us" href="/about-us/">About Us</a></span><span id="navilink-span-mysql-consulting" ><a id="navilink-a-mysql-consulting" href="/mysql-consulting/">Consulting</a></span><span id="navilink-span-support" ><a id="navilink-a-support" href="/mysql-support/">Support</a></span><span id="navilink-span-training" ><a id="navilink-a-training" href="/training/">Training</a></span><span id="navilink-span-development" ><a id="navilink-a-development" href="/development/">Development</a></span><span id="navilink-span-software" ><a id="navilink-a-software" href="/software/">Software</a></span><span id="navilink-span-events" ><a id="navilink-a-events" href="/live/">Events</a></span><span id="navilink-span-contact" ><a id="navilink-a-contact" href="/contact/">Contact Us</a></span>      
 		</div></div>
 
 		<span class="inv"><![CDATA[</noindex>]]></span>
@@ -329,7 +329,39 @@
 {%- endblock %}
 <span class="inv"><!--[CDATA[<noindex-->]]&gt;</span>
 <div id="submenus">
-	
+	<div class="navi-dropdown" id="navi-dropdown-about-us">
+    <div class="navi-dropdown-header-l"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/about-us/our-mission/">Our Mission</a></div><div class="item"><a href="/about-us/why-percona/">Why Percona?</a></div><div class="item"><a href="/about-us/procedures/">Coordinating with Percona</a></div><div class="item"><a href="/about-us/customers/">Customers</a></div><div class="item"><a href="/webinars/">Webinars</a></div><div class="item"><a href="/about-us/mysql-case-studies/">MySQL Case Studies</a></div><div class="item"><a href="/about-us/our-team/">Our Team</a></div><div class="item"><a href="/about-us/books/">Our Books</a></div><div class="item"><a href="/about-us/blogs/">Our Blogs</a></div><div class="item"><a href="/about-us/mysql-white-papers/">MySQL White Papers</a></div><div class="item"><a href="/about-us/conferences/">Conferences</a></div><div class="item"><a href="/about-us/presentations/">Presentations</a></div><div class="item"><a href="/about-us/newsletters/">Newsletters</a></div><div class="item"><a href="/about-us/pressreleases/">Press Releases</a></div><div class="item"><a href="/about-us/careers/">Careers</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-mysql-consulting">
+    <div class="navi-dropdown-header-l"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/mysql-consulting/overview/">MySQL Consulting Overview</a></div><div class="item"><a href="/mysql-consulting/prices/">MySQL Consulting Prices</a></div><div class="item"><a href="/mysql-consulting/architecture/">MySQL Architecture &amp; Design</a></div><div class="item"><a href="/mysql-consulting/mysql-backups/">MySQL Backups</a></div><div class="item"><a href="/mysql-consulting/cloud-computing/">MySQL Cloud Solutions</a></div><div class="item"><a href="/mysql-consulting/cluster/">MySQL Cluster Consulting</a></div><div class="item"><a href="/mysql-consulting/data-warehousing/">MySQL Data Warehousing</a></div><div class="item"><a href="/mysql-consulting/data-recovery/">MySQL Data Recovery</a></div><div class="item"><a href="/mysql-consulting/high-availability/">MySQL High Availability</a></div><div class="item"><a href="/mysql-consulting/mysql-monitoring-graphing/">MySQL Monitoring &amp; Graphing</a></div><div class="item"><a href="/mysql-consulting/mysql-onsite-consulting/">MySQL Onsite Consulting</a></div><div class="item"><a href="/mysql-consulting/performance-audit/">MySQL Performance Audit</a></div><div class="item"><a href="/mysql-consulting/remote-dba/">MySQL Remote DBA</a></div><div class="item"><a href="/mysql-consulting/mysql-replication/">MySQL Replication</a></div><div class="item"><a href="/mysql-consulting/upgrade/">MySQL Version Upgrades</a></div><div class="item"><a href="/mysql-consulting/24x7-emergency/">Emergency 24&times;7 Consulting</a></div><div class="item"><a href="/mysql-consulting/migration/">Migration to MySQL</a></div><div class="item"><a href="/drizzle-consulting/">Drizzle Consulting</a></div><div class="item"><a href="/mysql-consulting/sphinx/">Sphinx Consulting</a></div><div class="item"><a href="/mysql-consulting/drbd/">DRBD Consulting</a></div><div class="item"><a href="/mysql-consulting/memcached/">Memcached Consulting</a></div><div class="item"><a href="/mysql-consulting/other-services/">Other Consulting Services</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-support">
+    <div class="navi-dropdown-header-l"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/mysql-support/">MySQL Support Overview</a></div><div class="item"><a href="/prices/mysql-support/">MySQL Support Prices</a></div><div class="item"><a href="/mysql-support/policies/">MySQL Support Policies</a></div><div class="item"><a href="/mysql-support/consulting-vs-support/">Consulting vs. Support</a></div><div class="item"><a href="https://customers.percona.com">Customer Portal Login</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-training">
+    <div class="navi-dropdown-header-l"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/training/">MySQL Training Overview</a></div><div class="item"><a href="/prices/training/">MySQL Training Prices</a></div><div class="item"><a href="/training/classes/dba/">MySQL DBA Training</a></div><div class="item"><a href="/training/classes/developers/">MySQL Developer Training</a></div><div class="item"><a href="/training/classes/operations/">MySQL Operations Training</a></div><div class="item"><a href="/training/classes/innodb/">InnoDB &amp; XtraDB Training</a></div><div class="item"><a href="/training/classes/custom-onsite/">Custom Onsite Training</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-development">
+    <div class="navi-dropdown-header-l"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/development/mysql/">MySQL Development Overview</a></div><div class="item"><a href="/development/prices/">Custom Development Prices</a></div><div class="item"><a href="/development/maintenance/">MySQL Support Overview</a></div><div class="item"><a href="/development/benchmarking/">Custom Product Evaluation</a></div><div class="item"><a href="/development/maatkit/">Custom Maatkit Development</a></div><div class="item"><a href="/development/custom-tools/">Custom Tools Development</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-software">
+    <div class="navi-dropdown-header-l"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/software/">Percona Software for MySQL</a></div><div class="item"><a href="/software/percona-server/">Percona Server with XtraDB</a></div><div class="item"><a href="/software/percona-xtradb-cluster/">Percona XtraDB Cluster</a></div><div class="item"><a href="/software/percona-xtrabackup/">Percona XtraBackup</a></div><div class="item"><a href="/software/mysql-innodb-data-recovery-tools/">Data Recovery Toolkit</a></div><div class="item"><a href="/software/percona-xtradb/">Percona XtraDB</a></div><div class="item"><a href="/software/percona-toolkit/">Percona Toolkit</a></div><div class="item"><a href="/software/percona-monitoring-plugins/">Percona Monitoring Plugins</a></div><div class="item"><a href="/prices/software/">Software Prices</a></div><div class="item"><a href="/downloads/">Downloads</a></div><div class="item"><a href="/software/repositories/">Repositories</a></div><div class="item"><a href="/software/documentation/">Documentation</a></div><div class="item"><a href="http://forum.percona.com">Forum</a></div><div class="item"><a href="http://groups.google.com/group/percona-discussion">Google Discussion</a></div><div class="item"><a href="https://launchpad.net/percona-server">Launchpad</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-events">
+    <div class="navi-dropdown-header-r"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/live/nyc-2012/">New York 2012</a></div><div class="item"><a href="/live/london-2012/">London 2012</a></div><div class="item"><a href="/live/mysql-conference-2013/">MySQL Conference &amp; Expo 2013</a></div><div class="item"><a href="/live/mysql-conference-2012/">MySQL Conference &amp; Expo 2012</a></div><div class="item"><a href="/live/">Previous Percona Live Events</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div><div class="navi-dropdown" id="navi-dropdown-contact">
+    <div class="navi-dropdown-header-r"><!-- //--></div>
+    <div class="navi-dropdown-content"><div class="item"><a href="/contact/24x7-emergency/">24&times;7 Emergency</a></div><div class="item"><a href="/contact/sales/">Sales &amp; General Inquiries</a></div><div class="item"><a href="/contact/billing/">Billing Inquiries</a></div><div class="item"><a href="https://customers.percona.com">Customer Portal Login</a></div><div class="item"><a href="/contact/phone-directory/">Phone Directory</a></div><div class="item"><a href="/subscribe/">Subscribe to Newsletter</a></div>    </div>
+    <div class="navi-dropdown-footer"><!-- //--></div>
+  </div>
   <div id="search-dropdown" class="search-dropdown">
     <div class="search-dropdown-header"><!-- //--></div>
     <div class="search-dropdown-content">
@@ -351,7 +383,7 @@
 <!-- /GA //-->
 <!-- NAVI //-->
 <script type="text/javascript">//<![CDATA[
-var navi = [];
+var navi = [{id:"about-us", direction: "l"},{id:"mysql-consulting", direction: "l"},{id:"support", direction: "l"},{id:"training", direction: "l"},{id:"development", direction: "l"},{id:"software", direction: "l"},{id:"events", direction: "r"},{id:"contact", direction: "r"}];
 for(var i = 0, c = navi.length; i < c; i++) {
 window.jQuery('#navilink-a-' + navi[i].id).bind('mouseover',{id: navi[i].id, direction:navi[i].direction}, function(e) { NAVI.Open(e.data.id, e.data.direction); } );
 }

=== added file 'doc/source/percona-theme/static/._percona.com.css'
Binary files doc/source/percona-theme/static/._percona.com.css	1970-01-01 00:00:00 +0000 and doc/source/percona-theme/static/._percona.com.css	2012-09-03 13:35:24 +0000 differ
=== added file 'doc/source/release-notes/Percona-Server-5.5.27-28.1.rst'
--- doc/source/release-notes/Percona-Server-5.5.27-28.1.rst	1970-01-01 00:00:00 +0000
+++ doc/source/release-notes/Percona-Server-5.5.27-28.1.rst	2012-09-03 13:35:24 +0000
@@ -0,0 +1,17 @@
+.. rn:: 5.5.27-28.1
+
+===============================
+ |Percona Server| 5.5.27-28.1
+===============================
+
+Percona is glad to announce the release of |Percona Server| 5.5.27-28.1 on September 5th, 2012 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.27-28.1/>`_ 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-28.1 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-28.1 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.5.27-28.1>`_. 
+
+Bug Fixes
+=========
+
+ |Percona Server| :rn:`5.5.27-28.0` would crash or deadlock in |XtraDB| buffer pool code. This was caused by incorrect mutex handling in recently introduced |InnoDB| code. Bug fixed :bug:`1038225` (*Laurynas Biveinis*).
+
+ Variables :variable:`innodb_adaptive_flushing_method` and :variable:`innodb_flush_neighbor_pages` would not correctly translate some values internally. Bug fixed :bug:`1039384` (*Laurynas Biveinis*).
+

=== modified file 'doc/source/scalability/innodb_io_55.rst'
--- doc/source/scalability/innodb_io_55.rst	2012-07-18 06:25:14 +0000
+++ doc/source/scalability/innodb_io_55.rst	2012-09-03 13:35:24 +0000
@@ -68,9 +68,6 @@
 
 The following values are allowed:
 
-  * ``reflex``:
-    This behavior is similar to innodb_max_dirty_pages_pct flushing. The difference is that this method starts flushing blocks constantly and contiguously based on the oldest modified age. If the age exceeds 1/2 of the maximum age capacity, |InnoDB| starts weak contiguous flushing. If the age exceeds 3/4, |InnoDB| starts strong flushing. The strength can be adjusted by the |MySQL| variable :variable:`innodb_io_capacity`. In other words, we must tune ``innodb_io_capacity`` for the ``reflex`` method to work the best. This method was removed in 5.5.20-beta as a fix for bug :bug:`689450`.
-
   * ``native`` [0]:
     This setting causes checkpointing to operate exactly as it does in native |InnoDB|.
 
@@ -80,6 +77,10 @@
   * ``keep_average`` [2]:
     This method attempts to keep the I/O rate constant by using a much shorter loop cycle (0.1 second) than that of the other methods (1.0 second). It is designed for use with SSD cards.
 
+  * ``reflex``:
+    This behavior is similar to innodb_max_dirty_pages_pct flushing. The difference is that this method starts flushing blocks constantly and contiguously based on the oldest modified age. If the age exceeds 1/2 of the maximum age capacity, |InnoDB| starts weak contiguous flushing. If the age exceeds 3/4, |InnoDB| starts strong flushing. The strength can be adjusted by the |MySQL| variable :variable:`innodb_io_capacity`. In other words, we must tune ``innodb_io_capacity`` for the ``reflex`` method to work the best. This method was removed in :rn:`5.5.20-beta` as a fix for bug :bug:`689450`.
+
+
 .. variable:: innodb_checkpoint_age_target
 
    :cli: Yes