Merge lp:~hrvojem/percona-server/rn-5.5.37-35.0-5.5 into lp:percona-server/5.5

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: 647
Merged at revision: 655
Proposed branch: lp:~hrvojem/percona-server/rn-5.5.37-35.0-5.5
Merge into: lp:percona-server/5.5
Diff against target: 679 lines (+428/-22)
10 files modified
doc/source/conf.py (+3/-1)
doc/source/diagnostics/scalability_metrics_plugin.rst (+99/-0)
doc/source/diagnostics/slow_extended_55.rst (+8/-3)
doc/source/index.rst (+2/-0)
doc/source/installation/apt_repo.rst (+1/-1)
doc/source/management/audit_log_plugin.rst (+234/-0)
doc/source/release-notes/Percona-Server-5.5.29-30.0.rst (+1/-1)
doc/source/release-notes/Percona-Server-5.5.37-35.0.rst (+45/-0)
doc/source/release-notes/release-notes_index.rst (+1/-0)
doc/source/upstream-bug-fixes.rst (+34/-16)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.5.37-35.0-5.5
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+217579@code.launchpad.net
To post a comment you must log in.

Partial review:

    - slow query log rate filtering docs need update for 1016991.
    - 94: I don't like intro "X is free open-source Oracle's Y." I'd
      edit to tell what the audit plugin is, independently from
      Oracle, and only then mention that it is an alternative
      implementation of Oracle's one.
    - 151: is shipped with Percona Server but is not installed by
      default
    - 177: s/can't/can ?
    - 305: duplicate of 294
    - 350: something else than "PS has implemented X"
    - 1262439: fix was not ported from 5.7, check the bug report for
      the correct credit.
    - 1070255: s/ported/backported
    - 1298352: the previous release or previous releases?

review: Needs Fixing

    - 1182535: stray "i"
    - 1282008: s/add connection/handle a new client connection
    - 1286114: the description needs to be end-user: fixed a
      performance issue in extending tablespaces if running under
      fusionIO with atomic writes enabled.
    - 375: either s/sources files/sources, either s/sources
      files/source files

review: Needs Fixing

    - 33: "to provide additional information" is too vague description
      for scalability metrics plugin
    - 50: s/Scalability Metrics/The plugin
    - 74: I don't understand the "(status variables)" bit?
    - s/starting point/the starting point, but I don't particularly
      like it. I'd try removing it completely.
    - scalability_metrics_totaltime: of currently executing queries?
      of all completed queries? something else?
    - 112: define "server's total busy time"
    - slow query log docs not updated for 1287650 (look at 140, 141)
    - 149: Remove instead of each query having ... and the last
      sentence, write "... deterministically. With the current
      implementation each query has a non-deterministic probability of
      1/n to get logged."
    - 488: link atomic writes
    - 490: s/selection of query/selection of queries
    - "PS has implemented X" comment has not been addressed. "X has
      been implemented for PS" is more correct, but not necessarily
      nicer, I'd try to think of some other way to say.

review: Needs Fixing

    - 33: Percona Server has implemented extra scalability metrics in
      5.5.37-35.0. These metrics allow using Little's Law, queueing
      theory, and Universal Scalability Law to gain insights into
      server performance.
    - 33: link to USL on Percona site (the other two things are easily
      googlable, this one not particularly).
    - 84+: s/since metrics were started/since the metrics collection
      was started
    - 105: replace high resolution with the actual time unit
    - 112: This counter accounts the non-idle server time, that is,
      time when at least one query was executing.
    - 498: Fixed by randomly selecting the queries to be logged
      instead of logging every nth query.

review: Needs Fixing

    - From the previous review:
    - 33: link to USL on Percona site (the other two things are easily
      googlable, this one not particularly).

