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

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: 295
Merged at revision: 296
Proposed branch: lp:~hrvojem/percona-server/rn-5.5.27-28.1
Merge into: lp:percona-server/5.5
Diff against target: 209 lines (+76/-17)
7 files modified
doc/source/conf.py (+1/-1)
doc/source/diagnostics/innodb_show_lock_names.rst (+2/-2)
doc/source/management/expanded_program_option_modifiers.rst (+14/-5)
doc/source/management/utility_user.rst (+3/-3)
doc/source/percona-theme/layout.html (+35/-3)
doc/source/release-notes/Percona-Server-5.5.27-28.1.rst (+17/-0)
doc/source/scalability/innodb_io_55.rst (+4/-3)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.5.27-28.1
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+122505@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/conf.py'
2--- doc/source/conf.py 2012-08-24 06:31:08 +0000
3+++ doc/source/conf.py 2012-09-03 13:35:24 +0000
4@@ -54,7 +54,7 @@
5 # The short X.Y version.
6 version = '5.5'
7 # The full version, including alpha/beta/rc tags.
8-release = '5.5.27-28.0'
9+release = '5.5.27-28.1'
10
11 # The language for content autogenerated by Sphinx. Refer to documentation
12 # for a list of supported languages.
13
14=== modified file 'doc/source/diagnostics/innodb_show_lock_names.rst'
15--- doc/source/diagnostics/innodb_show_lock_names.rst 2011-10-07 23:38:41 +0000
16+++ doc/source/diagnostics/innodb_show_lock_names.rst 2012-09-03 13:35:24 +0000
17@@ -4,11 +4,11 @@
18 Show Lock Names
19 =================
20
21-This feature is curently undocumented except for the following example.
22+This feature is currently undocumented except for the following example.
23
24 Example: ::
25
26- mysql> show mutex status;
27+ mysql> SHOW ENGINE INNODB MUTEX;
28 +--------+---------------------------+---------------+
29 | Type | Name | Status |
30 +--------+---------------------------+---------------+
31
32=== modified file 'doc/source/management/expanded_program_option_modifiers.rst'
33--- doc/source/management/expanded_program_option_modifiers.rst 2012-08-22 14:34:42 +0000
34+++ doc/source/management/expanded_program_option_modifiers.rst 2012-09-03 13:35:24 +0000
35@@ -7,17 +7,26 @@
36 |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.
37
38 Currently MySQL supports five existing option modifiers:
39- * disable: disables or ignores option_name.
40- * enable: enables option_name.
41- * loose: mysqld will not exit with an error if it does not recognize option_name, but instead it will issue only a warning.
42- * 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.
43- * skip: skips or ignores option_name.
44+ * disable [disable-<option_name>] disables or ignores option_name.
45+ * enable [enable-<option_name>] enables option_name.
46+ * 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.
47+ * 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.
48+ * skip [skip-<option_name>] skips or ignores option_name.
49
50 In order to offer more control over option visibility, access and range limits, the following new option modifiers have been added by |Percona Server|:
51 * 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.
52 * hidden [hidden-<option_name>=<TRUE/FALSE>] indicates that clients can not see or modify the value of option_name.
53 * readonly [readonly-<option_name>=<TRUE/FALSE>] indicates that clients can see the value of option_name but can not modify the value.
54
55+Combining the options
56+=====================
57+
58+Some of the option modifiers may be used together in the same option specification, example: ::
59+
60+ --skip-loose-<option_name>
61+ --loose-readonly-<option_name>=<T/F>
62+ --readonly-<option_name>=<T/F>
63+ --hidden-<option_name>=<T/F>
64
65 Version Specific Information
66 ============================
67
68=== modified file 'doc/source/management/utility_user.rst'
69--- doc/source/management/utility_user.rst 2012-08-22 14:34:42 +0000
70+++ doc/source/management/utility_user.rst 2012-09-03 13:35:24 +0000
71@@ -52,7 +52,7 @@
72 .. variable:: utility_user
73
74 :version 5.5.27-28.0: Implemented
75- :cli: No
76+ :cli: Yes
77 :conf: utility_user=<user@host>
78 :scope: Global
79 :dyn: No
80@@ -64,7 +64,7 @@
81 .. variable:: utility_user_password
82
83 :version 5.5.27-28.0: Implemented
84- :cli: No
85+ :cli: Yes
86 :conf: utility_user_password=<password>
87 :scope: Global
88 :dyn: No
89@@ -76,7 +76,7 @@
90 .. variable:: utility_user_schema_access
91
92 :version 5.5.27-28.0: Implemented
93- :cli: No
94+ :cli: Yes
95 :conf: utility_user_schema_access=<schema>,<schema>,<schema>
96 :scope: Global
97 :dyn: No
98
99=== modified file 'doc/source/percona-theme/layout.html'
100--- doc/source/percona-theme/layout.html 2012-08-22 14:34:42 +0000
101+++ doc/source/percona-theme/layout.html 2012-09-03 13:35:24 +0000
102@@ -214,7 +214,7 @@
103 <div class="searchlink"><a onmouseover="SEARCH.Open()"><img id="searchlink-anchor" src="http://s2.percona.com/ui-search.png" alt="" /></a></div>
104 <span class="inv"><![CDATA[<noindex>]]></span>
105 <div class="navicontainer"><div class="navi">
106-
107+ <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>
108 </div></div>
109
110 <span class="inv"><![CDATA[</noindex>]]></span>
111@@ -329,7 +329,39 @@
112 {%- endblock %}
113 <span class="inv"><!--[CDATA[<noindex-->]]&gt;</span>
114 <div id="submenus">
115-
116+ <div class="navi-dropdown" id="navi-dropdown-about-us">
117+ <div class="navi-dropdown-header-l"><!-- //--></div>
118+ <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>
119+ <div class="navi-dropdown-footer"><!-- //--></div>
120+ </div><div class="navi-dropdown" id="navi-dropdown-mysql-consulting">
121+ <div class="navi-dropdown-header-l"><!-- //--></div>
122+ <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>
123+ <div class="navi-dropdown-footer"><!-- //--></div>
124+ </div><div class="navi-dropdown" id="navi-dropdown-support">
125+ <div class="navi-dropdown-header-l"><!-- //--></div>
126+ <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>
127+ <div class="navi-dropdown-footer"><!-- //--></div>
128+ </div><div class="navi-dropdown" id="navi-dropdown-training">
129+ <div class="navi-dropdown-header-l"><!-- //--></div>
130+ <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>
131+ <div class="navi-dropdown-footer"><!-- //--></div>
132+ </div><div class="navi-dropdown" id="navi-dropdown-development">
133+ <div class="navi-dropdown-header-l"><!-- //--></div>
134+ <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>
135+ <div class="navi-dropdown-footer"><!-- //--></div>
136+ </div><div class="navi-dropdown" id="navi-dropdown-software">
137+ <div class="navi-dropdown-header-l"><!-- //--></div>
138+ <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>
139+ <div class="navi-dropdown-footer"><!-- //--></div>
140+ </div><div class="navi-dropdown" id="navi-dropdown-events">
141+ <div class="navi-dropdown-header-r"><!-- //--></div>
142+ <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>
143+ <div class="navi-dropdown-footer"><!-- //--></div>
144+ </div><div class="navi-dropdown" id="navi-dropdown-contact">
145+ <div class="navi-dropdown-header-r"><!-- //--></div>
146+ <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>
147+ <div class="navi-dropdown-footer"><!-- //--></div>
148+ </div>
149 <div id="search-dropdown" class="search-dropdown">
150 <div class="search-dropdown-header"><!-- //--></div>
151 <div class="search-dropdown-content">
152@@ -351,7 +383,7 @@
153 <!-- /GA //-->
154 <!-- NAVI //-->
155 <script type="text/javascript">//<![CDATA[
156-var navi = [];
157+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"}];
158 for(var i = 0, c = navi.length; i < c; i++) {
159 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); } );
160 }
161
162=== added file 'doc/source/percona-theme/static/._percona.com.css'
163Binary 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
164=== added file 'doc/source/release-notes/Percona-Server-5.5.27-28.1.rst'
165--- doc/source/release-notes/Percona-Server-5.5.27-28.1.rst 1970-01-01 00:00:00 +0000
166+++ doc/source/release-notes/Percona-Server-5.5.27-28.1.rst 2012-09-03 13:35:24 +0000
167@@ -0,0 +1,17 @@
168+.. rn:: 5.5.27-28.1
169+
170+===============================
171+ |Percona Server| 5.5.27-28.1
172+===============================
173+
174+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>`_).
175+
176+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>`_.
177+
178+Bug Fixes
179+=========
180+
181+ |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*).
182+
183+ 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*).
184+
185
186=== modified file 'doc/source/scalability/innodb_io_55.rst'
187--- doc/source/scalability/innodb_io_55.rst 2012-07-18 06:25:14 +0000
188+++ doc/source/scalability/innodb_io_55.rst 2012-09-03 13:35:24 +0000
189@@ -68,9 +68,6 @@
190
191 The following values are allowed:
192
193- * ``reflex``:
194- 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`.
195-
196 * ``native`` [0]:
197 This setting causes checkpointing to operate exactly as it does in native |InnoDB|.
198
199@@ -80,6 +77,10 @@
200 * ``keep_average`` [2]:
201 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.
202
203+ * ``reflex``:
204+ 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`.
205+
206+
207 .. variable:: innodb_checkpoint_age_target
208
209 :cli: Yes

Subscribers

People subscribed via source and target branches