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

Proposed by Hrvoje Matijakovic on 2014-04-29
Status: Merged
Approved by: Laurynas Biveinis on 2014-04-30
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) 2014-04-29 Approve on 2014-04-30
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
=== modified file 'doc/source/conf.py'
--- doc/source/conf.py 2014-03-25 12:07:45 +0000
+++ doc/source/conf.py 2014-04-30 09:32:55 +0000
@@ -54,7 +54,7 @@
54# The short X.Y version.54# The short X.Y version.
55version = '5.5'55version = '5.5'
56# The full version, including alpha/beta/rc tags.56# The full version, including alpha/beta/rc tags.
57release = '5.5.36-34.2'57release = '5.5.37-35.0'
5858
59# The language for content autogenerated by Sphinx. Refer to documentation59# The language for content autogenerated by Sphinx. Refer to documentation
60# for a list of supported languages.60# for a list of supported languages.
@@ -110,6 +110,8 @@
110110
111.. |Percona XtraBackup| replace:: *Percona XtraBackup*111.. |Percona XtraBackup| replace:: *Percona XtraBackup*
112112
113.. |Percona Toolkit| replace:: *Percona Toolkit*
114
113.. |Percona Server| replace:: *Percona Server*115.. |Percona Server| replace:: *Percona Server*
114116
115.. |Percona| replace:: *Percona*117.. |Percona| replace:: *Percona*
116118
=== added file 'doc/source/diagnostics/scalability_metrics_plugin.rst'
--- doc/source/diagnostics/scalability_metrics_plugin.rst 1970-01-01 00:00:00 +0000
+++ doc/source/diagnostics/scalability_metrics_plugin.rst 2014-04-30 09:32:55 +0000
@@ -0,0 +1,99 @@
1.. _scalability_metrics_plugin:
2
3=====================================
4 Metrics for scalability measurement
5=====================================
6
7|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.
8
9Installation
10============
11
12Scalability Metrics plugin is shipped with |Percona Server|, but it is not installed by default. To enable the plugin you must run the following command:
13
14.. code-block:: mysql
15
16 INSTALL PLUGIN scalability_metrics SONAME 'scalability_metrics.so';
17
18You can check if the plugin is loaded correctly by running:
19
20.. code-block:: mysql
21
22 SHOW PLUGINS;
23
24The plugin should be listed in the output:
25
26.. code-block:: mysql
27
28 +--------------------------------+----------+--------------------+------------------------+---------+
29 | Name | Status | Type | Library | License |
30 +--------------------------------+----------+--------------------+------------------------+---------+
31 ...
32 | scalability_metrics | ACTIVE | AUDIT | scalability_metrics.so | GPL |
33 +--------------------------------+----------+--------------------+------------------------+---------+
34
35System Variables
36================
37
38.. variable:: scalability_metrics_control
39
40 :version 5.5.37-35.0: Implemented
41 :cli: Yes
42 :scope: Global
43 :dyn: Yes
44 :vartype: String
45 :default: ``OFF``
46 :values: ``OFF``, ``ON``, ``RESET``
47
48This 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.
49
50Status Variables
51================
52
53.. variable:: scalability_metrics_elapsedtime
54
55 :version 5.5.37-35.0: Implemented
56 :vartype: Numeric
57
58This status variable shows total time elapsed since metrics collection was started.
59
60.. variable:: scalability_metrics_queries
61
62 :version 5.5.37-35.0: Implemented
63 :vartype: Numeric
64
65This status variable shows number of completed queries since metrics collection was started.
66
67.. variable:: scalability_metrics_concurrency
68
69 :version 5.5.37-35.0: Implemented
70 :vartype: Numeric
71
72This status variable shows number of queries currently executed.
73
74.. variable:: scalability_metrics_totaltime
75
76 :version 5.5.37-35.0: Implemented
77 :vartype: Numeric
78
79This 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).
80
81.. variable:: scalability_metrics_busytime
82
83 :version 5.5.37-35.0: Implemented
84 :vartype: Numeric
85
86This counter accounts the non-idle server time, that is, time when at least one query was executing.
87
88
89Version Specific Information
90============================
91
92 * :rn:`5.5.37-35.0`
93 Scalability Metrics plugin has been implemented in |Percona Server|.
94
95Other Reading
96=============
97
98* `Fundamental performance and scalability instrumentation <http://www.xaprb.com/blog/2011/10/06/fundamental-performance-and-scalability-instrumentation/>`_
99* `Forecasting MySQL Scalability with the Universal Scalability Law Whitepaper <http://www.percona.com/files/white-papers/forecasting-mysql-scalability.pdf>`_
0100
=== modified file 'doc/source/diagnostics/slow_extended_55.rst'
--- doc/source/diagnostics/slow_extended_55.rst 2013-10-24 14:12:14 +0000
+++ doc/source/diagnostics/slow_extended_55.rst 2014-04-30 09:32:55 +0000
@@ -97,6 +97,8 @@
97 :conf: Yes97 :conf: Yes
98 :scope: Global, session98 :scope: Global, session
99 :dyn: Yes99 :dyn: Yes
100 :default: 1
101 :range: 1-1000
100102
101Behavior of this variable depends from :variable:`log_slow_rate_type`.103Behavior of this variable depends from :variable:`log_slow_rate_type`.
102104
@@ -108,11 +110,12 @@
108 * 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.110 * 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.
109111
110Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`.112Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`.
113
111Decision "log or no" calculated in following manner:114Decision "log or no" calculated in following manner:
112115
113 * if ``log_slow_rate_limit`` is 0 - log every query116 * if ``log_slow_rate_limit`` is 1 - log every query
114117
115 * If ``log_slow_rate_limit`` > 0 - log query when (``query_id`` % ``log_slow_rate_limit``) is zero.118 * If ``log_slow_rate_limit`` > 1 - randomly log every 1/``log_slow_rate_limit`` query.
116119
117This allows flexible setup logging behavior.120This allows flexible setup logging behavior.
118121
@@ -120,6 +123,8 @@
120123
121 Log_slow_rate_type: query Log_slow_rate_limit: 10124 Log_slow_rate_type: query Log_slow_rate_limit: 10
122125
126Prior 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."
127
123.. variable:: log_slow_slave_statements128.. variable:: log_slow_slave_statements
124129
125 :cli: Yes130 :cli: Yes
@@ -176,7 +181,7 @@
176 Equivalent to enabling ``microtime,innodb``.181 Equivalent to enabling ``microtime,innodb``.
177182
178 * ``full``:183 * ``full``:
179 Equivalent to all other values OR'ed together.184 Equivalent to all other values OR'ed together without the ``profiling`` and ``profiling_use_getrusage`` options.
180185
181 * ``profiling``:186 * ``profiling``:
182 Enables profiling of all queries in all connections.187 Enables profiling of all queries in all connections.
183188
=== modified file 'doc/source/index.rst'
--- doc/source/index.rst 2014-03-07 10:28:20 +0000
+++ doc/source/index.rst 2014-04-30 09:32:55 +0000
@@ -137,6 +137,7 @@
137 management/expanded_program_option_modifiers137 management/expanded_program_option_modifiers
138 management/changed_page_tracking138 management/changed_page_tracking
139 management/pam_plugin139 management/pam_plugin
140 management/audit_log_plugin
140141
141Diagnostics Improvements142Diagnostics Improvements
142========================143========================
@@ -157,6 +158,7 @@
157 diagnostics/process_list158 diagnostics/process_list
158 diagnostics/misc_info_schema_tables159 diagnostics/misc_info_schema_tables
159 diagnostics/thread_based_profiling160 diagnostics/thread_based_profiling
161 diagnostics/scalability_metrics_plugin
160162
161Obsolete and Removed Features163Obsolete and Removed Features
162=============================164=============================
163165
=== modified file 'doc/source/installation/apt_repo.rst'
--- doc/source/installation/apt_repo.rst 2013-12-19 12:22:20 +0000
+++ doc/source/installation/apt_repo.rst 2014-04-30 09:32:55 +0000
@@ -42,9 +42,9 @@
4242
43 * 10.04LTS (lucid)43 * 10.04LTS (lucid)
44 * 12.04LTS (precise)44 * 12.04LTS (precise)
45 * 12.10 (quantal)
46 * 13.04 (raring)45 * 13.04 (raring)
47 * 13.10 (saucy)46 * 13.10 (saucy)
47 * 14.04LTS (trusty)
4848
49Percona `apt` Experimental repository49Percona `apt` Experimental repository
50=====================================50=====================================
5151
=== added file 'doc/source/management/audit_log_plugin.rst'
--- doc/source/management/audit_log_plugin.rst 1970-01-01 00:00:00 +0000
+++ doc/source/management/audit_log_plugin.rst 2014-04-30 09:32:55 +0000
@@ -0,0 +1,234 @@
1.. _audit_log_plugin:
2
3==================
4 Audit Log Plugin
5==================
6
7Percona 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>`_
8
9Audit Log plugin produces the log of following events:
10
11* **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.
12
13Example of the Audit event: ::
14
15 <AUDIT_RECORD
16 "NAME"="Audit"
17 "RECORD"="1_2014-04-29T09:29:40"
18 "TIMESTAMP"="2014-04-29T09:29:40 UTC"
19 "MYSQL_VERSION"="5.5.37-35.0-655.trusty"
20 "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"
21 "OS_VERSION"="x86_64-debian-linux-gnu",
22 />
23
24* **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.
25
26Example of the Disconnect event: ::
27
28 <AUDIT_RECORD
29 "NAME"="Quit"
30 "RECORD"="24_2014-04-29T09:29:40"
31 "TIMESTAMP"="2014-04-29T10:20:13 UTC"
32 "CONNECTION_ID"="49"
33 "STATUS"="0"
34 "USER"=""
35 "PRIV_USER"=""
36 "OS_LOGIN"=""
37 "PROXY_USER"=""
38 "HOST"=""
39 "IP"=""
40 "DB"=""
41 />
42
43* **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.
44
45Example of the Query event: ::
46
47 <AUDIT_RECORD
48 "NAME"="Query"
49 "RECORD"="23_2014-04-29T09:29:40"
50 "TIMESTAMP"="2014-04-29T10:20:10 UTC"
51 "COMMAND_CLASS"="select"
52 "CONNECTION_ID"="49"
53 "STATUS"="0"
54 "SQLTEXT"="SELECT * from mysql.user"
55 "USER"="root[root] @ localhost []"
56 "HOST"="localhost"
57 "OS_USER"=""
58 "IP"=""
59 />
60
61Installation
62============
63
64Audit Log plugin is shipped with |Percona Server|, but it is not installed by default. To enable the plugin you must run the following command:
65
66.. code-block:: mysql
67
68 INSTALL PLUGIN audit_log SONAME 'audit_log.so';
69
70You can check if the plugin is loaded correctly by running:
71
72.. code-block:: mysql
73
74 SHOW PLUGINS;
75
76Audit log should be listed in the output:
77
78.. code-block:: mysql
79
80 +--------------------------------+----------+--------------------+--------------+---------+
81 | Name | Status | Type | Library | License |
82 +--------------------------------+----------+--------------------+--------------+---------+
83 ...
84 | audit_log | ACTIVE | AUDIT | audit_log.so | GPL |
85 +--------------------------------+----------+--------------------+--------------+---------+
86
87Log Format
88==========
89
90Audit 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.
91
92Example of the ``OLD`` format: ::
93
94 <AUDIT_RECORD
95 "NAME"="Query"
96 "RECORD"="2_2014-04-28T09:29:40"
97 "TIMESTAMP"="2014-04-28T09:29:40 UTC"
98 "COMMAND_CLASS"="install_plugin"
99 "CONNECTION_ID"="47"
100 "STATUS"="0"
101 "SQLTEXT"="INSTALL PLUGIN audit_log SONAME 'audit_log.so'"
102 "USER"="root[root] @ localhost []"
103 "HOST"="localhost"
104 "OS_USER"=""
105 "IP"=""
106 />
107
108Example of the ``NEW`` format: ::
109
110 <AUDIT_RECORD>
111 <NAME>Quit</NAME>
112 <RECORD>10902_2014-04-28T11:02:54</RECORD>
113 <TIMESTAMP>2014-04-28T11:02:59 UTC</TIMESTAMP>
114 <CONNECTION_ID>36</CONNECTION_ID>
115 <STATUS>0</STATUS>
116 <USER></USER>
117 <PRIV_USER></PRIV_USER>
118 <OS_LOGIN></OS_LOGIN>
119 <PROXY_USER></PROXY_USER>
120 <HOST></HOST>
121 <IP></IP>
122 <DB></DB>
123 </AUDIT_RECORD>
124
125System Variables
126================
127
128.. variable:: audit_log_strategy
129
130 :version 5.5.37-35.0: Implemented
131 :cli: Yes
132 :scope: Global
133 :dyn: No
134 :vartype: String
135 :default: ASYNCHRONOUS
136 :allowed values: ``ASYNCHRONOUS``, ``PERFORMANCE``, ``SEMISYNCHRONOUS``, ``SYNCHRONOUS``
137
138This variable is used to specify the audit log strategy, possible values are:
139
140* ``ASYNCHRONOUS`` - (default) log using memory buffer, do not drop messages if buffer is full
141* ``PERFORMANCE`` - log using memory buffer, drop messages if buffer is full
142* ``SEMISYNCHRONOUS`` - log directly to file, do not flush and sync every event
143* ``SYNCHRONOUS`` - log directly to file, flush and sync every event
144
145.. variable:: audit_log_file
146
147 :version 5.5.37-35.0: Implemented
148 :cli: Yes
149 :scope: Global
150 :dyn: No
151 :vartype: String
152 :default: audit.log
153
154This 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.
155
156.. variable:: audit_log_flush
157
158 :version 5.5.37-35.0: Implemented
159 :cli: Yes
160 :scope: Global
161 :dyn: No
162 :vartype: String
163 :default: OFF
164
165When this variable is set to ``ON`` log file will be closed and reopened. This can be used for manual log rotation.
166
167.. variable:: audit_log_buffer_size
168
169 :version 5.5.37-35.0: Implemented
170 :cli: Yes
171 :scope: Global
172 :dyn: No
173 :vartype: Numeric
174 :default: 4096
175
176This 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.
177
178.. variable:: audit_log_format
179
180 :version 5.5.37-35.0: Implemented
181 :cli: Yes
182 :scope: Global
183 :dyn: No
184 :vartype: String
185 :default: OLD
186 :allowed values: ``OLD``, ``NEW``
187
188This 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.
189
190.. variable:: audit_log_policy
191
192 :version 5.5.37-35.0: Implemented
193 :cli: Yes
194 :scope: Global
195 :dyn: Yes
196 :vartype: String
197 :default: ALL
198 :allowed values: ``ALL``, ``LOGINS``, ``QUERIES``, ``NONE``
199
200This variable is used to specify which events should be logged. Possible values are:
201
202* ``ALL`` - all events will be logged
203* ``LOGINS`` - only logins will be logged
204* ``QUERIES`` - only queries will be logged
205* ``NONE`` - no events will be logged
206
207.. variable:: audit_log_rotate_on_size
208
209 :version 5.5.37-35.0: Implemented
210 :cli: Yes
211 :scope: Global
212 :dyn: No
213 :vartype: Numeric
214 :default: 0 (don't rotate the log file)
215
216This 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.
217
218.. variable:: audit_log_rotations
219
220 :version 5.5.37-35.0: Implemented
221 :cli: Yes
222 :scope: Global
223 :dyn: No
224 :vartype: Numeric
225 :default: 0
226
227This 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.
228
229Version Specific Information
230============================
231
232 * :rn:`5.5.37-35.0`
233 Audit Log plugin has been implemented in |Percona Server|.
234
0235
=== modified file 'doc/source/release-notes/Percona-Server-5.5.29-30.0.rst'
--- doc/source/release-notes/Percona-Server-5.5.29-30.0.rst 2013-02-26 06:01:42 +0000
+++ doc/source/release-notes/Percona-Server-5.5.29-30.0.rst 2014-04-30 09:32:55 +0000
@@ -62,4 +62,4 @@
6262
63 Fixed the incorrect help text for :variable:`slow_query_log_timestamp_precision`. Bug fixed :bug:`1090965` (*Laurynas Biveinis*).63 Fixed the incorrect help text for :variable:`slow_query_log_timestamp_precision`. Bug fixed :bug:`1090965` (*Laurynas Biveinis*).
6464
65Other 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*).65Other 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*).
6666
=== added file 'doc/source/release-notes/Percona-Server-5.5.37-35.0.rst'
--- doc/source/release-notes/Percona-Server-5.5.37-35.0.rst 1970-01-01 00:00:00 +0000
+++ doc/source/release-notes/Percona-Server-5.5.37-35.0.rst 2014-04-30 09:32:55 +0000
@@ -0,0 +1,45 @@
1.. rn:: 5.5.37-35.0
2
3==============================
4 |Percona Server| 5.5.37-35.0
5==============================
6
7Percona 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>`.
8
9Based 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>`_.
10
11New Features
12============
13
14 |Percona Server| now supports :ref:`scalability_metrics_plugin`.
15
16 |Percona Server| now supports :ref:`audit_log_plugin`.
17
18 |Percona Server| packages are now available for *Ubuntu* 14.04.
19
20Bugs Fixed
21==========
22
23 |Percona Server| couldn't be built with *Bison* 3.0. Bug fixed :bug:`1262439`,upstream :mysqlbug:`71250` (*Ryan Gordon*).
24
25 Backported the upstream fix for overflow which would caused replication SQL thread to fail to execute events. Bug fixed :bug:`1070255` (upstream :mysqlbug:`67352`).
26
27 |Percona Server| debug packages were not built for the previous releases. Bug fixed :bug:`1298352`.
28
29 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`.
30
31 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`).
32
33 ``mysqld_safe`` did not correctly parse :variable:`flush_caches` and :variable:`numa_interleave` options. Bug fixed :bug:`1231110`.
34
35 :ref:`threadpool` would handle a new client connection without notifying Audit Plugin. Bug fixed :bug:`1282008`.
36
37 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*).
38
39 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`.
40
41 |Percona Server| source files were referencing *Maatkit* instead of |Percona Toolkit|. Bug fixed :bug:`1174779`.
42
43 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`.
44
45Other bugs fixed: :bug:`1272732`.
046
=== modified file 'doc/source/release-notes/release-notes_index.rst'
--- doc/source/release-notes/release-notes_index.rst 2014-03-25 12:07:45 +0000
+++ doc/source/release-notes/release-notes_index.rst 2014-04-30 09:32:55 +0000
@@ -6,6 +6,7 @@
6 :maxdepth: 16 :maxdepth: 1
7 :glob:7 :glob:
88
9 Percona-Server-5.5.37-35.0
9 Percona-Server-5.5.36-34.210 Percona-Server-5.5.36-34.2
10 Percona-Server-5.5.36-34.111 Percona-Server-5.5.36-34.1
11 Percona-Server-5.5.36-34.012 Percona-Server-5.5.36-34.0
1213
=== modified file 'doc/source/upstream-bug-fixes.rst'
--- doc/source/upstream-bug-fixes.rst 2014-03-17 16:00:34 +0000
+++ doc/source/upstream-bug-fixes.rst 2014-04-30 09:32:55 +0000
@@ -5,15 +5,33 @@
5=============================================================5=============================================================
66
7+-------------------------------------------------------------------------------------------------------------+7+-------------------------------------------------------------------------------------------------------------+
8|:Upstream bug: :mysqlbug:`60782` - Audit plugin API: no MYSQL_AUDIT_GENERAL_LOG notifications with general...|
9|:Launchpad bug: :bug:`1182535` |
10|:Upstream state: Verified (checked on 2014-04-29) |
11|:Fix Released: :rn:`5.5.37-35.0` |
12|:Upstream fix: N/A |
13+-------------------------------------------------------------------------------------------------------------+
14|:Upstream bug: :mysqlbug:`67352` - table_id is defined differently in sql/table.h vs sql/log_event.h |
15|:Launchpad bug: :bug:`1070255` |
16|:Upstream state: Closed |
17|:Fix Released: :rn:`5.5.37-35.0` |
18|:Upstream fix: N/A |
19+-------------------------------------------------------------------------------------------------------------+
20|:Upstream bug: :mysqlbug:`71250` - Bison 3 breaks mysql build |
21|:Launchpad bug: :bug:`1262439` |
22|:Upstream state: Closed |
23|:Fix Released: :rn:`5.5.37-35.0` |
24|:Upstream fix: N/A |
25+-------------------------------------------------------------------------------------------------------------+
8|:Upstream bug: :mysqlbug:`71375` - Slave IO thread won't attempt auto reconnect to the master/error-code 1593|26|:Upstream bug: :mysqlbug:`71375` - Slave IO thread won't attempt auto reconnect to the master/error-code 1593|
9|:Launchpad bug: :bug:`1268735` |27|:Launchpad bug: :bug:`1268735` |
10|:Upstream state: Verified (checked on 2014-03-17) |28|:Upstream state: Verified (checked on 2014-04-29) |
11|:Fix Released: :rn:`5.5.36-34.1` |29|:Fix Released: :rn:`5.5.36-34.1` |
12|:Upstream fix: N/A |30|:Upstream fix: N/A |
13+-------------------------------------------------------------------------------------------------------------+31+-------------------------------------------------------------------------------------------------------------+
14|:Upstream bug: :mysqlbug:`71374` - Slave IO thread won't attempt auto reconnect to the master/error-code 1159|32|:Upstream bug: :mysqlbug:`71374` - Slave IO thread won't attempt auto reconnect to the master/error-code 1159|
15|:Launchpad bug: :bug:`1268729` |33|:Launchpad bug: :bug:`1268729` |
16|:Upstream state: Verified (checked on 2014-03-17) |34|:Upstream state: Verified (checked on 2014-04-29) |
17|:Fix Released: :rn:`5.5.36-34.1` |35|:Fix Released: :rn:`5.5.36-34.1` |
18|:Upstream fix: N/A |36|:Upstream fix: N/A |
19+-------------------------------------------------------------------------------------------------------------+37+-------------------------------------------------------------------------------------------------------------+
@@ -43,7 +61,7 @@
43+-------------------------------------------------------------------------------------------------------------+61+-------------------------------------------------------------------------------------------------------------+
44|:Upstream bug: :mysqlbug:`69639` - mysql failed to build with dtrace Sun D 1.11 |62|:Upstream bug: :mysqlbug:`69639` - mysql failed to build with dtrace Sun D 1.11 |
45|:Launchpad bug: :bug:`1196460` |63|:Launchpad bug: :bug:`1196460` |
46|:Upstream state: Open (checked on 2014-03-17) |64|:Upstream state: Open (checked on 2014-04-29) |
47|:Fix Released: :rn:`5.5.33-31.1` |65|:Fix Released: :rn:`5.5.33-31.1` |
48|:Upstream fix: N/A |66|:Upstream fix: N/A |
49+-------------------------------------------------------------------------------------------------------------+67+-------------------------------------------------------------------------------------------------------------+
@@ -55,7 +73,7 @@
55+-------------------------------------------------------------------------------------------------------------+73+-------------------------------------------------------------------------------------------------------------+
56|:Upstream bug: :mysqlbug:`42415` - UPDATE/DELETE with LIMIT clause unsafe for SBL even with ORDER BY PK ... |74|:Upstream bug: :mysqlbug:`42415` - UPDATE/DELETE with LIMIT clause unsafe for SBL even with ORDER BY PK ... |
57|:Launchpad bug: :bug:`1132194` |75|:Launchpad bug: :bug:`1132194` |
58|:Upstream state: Verified (checked on 2014-03-17) |76|:Upstream state: Verified (checked on 2014-04-29) |
59|:Fix Released: :rn:`5.5.32-31.0` |77|:Fix Released: :rn:`5.5.32-31.0` |
60|:Upstream fix: N/A |78|:Upstream fix: N/A |
61+-------------------------------------------------------------------------------------------------------------+79+-------------------------------------------------------------------------------------------------------------+
@@ -67,7 +85,7 @@
67+-------------------------------------------------------------------------------------------------------------+85+-------------------------------------------------------------------------------------------------------------+
68|:Upstream bug: :mysqlbug:`68970` - fsp_reserve_free_extents switches from small to big tblspace handling ... |86|:Upstream bug: :mysqlbug:`68970` - fsp_reserve_free_extents switches from small to big tblspace handling ... |
69|:Launchpad bug: :bug:`1169494` |87|:Launchpad bug: :bug:`1169494` |
70|:Upstream state: Verified (checked on 2014-03-17) |88|:Upstream state: Verified (checked on 2014-04-29) |
71|:Fix Released: :rn:`5.5.32-31.0` |89|:Fix Released: :rn:`5.5.32-31.0` |
72|:Upstream fix: N/A |90|:Upstream fix: N/A |
73+-------------------------------------------------------------------------------------------------------------+91+-------------------------------------------------------------------------------------------------------------+
@@ -79,7 +97,7 @@
79+-------------------------------------------------------------------------------------------------------------+97+-------------------------------------------------------------------------------------------------------------+
80|:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined |98|:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined |
81|:Launchpad bug: :bug:`1183610` |99|:Launchpad bug: :bug:`1183610` |
82|:Upstream state: No Feedback (checked on 2014-03-17) |100|:Upstream state: No Feedback (checked on 2014-04-29) |
83|:Fix Released: :rn:`5.5.31-30.3` |101|:Fix Released: :rn:`5.5.31-30.3` |
84|:Upstream fix: N/A |102|:Upstream fix: N/A |
85+-------------------------------------------------------------------------------------------------------------+103+-------------------------------------------------------------------------------------------------------------+
@@ -91,7 +109,7 @@
91+-------------------------------------------------------------------------------------------------------------+109+-------------------------------------------------------------------------------------------------------------+
92|:Upstream bug: :mysqlbug:`68845` - Unnecessary log_sys->mutex reacquisition in mtr_log_reserve_and_write() |110|:Upstream bug: :mysqlbug:`68845` - Unnecessary log_sys->mutex reacquisition in mtr_log_reserve_and_write() |
93|:Launchpad bug: :bug:`1163439` |111|:Launchpad bug: :bug:`1163439` |
94|:Upstream state: Verified (checked on 2014-03-17) |112|:Upstream state: Verified (checked on 2014-04-29) |
95|:Fix Released: :rn:`5.5.30-30.2` |113|:Fix Released: :rn:`5.5.30-30.2` |
96|:Upstream fix: N/A |114|:Upstream fix: N/A |
97+-------------------------------------------------------------------------------------------------------------+115+-------------------------------------------------------------------------------------------------------------+
@@ -121,13 +139,13 @@
121+-------------------------------------------------------------------------------------------------------------+139+-------------------------------------------------------------------------------------------------------------+
122|:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() |140|:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() |
123|:Launchpad bug: :bug:`1132350` |141|:Launchpad bug: :bug:`1132350` |
124|:Upstream state: Verified (checked on 2014-03-17) |142|:Upstream state: Verified (checked on 2014-04-29) |
125|:Fix Released: :rn:`5.5.30-30.1` |143|:Fix Released: :rn:`5.5.30-30.1` |
126|:Upstream fix: N/A |144|:Upstream fix: N/A |
127+-------------------------------------------------------------------------------------------------------------+145+-------------------------------------------------------------------------------------------------------------+
128|:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|146|:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|
129|:Launchpad bug: :bug:`1100178` |147|:Launchpad bug: :bug:`1100178` |
130|:Upstream state: Verified (checked on 2014-03-17) |148|:Upstream state: Verified (checked on 2014-04-29) |
131|:Fix Released: :rn:`5.5.29-30.0` |149|:Fix Released: :rn:`5.5.29-30.0` |
132|:Upstream fix: N/A |150|:Upstream fix: N/A |
133+-------------------------------------------------------------------------------------------------------------+151+-------------------------------------------------------------------------------------------------------------+
@@ -229,7 +247,7 @@
229+-------------------------------------------------------------------------------------------------------------+247+-------------------------------------------------------------------------------------------------------------+
230|:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|248|:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|
231|:Launchpad bug: :bug:`1042517` |249|:Launchpad bug: :bug:`1042517` |
232|:Upstream state: Verified (checked on 2014-03-17) |250|:Upstream state: Verified (checked on 2014-04-29) |
233|:Fix Released: :rn:`5.5.27-29.0` |251|:Fix Released: :rn:`5.5.27-29.0` |
234|:Upstream fix: N/A |252|:Upstream fix: N/A |
235+-------------------------------------------------------------------------------------------------------------+253+-------------------------------------------------------------------------------------------------------------+
@@ -241,7 +259,7 @@
241+-------------------------------------------------------------------------------------------------------------+259+-------------------------------------------------------------------------------------------------------------+
242|:Upstream bug: :mysqlbug:`64800` - mysqldump with --include-master-host-port putting quotes around port no. | 260|:Upstream bug: :mysqlbug:`64800` - mysqldump with --include-master-host-port putting quotes around port no. |
243|:Launchpad bug: :bug:`1013432` |261|:Launchpad bug: :bug:`1013432` |
244|:Upstream state: Verified (checked on 2014-03-17) |262|:Upstream state: Verified (checked on 2014-04-29) |
245|:Fix Released: :rn:`5.5.27-28.0` |263|:Fix Released: :rn:`5.5.27-28.0` |
246|:Upstream fix: N/A |264|:Upstream fix: N/A |
247+-------------------------------------------------------------------------------------------------------------+265+-------------------------------------------------------------------------------------------------------------+
@@ -289,7 +307,7 @@
289+-------------------------------------------------------------------------------------------------------------+307+-------------------------------------------------------------------------------------------------------------+
290|:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |308|:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |
291|:Launchpad bug: :bug:`1262651` |309|:Launchpad bug: :bug:`1262651` |
292|:Upstream state: Verified (checked on 2014-03-17) |310|:Upstream state: Verified (checked on 2014-04-29) |
293|:Fix Released: :rn:`5.5.20-24.1` |311|:Fix Released: :rn:`5.5.20-24.1` |
294|:Upstream fix: N/A |312|:Upstream fix: N/A |
295+-------------------------------------------------------------------------------------------------------------+313+-------------------------------------------------------------------------------------------------------------+
@@ -313,13 +331,13 @@
313+-------------------------------------------------------------------------------------------------------------+331+-------------------------------------------------------------------------------------------------------------+
314|:Upstream bug: :mysqlbug:`62516` - Fast index creation does not update index statistics |332|:Upstream bug: :mysqlbug:`62516` - Fast index creation does not update index statistics |
315|:Launchpad bug: :bug:`857590` |333|:Launchpad bug: :bug:`857590` |
316|:Upstream state: Verified (checked on 2014-03-17) |334|:Upstream state: Verified (checked on 2014-04-29) |
317|:Fix Released: :rn:`5.5.16-22.0` |335|:Fix Released: :rn:`5.5.16-22.0` |
318|:Upstream fix: N/A |336|:Upstream fix: N/A |
319+-------------------------------------------------------------------------------------------------------------+337+-------------------------------------------------------------------------------------------------------------+
320|:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format |338|:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format |
321|:Launchpad bug: N/A |339|:Launchpad bug: N/A |
322|:Upstream state: Verified (checked on 2014-03-17) |340|:Upstream state: Verified (checked on 2014-04-29) |
323|:Fix Released: :rn:`5.5.15-21.0` |341|:Fix Released: :rn:`5.5.15-21.0` |
324|:Upstream fix: N/A |342|:Upstream fix: N/A |
325+-------------------------------------------------------------------------------------------------------------+343+-------------------------------------------------------------------------------------------------------------+
@@ -337,7 +355,7 @@
337+-------------------------------------------------------------------------------------------------------------+355+-------------------------------------------------------------------------------------------------------------+
338|:Upstream bug: :mysqlbug:`61595` - mysql-test/include/wait_for_slave_param.inc timeout logic is incorrect |356|:Upstream bug: :mysqlbug:`61595` - mysql-test/include/wait_for_slave_param.inc timeout logic is incorrect |
339|:Launchpad bug: :bug:`800035` |357|:Launchpad bug: :bug:`800035` |
340|:Upstream state: Verified (checked on 2014-03-17) |358|:Upstream state: Verified (checked on 2014-04-29) |
341|:Fix Released: :rn:`5.5.13-20.4` |359|:Fix Released: :rn:`5.5.13-20.4` |
342|:Upstream fix: N/A |360|:Upstream fix: N/A |
343+-------------------------------------------------------------------------------------------------------------+361+-------------------------------------------------------------------------------------------------------------+
@@ -367,7 +385,7 @@
367+-------------------------------------------------------------------------------------------------------------+385+-------------------------------------------------------------------------------------------------------------+
368|:Upstream bug: :mysqlbug:`69146` - Optimization in buf_pool_get_oldest_modification if srv_buf_pool_instances|386|:Upstream bug: :mysqlbug:`69146` - Optimization in buf_pool_get_oldest_modification if srv_buf_pool_instances|
369|:Launchpad bug: :bug:`1176496` |387|:Launchpad bug: :bug:`1176496` |
370|:Upstream state: Open (checked on 2014-03-17) |388|:Upstream state: Open (checked on 2014-04-29) |
371|:Fix Released: :rn:`5.5.8-20.0` |389|:Fix Released: :rn:`5.5.8-20.0` |
372|:Upstream fix: N/A |390|:Upstream fix: N/A |
373+-------------------------------------------------------------------------------------------------------------+391+-------------------------------------------------------------------------------------------------------------+

Subscribers

People subscribed via source and target branches