review: Needs Fixing
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 2014-03-25 12:07:45 +0000
3+++ doc/source/conf.py 2014-04-30 09:32:55 +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.36-34.2'
9+release = '5.5.37-35.0'
10
11 # The language for content autogenerated by Sphinx. Refer to documentation
12 # for a list of supported languages.
13@@ -110,6 +110,8 @@
14
15 .. |Percona XtraBackup| replace:: *Percona XtraBackup*
16
17+.. |Percona Toolkit| replace:: *Percona Toolkit*
18+
19 .. |Percona Server| replace:: *Percona Server*
20
21 .. |Percona| replace:: *Percona*
22
23=== added file 'doc/source/diagnostics/scalability_metrics_plugin.rst'
24--- doc/source/diagnostics/scalability_metrics_plugin.rst 1970-01-01 00:00:00 +0000
25+++ doc/source/diagnostics/scalability_metrics_plugin.rst 2014-04-30 09:32:55 +0000
26@@ -0,0 +1,99 @@
27+.. _scalability_metrics_plugin:
28+
29+=====================================
30+ Metrics for scalability measurement
31+=====================================
32+
33+|Percona Server| has implemented extra scalability metrics in :rn:`5.5.37-35.0`. These metrics allow using Little's Law, queueing theory, and Universal Scalability Law to gain insights into server performance. This feature is implemented as a plugin.
34+
35+Installation
36+============
37+
38+Scalability Metrics plugin is shipped with |Percona Server|, but it is not installed by default. To enable the plugin you must run the following command:
39+
40+.. code-block:: mysql
41+
42+ INSTALL PLUGIN scalability_metrics SONAME 'scalability_metrics.so';
43+
44+You can check if the plugin is loaded correctly by running:
45+
46+.. code-block:: mysql
47+
48+ SHOW PLUGINS;
49+
50+The plugin should be listed in the output:
51+
52+.. code-block:: mysql
53+
54+ +--------------------------------+----------+--------------------+------------------------+---------+
55+ | Name | Status | Type | Library | License |
56+ +--------------------------------+----------+--------------------+------------------------+---------+
57+ ...
58+ | scalability_metrics | ACTIVE | AUDIT | scalability_metrics.so | GPL |
59+ +--------------------------------+----------+--------------------+------------------------+---------+
60+
61+System Variables
62+================
63+
64+.. variable:: scalability_metrics_control
65+
66+ :version 5.5.37-35.0: Implemented
67+ :cli: Yes
68+ :scope: Global
69+ :dyn: Yes
70+ :vartype: String
71+ :default: ``OFF``
72+ :values: ``OFF``, ``ON``, ``RESET``
73+
74+This variable can be used to enable and disable the collection of metrics for scalability measurement. By setting the value to ``RESET`` all counters will be reset while continuing to count metrics.
75+
76+Status Variables
77+================
78+
79+.. variable:: scalability_metrics_elapsedtime
80+
81+ :version 5.5.37-35.0: Implemented
82+ :vartype: Numeric
83+
84+This status variable shows total time elapsed since metrics collection was started.
85+
86+.. variable:: scalability_metrics_queries
87+
88+ :version 5.5.37-35.0: Implemented
89+ :vartype: Numeric
90+
91+This status variable shows number of completed queries since metrics collection was started.
92+
93+.. variable:: scalability_metrics_concurrency
94+
95+ :version 5.5.37-35.0: Implemented
96+ :vartype: Numeric
97+
98+This status variable shows number of queries currently executed.
99+
100+.. variable:: scalability_metrics_totaltime
101+
102+ :version 5.5.37-35.0: Implemented
103+ :vartype: Numeric
104+
105+This status variable shows total execution time of all queries, including the in-progress time of currently executing queries, in microseconds (ie. if two queries executed with 1 second of response time each, the result is 2 seconds).
106+
107+.. variable:: scalability_metrics_busytime
108+
109+ :version 5.5.37-35.0: Implemented
110+ :vartype: Numeric
111+
112+This counter accounts the non-idle server time, that is, time when at least one query was executing.
113+
114+
115+Version Specific Information
116+============================
117+
118+ * :rn:`5.5.37-35.0`
119+ Scalability Metrics plugin has been implemented in |Percona Server|.
120+
121+Other Reading
122+=============
123+
124+* `Fundamental performance and scalability instrumentation <http://www.xaprb.com/blog/2011/10/06/fundamental-performance-and-scalability-instrumentation/>`_
125+* `Forecasting MySQL Scalability with the Universal Scalability Law Whitepaper <http://www.percona.com/files/white-papers/forecasting-mysql-scalability.pdf>`_
126
127=== modified file 'doc/source/diagnostics/slow_extended_55.rst'
128--- doc/source/diagnostics/slow_extended_55.rst 2013-10-24 14:12:14 +0000
129+++ doc/source/diagnostics/slow_extended_55.rst 2014-04-30 09:32:55 +0000
130@@ -97,6 +97,8 @@
131 :conf: Yes
132 :scope: Global, session
133 :dyn: Yes
134+ :default: 1
135+ :range: 1-1000
136
137 Behavior of this variable depends from :variable:`log_slow_rate_type`.
138
139@@ -108,11 +110,12 @@
140 * When :variable:`log_slow_rate_type` is ``query``, this option lets you log just some queries for later analysis. For example, if you set the value to 100, then one percent of queries will be logged.
141
142 Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`.
143+
144 Decision "log or no" calculated in following manner:
145
146- * if ``log_slow_rate_limit`` is 0 - log every query
147+ * if ``log_slow_rate_limit`` is 1 - log every query
148
149- * If ``log_slow_rate_limit`` > 0 - log query when (``query_id`` % ``log_slow_rate_limit``) is zero.
150+ * If ``log_slow_rate_limit`` > 1 - randomly log every 1/``log_slow_rate_limit`` query.
151
152 This allows flexible setup logging behavior.
153
154@@ -120,6 +123,8 @@
155
156 Log_slow_rate_type: query Log_slow_rate_limit: 10
157
158+Prior to :rn:`5.5.37-35.0` implementation of the :variable:`log_slow_rate_type` set to ``query`` with :variable:`log_slow_rate_limit` feature would log every nth query deterministically. With the current implementation each query has a non-deterministic probability of 1/n to get logged."
159+
160 .. variable:: log_slow_slave_statements
161
162 :cli: Yes
163@@ -176,7 +181,7 @@
164 Equivalent to enabling ``microtime,innodb``.
165
166 * ``full``:
167- Equivalent to all other values OR'ed together.
168+ Equivalent to all other values OR'ed together without the ``profiling`` and ``profiling_use_getrusage`` options.
169
170 * ``profiling``:
171 Enables profiling of all queries in all connections.
172
173=== modified file 'doc/source/index.rst'
174--- doc/source/index.rst 2014-03-07 10:28:20 +0000
175+++ doc/source/index.rst 2014-04-30 09:32:55 +0000
176@@ -137,6 +137,7 @@
177 management/expanded_program_option_modifiers
178 management/changed_page_tracking
179 management/pam_plugin
180+ management/audit_log_plugin
181
182 Diagnostics Improvements
183 ========================
184@@ -157,6 +158,7 @@
185 diagnostics/process_list
186 diagnostics/misc_info_schema_tables
187 diagnostics/thread_based_profiling
188+ diagnostics/scalability_metrics_plugin
189
190 Obsolete and Removed Features
191 =============================
192
193=== modified file 'doc/source/installation/apt_repo.rst'
194--- doc/source/installation/apt_repo.rst 2013-12-19 12:22:20 +0000
195+++ doc/source/installation/apt_repo.rst 2014-04-30 09:32:55 +0000
196@@ -42,9 +42,9 @@
197
198 * 10.04LTS (lucid)
199 * 12.04LTS (precise)
200- * 12.10 (quantal)
201 * 13.04 (raring)
202 * 13.10 (saucy)
203+ * 14.04LTS (trusty)
204
205 Percona `apt` Experimental repository
206 =====================================
207
208=== added file 'doc/source/management/audit_log_plugin.rst'
209--- doc/source/management/audit_log_plugin.rst 1970-01-01 00:00:00 +0000
210+++ doc/source/management/audit_log_plugin.rst 2014-04-30 09:32:55 +0000
211@@ -0,0 +1,234 @@
212+.. _audit_log_plugin:
213+
214+==================
215+ Audit Log Plugin
216+==================
217+
218+Percona Audit Log Plugin provides monitoring and logging of connection and query activity that were performed on specific server. Information about the activity will be stored in the XML log file where each event will have its ``NAME`` field, it's own unique ``RECORD_ID`` field and a ``TIMESTAMP`` field. This implementation is alternative to the `MySQL Enterprise Audit Log Plugin <dev.mysql.com/doc/refman/5.5/en/audit-log-plugin.html>`_
219+
220+Audit Log plugin produces the log of following events:
221+
222+* **Audit** - Audit event indicates that audit logging started or finished. ``NAME`` field will be ``Audit`` when logging started and ``NoAudit`` when logging finished. Audit record also includes server version and command-line arguments.
223+
224+Example of the Audit event: ::
225+
226+ <AUDIT_RECORD
227+ "NAME"="Audit"
228+ "RECORD"="1_2014-04-29T09:29:40"
229+ "TIMESTAMP"="2014-04-29T09:29:40 UTC"
230+ "MYSQL_VERSION"="5.5.37-35.0-655.trusty"
231+ "STARTUP_OPTIONS"="--basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306"
232+ "OS_VERSION"="x86_64-debian-linux-gnu",
233+ />
234+
235+* **Connect**/**Disconnect** - Connect record event will have ``NAME`` field ``Connect`` when user logged in or login failed, or ``Quit`` when connection is closed. Additional fields for this event are ``CONNECTION_ID``, ``STATUS``, ``USER``, ``PRIV_USER``, ``OS_LOGIN``, ``PROXY_USER``, ``HOST``, and ``IP``. ``STATUS`` will be ``0`` for successful logins and non-zero for failed logins.
236+
237+Example of the Disconnect event: ::
238+
239+ <AUDIT_RECORD
240+ "NAME"="Quit"
241+ "RECORD"="24_2014-04-29T09:29:40"
242+ "TIMESTAMP"="2014-04-29T10:20:13 UTC"
243+ "CONNECTION_ID"="49"
244+ "STATUS"="0"
245+ "USER"=""
246+ "PRIV_USER"=""
247+ "OS_LOGIN"=""
248+ "PROXY_USER"=""
249+ "HOST"=""
250+ "IP"=""
251+ "DB"=""
252+ />
253+
254+* **Query** - Additional fields for this event are: ``COMMAND_CLASS`` (values come from the ``com_status_vars`` array in the :file:`sql/mysqld.cc`` file in a MySQL source distribution. Examples are ``select``, ``alter_table", "create_table", etc.), ``CONNECTION_ID``, ``STATUS`` (indicates error when non-zero), ``SQLTEXT`` (text of SQL-statement), ``USER``, ``HOST``, ``OS_USER``, ``IP``. Possible values for the ``NAME`` name field for this event are ``Query``, ``Prepare``, ``Execute``, ``Change user``, etc.
255+
256+Example of the Query event: ::
257+
258+ <AUDIT_RECORD
259+ "NAME"="Query"
260+ "RECORD"="23_2014-04-29T09:29:40"
261+ "TIMESTAMP"="2014-04-29T10:20:10 UTC"
262+ "COMMAND_CLASS"="select"
263+ "CONNECTION_ID"="49"
264+ "STATUS"="0"
265+ "SQLTEXT"="SELECT * from mysql.user"
266+ "USER"="root[root] @ localhost []"
267+ "HOST"="localhost"
268+ "OS_USER"=""
269+ "IP"=""
270+ />
271+
272+Installation
273+============
274+
275+Audit Log plugin is shipped with |Percona Server|, but it is not installed by default. To enable the plugin you must run the following command:
276+
277+.. code-block:: mysql
278+
279+ INSTALL PLUGIN audit_log SONAME 'audit_log.so';
280+
281+You can check if the plugin is loaded correctly by running:
282+
283+.. code-block:: mysql
284+
285+ SHOW PLUGINS;
286+
287+Audit log should be listed in the output:
288+
289+.. code-block:: mysql
290+
291+ +--------------------------------+----------+--------------------+--------------+---------+
292+ | Name | Status | Type | Library | License |
293+ +--------------------------------+----------+--------------------+--------------+---------+
294+ ...
295+ | audit_log | ACTIVE | AUDIT | audit_log.so | GPL |
296+ +--------------------------------+----------+--------------------+--------------+---------+
297+
298+Log Format
299+==========
300+
301+Audit log plugin supports two formats. In one format (``OLD``) log record properties are saved as XML attributes and in the other (``NEW``) log recored properties are saved as XML tags. Audit log format can be set up with the :variable:`audit_log_format` variable.
302+
303+Example of the ``OLD`` format: ::
304+
305+ <AUDIT_RECORD
306+ "NAME"="Query"
307+ "RECORD"="2_2014-04-28T09:29:40"
308+ "TIMESTAMP"="2014-04-28T09:29:40 UTC"
309+ "COMMAND_CLASS"="install_plugin"
310+ "CONNECTION_ID"="47"
311+ "STATUS"="0"
312+ "SQLTEXT"="INSTALL PLUGIN audit_log SONAME 'audit_log.so'"
313+ "USER"="root[root] @ localhost []"
314+ "HOST"="localhost"
315+ "OS_USER"=""
316+ "IP"=""
317+ />
318+
319+Example of the ``NEW`` format: ::
320+
321+ <AUDIT_RECORD>
322+ <NAME>Quit</NAME>
323+ <RECORD>10902_2014-04-28T11:02:54</RECORD>
324+ <TIMESTAMP>2014-04-28T11:02:59 UTC</TIMESTAMP>
325+ <CONNECTION_ID>36</CONNECTION_ID>
326+ <STATUS>0</STATUS>
327+ <USER></USER>
328+ <PRIV_USER></PRIV_USER>
329+ <OS_LOGIN></OS_LOGIN>
330+ <PROXY_USER></PROXY_USER>
331+ <HOST></HOST>
332+ <IP></IP>
333+ <DB></DB>
334+ </AUDIT_RECORD>
335+
336+System Variables
337+================
338+
339+.. variable:: audit_log_strategy
340+
341+ :version 5.5.37-35.0: Implemented
342+ :cli: Yes
343+ :scope: Global
344+ :dyn: No
345+ :vartype: String
346+ :default: ASYNCHRONOUS
347+ :allowed values: ``ASYNCHRONOUS``, ``PERFORMANCE``, ``SEMISYNCHRONOUS``, ``SYNCHRONOUS``
348+
349+This variable is used to specify the audit log strategy, possible values are:
350+
351+* ``ASYNCHRONOUS`` - (default) log using memory buffer, do not drop messages if buffer is full
352+* ``PERFORMANCE`` - log using memory buffer, drop messages if buffer is full
353+* ``SEMISYNCHRONOUS`` - log directly to file, do not flush and sync every event
354+* ``SYNCHRONOUS`` - log directly to file, flush and sync every event
355+
356+.. variable:: audit_log_file
357+
358+ :version 5.5.37-35.0: Implemented
359+ :cli: Yes
360+ :scope: Global
361+ :dyn: No
362+ :vartype: String
363+ :default: audit.log
364+
365+This variable is used to specify the filename that's going to store the audit log. It can contain the path relative to the datadir or absolute path.
366+
367+.. variable:: audit_log_flush
368+
369+ :version 5.5.37-35.0: Implemented
370+ :cli: Yes
371+ :scope: Global
372+ :dyn: No
373+ :vartype: String
374+ :default: OFF
375+
376+When this variable is set to ``ON`` log file will be closed and reopened. This can be used for manual log rotation.
377+
378+.. variable:: audit_log_buffer_size
379+
380+ :version 5.5.37-35.0: Implemented
381+ :cli: Yes
382+ :scope: Global
383+ :dyn: No
384+ :vartype: Numeric
385+ :default: 4096
386+
387+This variable can be used to specify the size of memory buffer used for logging, used when :variable:`audit_log_strategy` variable is set to ``ASYNCHRONOUS`` or ``PERFORMANCE`` values.
388+
389+.. variable:: audit_log_format
390+
391+ :version 5.5.37-35.0: Implemented
392+ :cli: Yes
393+ :scope: Global
394+ :dyn: No
395+ :vartype: String
396+ :default: OLD
397+ :allowed values: ``OLD``, ``NEW``
398+
399+This variable is used to specify the audit log format. When this variable is set to ``OLD`` information will be logged as XML attributes, and when is set to ``NEW`` it will be logged as XML tags.
400+
401+.. variable:: audit_log_policy
402+
403+ :version 5.5.37-35.0: Implemented
404+ :cli: Yes
405+ :scope: Global
406+ :dyn: Yes
407+ :vartype: String
408+ :default: ALL
409+ :allowed values: ``ALL``, ``LOGINS``, ``QUERIES``, ``NONE``
410+
411+This variable is used to specify which events should be logged. Possible values are:
412+
413+* ``ALL`` - all events will be logged
414+* ``LOGINS`` - only logins will be logged
415+* ``QUERIES`` - only queries will be logged
416+* ``NONE`` - no events will be logged
417+
418+.. variable:: audit_log_rotate_on_size
419+
420+ :version 5.5.37-35.0: Implemented
421+ :cli: Yes
422+ :scope: Global
423+ :dyn: No
424+ :vartype: Numeric
425+ :default: 0 (don't rotate the log file)
426+
427+This variable is used to specify the size of the audit log file. When this size is reached log will get rotated. Old log can be found in the same directory, audit log sequential number will be appended to the name specified in the :variable:`audit_log_file` variable.
428+
429+.. variable:: audit_log_rotations
430+
431+ :version 5.5.37-35.0: Implemented
432+ :cli: Yes
433+ :scope: Global
434+ :dyn: No
435+ :vartype: Numeric
436+ :default: 0
437+
438+This variable is used to specify how many log files should be kept when :variable:`audit_log_rotate_on_size` variable is set to non-zero value.
439+
440+Version Specific Information
441+============================
442+
443+ * :rn:`5.5.37-35.0`
444+ Audit Log plugin has been implemented in |Percona Server|.
445+
446
447=== modified file 'doc/source/release-notes/Percona-Server-5.5.29-30.0.rst'
448--- doc/source/release-notes/Percona-Server-5.5.29-30.0.rst 2013-02-26 06:01:42 +0000
449+++ doc/source/release-notes/Percona-Server-5.5.29-30.0.rst 2014-04-30 09:32:55 +0000
450@@ -62,4 +62,4 @@
451
452 Fixed the incorrect help text for :variable:`slow_query_log_timestamp_precision`. Bug fixed :bug:`1090965` (*Laurynas Biveinis*).
453
454-Other bug fixes: bug fixed :bug:`909376` (*Laurynas Biveinis*), bug fixed :bug:`1082437` (*Laurynas Biveinis*), bug fixed :bug:`1083669` (*Laurynas Biveinis*), bug fixed :bug:`1096904` (*Laurynas Biveinis*), bug fixed :bug:`1091712` (*Laurynas Biveinis*), bug fixed :bug:`1096899` (*Laurynas Biveinis*), bug fixed :bug:`1088954` (*Laurynas Biveinis*), bug fixed :bug:`1096895` (*Laurynas Biveinis*), bug fixed :bug:`1092142` (*Laurynas Biveinis*), bug fixed :bug:`1090874` (*Laurynas Biveinis*), bug fixed :bug:`1089961` (*Laurynas Biveinis*), bug fixed :bug:`1088867` (*Laurynas Biveinis*), bug fixed :bug:`1089031` (*Laurynas Biveinis*), bug fixed :bug:`1108874` (*Laurynas Biveinis*).
455+Other bug fixes: bug fixed :bug:`909376` (*Laurynas Biveinis*), bug fixed :bug:`1082437` (*Laurynas Biveinis*), bug fixed :bug:`1083669` (*Laurynas Biveinis*), bug fixed :bug:`1096904` (*Laurynas Biveinis*), bug fixed :bug:`1091712` (*Laurynas Biveinis*), bug fixed :bug:`1096899` (*Laurynas Biveinis*), bug fixed :bug:`1088954` (*Laurynas Biveinis*), bug fixed :bug:`1096895` (*Laurynas Biveinis*), bug fixed :bug:`1092142` (*Laurynas Biveinis*), bug fixed :bug:`1090874` (*Laurynas Biveinis*), bug fixed :bug:`1089961` (*Laurynas Biveinis*), bug fixed :bug:`1088867` (*Laurynas Biveinis*), bug fixed :bug:`1089031` (*Laurynas Biveinis*), bug fixed :bug:`1108874` (*Laurynas Biveinis*), bug fixed :bug:`1030783` (*Laurynas Biveinis*), and bug fixed :bug:`803072` (*Laurynas Biveinis*).
456
457=== added file 'doc/source/release-notes/Percona-Server-5.5.37-35.0.rst'
458--- doc/source/release-notes/Percona-Server-5.5.37-35.0.rst 1970-01-01 00:00:00 +0000
459+++ doc/source/release-notes/Percona-Server-5.5.37-35.0.rst 2014-04-30 09:32:55 +0000
460@@ -0,0 +1,45 @@
461+.. rn:: 5.5.37-35.0
462+
463+==============================
464+ |Percona Server| 5.5.37-35.0
465+==============================
466+
467+Percona is glad to announce the release of |Percona Server| 5.5.37-35.0 on April 30th, 2014. Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.37-35.0/>`_ and from the :doc:`Percona Software Repositories </installation>`.
468+
469+Based on `MySQL 5.5.37 <http://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-37.html>`_, including all the bug fixes in it, |Percona Server| 5.5.37-35.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.37-35.0 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.5.37-35.0>`_.
470+
471+New Features
472+============
473+
474+ |Percona Server| now supports :ref:`scalability_metrics_plugin`.
475+
476+ |Percona Server| now supports :ref:`audit_log_plugin`.
477+
478+ |Percona Server| packages are now available for *Ubuntu* 14.04.
479+
480+Bugs Fixed
481+==========
482+
483+ |Percona Server| couldn't be built with *Bison* 3.0. Bug fixed :bug:`1262439`,upstream :mysqlbug:`71250` (*Ryan Gordon*).
484+
485+ Backported the upstream fix for overflow which would caused replication SQL thread to fail to execute events. Bug fixed :bug:`1070255` (upstream :mysqlbug:`67352`).
486+
487+ |Percona Server| debug packages were not built for the previous releases. Bug fixed :bug:`1298352`.
488+
489+ Queries that no longer exceed :variable:`long_query_time` were written to the slow query log if they matched the previous :variable:`long_query_time` value when :variable:`slow_query_log_use_global_control` variable was set to ``all``. Bug fixed :bug:`1016991`.
490+
491+ When writing audit plugins it was not possible to get notifications for general-log events without enabling the general-log. Bug fixed :bug:`1182535` (upstream :mysqlbug:`60782`).
492+
493+ ``mysqld_safe`` did not correctly parse :variable:`flush_caches` and :variable:`numa_interleave` options. Bug fixed :bug:`1231110`.
494+
495+ :ref:`threadpool` would handle a new client connection without notifying Audit Plugin. Bug fixed :bug:`1282008`.
496+
497+ Fixed a performance issue in extending tablespaces if running under ``fusionIO`` with :ref:`atomic writes <atomic_fio>` enabled. Bug fixed :bug:`1286114` (*Jan Lindström*).
498+
499+ Previous implementation of the :variable:`log_slow_rate_type` set to ``query`` with :variable:`log_slow_rate_limit` feature would log every nth query deterministically instead of each query having a 1/n probability to get logged. Fixed by randomly selecting the queries to be logged instead of logging every nth query. Bug fixed :bug:`1287650`.
500+
501+ |Percona Server| source files were referencing *Maatkit* instead of |Percona Toolkit|. Bug fixed :bug:`1174779`.
502+
503+ Maximum allowed value for :variable:`log_slow_rate_limit` was ``ULONG_MAX`` (ie. either ``4294967295`` or ``18446744073709551615``, depending on the platform). As it was unreasonable to configure the slow log for every four billionth session/query, new maximum allowed value is set to ``1000``. Bug fixed :bug:`1290714`.
504+
505+Other bugs fixed: :bug:`1272732`.
506
507=== modified file 'doc/source/release-notes/release-notes_index.rst'
508--- doc/source/release-notes/release-notes_index.rst 2014-03-25 12:07:45 +0000
509+++ doc/source/release-notes/release-notes_index.rst 2014-04-30 09:32:55 +0000
510@@ -6,6 +6,7 @@
511 :maxdepth: 1
512 :glob:
513
514+ Percona-Server-5.5.37-35.0
515 Percona-Server-5.5.36-34.2
516 Percona-Server-5.5.36-34.1
517 Percona-Server-5.5.36-34.0
518
519=== modified file 'doc/source/upstream-bug-fixes.rst'
520--- doc/source/upstream-bug-fixes.rst 2014-03-17 16:00:34 +0000
521+++ doc/source/upstream-bug-fixes.rst 2014-04-30 09:32:55 +0000
522@@ -5,15 +5,33 @@
523 =============================================================
524
525 +-------------------------------------------------------------------------------------------------------------+
526+|:Upstream bug: :mysqlbug:`60782` - Audit plugin API: no MYSQL_AUDIT_GENERAL_LOG notifications with general...|
527+|:Launchpad bug: :bug:`1182535` |
528+|:Upstream state: Verified (checked on 2014-04-29) |
529+|:Fix Released: :rn:`5.5.37-35.0` |
530+|:Upstream fix: N/A |
531++-------------------------------------------------------------------------------------------------------------+
532+|:Upstream bug: :mysqlbug:`67352` - table_id is defined differently in sql/table.h vs sql/log_event.h |
533+|:Launchpad bug: :bug:`1070255` |
534+|:Upstream state: Closed |
535+|:Fix Released: :rn:`5.5.37-35.0` |
536+|:Upstream fix: N/A |
537++-------------------------------------------------------------------------------------------------------------+
538+|:Upstream bug: :mysqlbug:`71250` - Bison 3 breaks mysql build |
539+|:Launchpad bug: :bug:`1262439` |
540+|:Upstream state: Closed |
541+|:Fix Released: :rn:`5.5.37-35.0` |
542+|:Upstream fix: N/A |
543++-------------------------------------------------------------------------------------------------------------+
544 |:Upstream bug: :mysqlbug:`71375` - Slave IO thread won't attempt auto reconnect to the master/error-code 1593|
545 |:Launchpad bug: :bug:`1268735` |
546-|:Upstream state: Verified (checked on 2014-03-17) |
547+|:Upstream state: Verified (checked on 2014-04-29) |
548 |:Fix Released: :rn:`5.5.36-34.1` |
549 |:Upstream fix: N/A |
550 +-------------------------------------------------------------------------------------------------------------+
551 |:Upstream bug: :mysqlbug:`71374` - Slave IO thread won't attempt auto reconnect to the master/error-code 1159|
552 |:Launchpad bug: :bug:`1268729` |
553-|:Upstream state: Verified (checked on 2014-03-17) |
554+|:Upstream state: Verified (checked on 2014-04-29) |
555 |:Fix Released: :rn:`5.5.36-34.1` |
556 |:Upstream fix: N/A |
557 +-------------------------------------------------------------------------------------------------------------+
558@@ -43,7 +61,7 @@
559 +-------------------------------------------------------------------------------------------------------------+
560 |:Upstream bug: :mysqlbug:`69639` - mysql failed to build with dtrace Sun D 1.11 |
561 |:Launchpad bug: :bug:`1196460` |
562-|:Upstream state: Open (checked on 2014-03-17) |
563+|:Upstream state: Open (checked on 2014-04-29) |
564 |:Fix Released: :rn:`5.5.33-31.1` |
565 |:Upstream fix: N/A |
566 +-------------------------------------------------------------------------------------------------------------+
567@@ -55,7 +73,7 @@
568 +-------------------------------------------------------------------------------------------------------------+
569 |:Upstream bug: :mysqlbug:`42415` - UPDATE/DELETE with LIMIT clause unsafe for SBL even with ORDER BY PK ... |
570 |:Launchpad bug: :bug:`1132194` |
571-|:Upstream state: Verified (checked on 2014-03-17) |
572+|:Upstream state: Verified (checked on 2014-04-29) |
573 |:Fix Released: :rn:`5.5.32-31.0` |
574 |:Upstream fix: N/A |
575 +-------------------------------------------------------------------------------------------------------------+
576@@ -67,7 +85,7 @@
577 +-------------------------------------------------------------------------------------------------------------+
578 |:Upstream bug: :mysqlbug:`68970` - fsp_reserve_free_extents switches from small to big tblspace handling ... |
579 |:Launchpad bug: :bug:`1169494` |
580-|:Upstream state: Verified (checked on 2014-03-17) |
581+|:Upstream state: Verified (checked on 2014-04-29) |
582 |:Fix Released: :rn:`5.5.32-31.0` |
583 |:Upstream fix: N/A |
584 +-------------------------------------------------------------------------------------------------------------+
585@@ -79,7 +97,7 @@
586 +-------------------------------------------------------------------------------------------------------------+
587 |:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined |
588 |:Launchpad bug: :bug:`1183610` |
589-|:Upstream state: No Feedback (checked on 2014-03-17) |
590+|:Upstream state: No Feedback (checked on 2014-04-29) |
591 |:Fix Released: :rn:`5.5.31-30.3` |
592 |:Upstream fix: N/A |
593 +-------------------------------------------------------------------------------------------------------------+
594@@ -91,7 +109,7 @@
595 +-------------------------------------------------------------------------------------------------------------+
596 |:Upstream bug: :mysqlbug:`68845` - Unnecessary log_sys->mutex reacquisition in mtr_log_reserve_and_write() |
597 |:Launchpad bug: :bug:`1163439` |
598-|:Upstream state: Verified (checked on 2014-03-17) |
599+|:Upstream state: Verified (checked on 2014-04-29) |
600 |:Fix Released: :rn:`5.5.30-30.2` |
601 |:Upstream fix: N/A |
602 +-------------------------------------------------------------------------------------------------------------+
603@@ -121,13 +139,13 @@
604 +-------------------------------------------------------------------------------------------------------------+
605 |:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() |
606 |:Launchpad bug: :bug:`1132350` |
607-|:Upstream state: Verified (checked on 2014-03-17) |
608+|:Upstream state: Verified (checked on 2014-04-29) |
609 |:Fix Released: :rn:`5.5.30-30.1` |
610 |:Upstream fix: N/A |
611 +-------------------------------------------------------------------------------------------------------------+
612 |:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|
613 |:Launchpad bug: :bug:`1100178` |
614-|:Upstream state: Verified (checked on 2014-03-17) |
615+|:Upstream state: Verified (checked on 2014-04-29) |
616 |:Fix Released: :rn:`5.5.29-30.0` |
617 |:Upstream fix: N/A |
618 +-------------------------------------------------------------------------------------------------------------+
619@@ -229,7 +247,7 @@
620 +-------------------------------------------------------------------------------------------------------------+
621 |:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|
622 |:Launchpad bug: :bug:`1042517` |
623-|:Upstream state: Verified (checked on 2014-03-17) |
624+|:Upstream state: Verified (checked on 2014-04-29) |
625 |:Fix Released: :rn:`5.5.27-29.0` |
626 |:Upstream fix: N/A |
627 +-------------------------------------------------------------------------------------------------------------+
628@@ -241,7 +259,7 @@
629 +-------------------------------------------------------------------------------------------------------------+
630 |:Upstream bug: :mysqlbug:`64800` - mysqldump with --include-master-host-port putting quotes around port no. |
631 |:Launchpad bug: :bug:`1013432` |
632-|:Upstream state: Verified (checked on 2014-03-17) |
633+|:Upstream state: Verified (checked on 2014-04-29) |
634 |:Fix Released: :rn:`5.5.27-28.0` |
635 |:Upstream fix: N/A |
636 +-------------------------------------------------------------------------------------------------------------+
637@@ -289,7 +307,7 @@
638 +-------------------------------------------------------------------------------------------------------------+
639 |:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |
640 |:Launchpad bug: :bug:`1262651` |
641-|:Upstream state: Verified (checked on 2014-03-17) |
642+|:Upstream state: Verified (checked on 2014-04-29) |
643 |:Fix Released: :rn:`5.5.20-24.1` |
644 |:Upstream fix: N/A |
645 +-------------------------------------------------------------------------------------------------------------+
646@@ -313,13 +331,13 @@
647 +-------------------------------------------------------------------------------------------------------------+
648 |:Upstream bug: :mysqlbug:`62516` - Fast index creation does not update index statistics |
649 |:Launchpad bug: :bug:`857590` |
650-|:Upstream state: Verified (checked on 2014-03-17) |
651+|:Upstream state: Verified (checked on 2014-04-29) |
652 |:Fix Released: :rn:`5.5.16-22.0` |
653 |:Upstream fix: N/A |
654 +-------------------------------------------------------------------------------------------------------------+
655 |:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format |
656 |:Launchpad bug: N/A |
657-|:Upstream state: Verified (checked on 2014-03-17) |
658+|:Upstream state: Verified (checked on 2014-04-29) |
659 |:Fix Released: :rn:`5.5.15-21.0` |
660 |:Upstream fix: N/A |
661 +-------------------------------------------------------------------------------------------------------------+
662@@ -337,7 +355,7 @@
663 +-------------------------------------------------------------------------------------------------------------+
664 |:Upstream bug: :mysqlbug:`61595` - mysql-test/include/wait_for_slave_param.inc timeout logic is incorrect |
665 |:Launchpad bug: :bug:`800035` |
666-|:Upstream state: Verified (checked on 2014-03-17) |
667+|:Upstream state: Verified (checked on 2014-04-29) |
668 |:Fix Released: :rn:`5.5.13-20.4` |
669 |:Upstream fix: N/A |
670 +-------------------------------------------------------------------------------------------------------------+
671@@ -367,7 +385,7 @@
672 +-------------------------------------------------------------------------------------------------------------+
673 |:Upstream bug: :mysqlbug:`69146` - Optimization in buf_pool_get_oldest_modification if srv_buf_pool_instances|
674 |:Launchpad bug: :bug:`1176496` |
675-|:Upstream state: Open (checked on 2014-03-17) |
676+|:Upstream state: Open (checked on 2014-04-29) |
677 |:Fix Released: :rn:`5.5.8-20.0` |
678 |:Upstream fix: N/A |
679 +-------------------------------------------------------------------------------------------------------------+

Subscribers

People subscribed via source and target branches