Merge lp:~hrvojem/percona-server/rn-5.5.37-35.0-5.5 into lp:percona-server/5.5
- rn-5.5.37-35.0-5.5
- Merge into 5.5
Status: | Merged |
---|---|
Approved by: | Laurynas Biveinis |
Approved revision: | no longer in the source branch. |
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 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Review via email: mp+217579@code.launchpad.net |
Commit message
Description of the change
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- 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
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- 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_
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
implement
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.
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- 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.
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- From the previous review:
- 33: link to USL on Percona site (the other two things are easily
googlable, this one not particularly).
Laurynas Biveinis (laurynas-biveinis) : | # |
Preview Diff
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 | 54 | # The short X.Y version. | 54 | # The short X.Y version. |
6 | 55 | version = '5.5' | 55 | version = '5.5' |
7 | 56 | # The full version, including alpha/beta/rc tags. | 56 | # The full version, including alpha/beta/rc tags. |
9 | 57 | release = '5.5.36-34.2' | 57 | release = '5.5.37-35.0' |
10 | 58 | 58 | ||
11 | 59 | # The language for content autogenerated by Sphinx. Refer to documentation | 59 | # The language for content autogenerated by Sphinx. Refer to documentation |
12 | 60 | # for a list of supported languages. | 60 | # for a list of supported languages. |
13 | @@ -110,6 +110,8 @@ | |||
14 | 110 | 110 | ||
15 | 111 | .. |Percona XtraBackup| replace:: *Percona XtraBackup* | 111 | .. |Percona XtraBackup| replace:: *Percona XtraBackup* |
16 | 112 | 112 | ||
17 | 113 | .. |Percona Toolkit| replace:: *Percona Toolkit* | ||
18 | 114 | |||
19 | 113 | .. |Percona Server| replace:: *Percona Server* | 115 | .. |Percona Server| replace:: *Percona Server* |
20 | 114 | 116 | ||
21 | 115 | .. |Percona| replace:: *Percona* | 117 | .. |Percona| replace:: *Percona* |
22 | 116 | 118 | ||
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 | 1 | .. _scalability_metrics_plugin: | ||
28 | 2 | |||
29 | 3 | ===================================== | ||
30 | 4 | Metrics for scalability measurement | ||
31 | 5 | ===================================== | ||
32 | 6 | |||
33 | 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. | ||
34 | 8 | |||
35 | 9 | Installation | ||
36 | 10 | ============ | ||
37 | 11 | |||
38 | 12 | 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 | 13 | |||
40 | 14 | .. code-block:: mysql | ||
41 | 15 | |||
42 | 16 | INSTALL PLUGIN scalability_metrics SONAME 'scalability_metrics.so'; | ||
43 | 17 | |||
44 | 18 | You can check if the plugin is loaded correctly by running: | ||
45 | 19 | |||
46 | 20 | .. code-block:: mysql | ||
47 | 21 | |||
48 | 22 | SHOW PLUGINS; | ||
49 | 23 | |||
50 | 24 | The plugin should be listed in the output: | ||
51 | 25 | |||
52 | 26 | .. code-block:: mysql | ||
53 | 27 | |||
54 | 28 | +--------------------------------+----------+--------------------+------------------------+---------+ | ||
55 | 29 | | Name | Status | Type | Library | License | | ||
56 | 30 | +--------------------------------+----------+--------------------+------------------------+---------+ | ||
57 | 31 | ... | ||
58 | 32 | | scalability_metrics | ACTIVE | AUDIT | scalability_metrics.so | GPL | | ||
59 | 33 | +--------------------------------+----------+--------------------+------------------------+---------+ | ||
60 | 34 | |||
61 | 35 | System Variables | ||
62 | 36 | ================ | ||
63 | 37 | |||
64 | 38 | .. variable:: scalability_metrics_control | ||
65 | 39 | |||
66 | 40 | :version 5.5.37-35.0: Implemented | ||
67 | 41 | :cli: Yes | ||
68 | 42 | :scope: Global | ||
69 | 43 | :dyn: Yes | ||
70 | 44 | :vartype: String | ||
71 | 45 | :default: ``OFF`` | ||
72 | 46 | :values: ``OFF``, ``ON``, ``RESET`` | ||
73 | 47 | |||
74 | 48 | 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 | 49 | |||
76 | 50 | Status Variables | ||
77 | 51 | ================ | ||
78 | 52 | |||
79 | 53 | .. variable:: scalability_metrics_elapsedtime | ||
80 | 54 | |||
81 | 55 | :version 5.5.37-35.0: Implemented | ||
82 | 56 | :vartype: Numeric | ||
83 | 57 | |||
84 | 58 | This status variable shows total time elapsed since metrics collection was started. | ||
85 | 59 | |||
86 | 60 | .. variable:: scalability_metrics_queries | ||
87 | 61 | |||
88 | 62 | :version 5.5.37-35.0: Implemented | ||
89 | 63 | :vartype: Numeric | ||
90 | 64 | |||
91 | 65 | This status variable shows number of completed queries since metrics collection was started. | ||
92 | 66 | |||
93 | 67 | .. variable:: scalability_metrics_concurrency | ||
94 | 68 | |||
95 | 69 | :version 5.5.37-35.0: Implemented | ||
96 | 70 | :vartype: Numeric | ||
97 | 71 | |||
98 | 72 | This status variable shows number of queries currently executed. | ||
99 | 73 | |||
100 | 74 | .. variable:: scalability_metrics_totaltime | ||
101 | 75 | |||
102 | 76 | :version 5.5.37-35.0: Implemented | ||
103 | 77 | :vartype: Numeric | ||
104 | 78 | |||
105 | 79 | 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 | 80 | |||
107 | 81 | .. variable:: scalability_metrics_busytime | ||
108 | 82 | |||
109 | 83 | :version 5.5.37-35.0: Implemented | ||
110 | 84 | :vartype: Numeric | ||
111 | 85 | |||
112 | 86 | This counter accounts the non-idle server time, that is, time when at least one query was executing. | ||
113 | 87 | |||
114 | 88 | |||
115 | 89 | Version Specific Information | ||
116 | 90 | ============================ | ||
117 | 91 | |||
118 | 92 | * :rn:`5.5.37-35.0` | ||
119 | 93 | Scalability Metrics plugin has been implemented in |Percona Server|. | ||
120 | 94 | |||
121 | 95 | Other Reading | ||
122 | 96 | ============= | ||
123 | 97 | |||
124 | 98 | * `Fundamental performance and scalability instrumentation <http://www.xaprb.com/blog/2011/10/06/fundamental-performance-and-scalability-instrumentation/>`_ | ||
125 | 99 | * `Forecasting MySQL Scalability with the Universal Scalability Law Whitepaper <http://www.percona.com/files/white-papers/forecasting-mysql-scalability.pdf>`_ | ||
126 | 0 | 100 | ||
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 | 97 | :conf: Yes | 97 | :conf: Yes |
132 | 98 | :scope: Global, session | 98 | :scope: Global, session |
133 | 99 | :dyn: Yes | 99 | :dyn: Yes |
134 | 100 | :default: 1 | ||
135 | 101 | :range: 1-1000 | ||
136 | 100 | 102 | ||
137 | 101 | Behavior of this variable depends from :variable:`log_slow_rate_type`. | 103 | Behavior of this variable depends from :variable:`log_slow_rate_type`. |
138 | 102 | 104 | ||
139 | @@ -108,11 +110,12 @@ | |||
140 | 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. |
141 | 109 | 111 | ||
142 | 110 | Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`. | 112 | Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`. |
143 | 113 | |||
144 | 111 | Decision "log or no" calculated in following manner: | 114 | Decision "log or no" calculated in following manner: |
145 | 112 | 115 | ||
147 | 113 | * if ``log_slow_rate_limit`` is 0 - log every query | 116 | * if ``log_slow_rate_limit`` is 1 - log every query |
148 | 114 | 117 | ||
150 | 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. |
151 | 116 | 119 | ||
152 | 117 | This allows flexible setup logging behavior. | 120 | This allows flexible setup logging behavior. |
153 | 118 | 121 | ||
154 | @@ -120,6 +123,8 @@ | |||
155 | 120 | 123 | ||
156 | 121 | Log_slow_rate_type: query Log_slow_rate_limit: 10 | 124 | Log_slow_rate_type: query Log_slow_rate_limit: 10 |
157 | 122 | 125 | ||
158 | 126 | 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 | 127 | |||
160 | 123 | .. variable:: log_slow_slave_statements | 128 | .. variable:: log_slow_slave_statements |
161 | 124 | 129 | ||
162 | 125 | :cli: Yes | 130 | :cli: Yes |
163 | @@ -176,7 +181,7 @@ | |||
164 | 176 | Equivalent to enabling ``microtime,innodb``. | 181 | Equivalent to enabling ``microtime,innodb``. |
165 | 177 | 182 | ||
166 | 178 | * ``full``: | 183 | * ``full``: |
168 | 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. |
169 | 180 | 185 | ||
170 | 181 | * ``profiling``: | 186 | * ``profiling``: |
171 | 182 | Enables profiling of all queries in all connections. | 187 | Enables profiling of all queries in all connections. |
172 | 183 | 188 | ||
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 | 137 | management/expanded_program_option_modifiers | 137 | management/expanded_program_option_modifiers |
178 | 138 | management/changed_page_tracking | 138 | management/changed_page_tracking |
179 | 139 | management/pam_plugin | 139 | management/pam_plugin |
180 | 140 | management/audit_log_plugin | ||
181 | 140 | 141 | ||
182 | 141 | Diagnostics Improvements | 142 | Diagnostics Improvements |
183 | 142 | ======================== | 143 | ======================== |
184 | @@ -157,6 +158,7 @@ | |||
185 | 157 | diagnostics/process_list | 158 | diagnostics/process_list |
186 | 158 | diagnostics/misc_info_schema_tables | 159 | diagnostics/misc_info_schema_tables |
187 | 159 | diagnostics/thread_based_profiling | 160 | diagnostics/thread_based_profiling |
188 | 161 | diagnostics/scalability_metrics_plugin | ||
189 | 160 | 162 | ||
190 | 161 | Obsolete and Removed Features | 163 | Obsolete and Removed Features |
191 | 162 | ============================= | 164 | ============================= |
192 | 163 | 165 | ||
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 | 42 | 42 | ||
198 | 43 | * 10.04LTS (lucid) | 43 | * 10.04LTS (lucid) |
199 | 44 | * 12.04LTS (precise) | 44 | * 12.04LTS (precise) |
200 | 45 | * 12.10 (quantal) | ||
201 | 46 | * 13.04 (raring) | 45 | * 13.04 (raring) |
202 | 47 | * 13.10 (saucy) | 46 | * 13.10 (saucy) |
203 | 47 | * 14.04LTS (trusty) | ||
204 | 48 | 48 | ||
205 | 49 | Percona `apt` Experimental repository | 49 | Percona `apt` Experimental repository |
206 | 50 | ===================================== | 50 | ===================================== |
207 | 51 | 51 | ||
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 | 1 | .. _audit_log_plugin: | ||
213 | 2 | |||
214 | 3 | ================== | ||
215 | 4 | Audit Log Plugin | ||
216 | 5 | ================== | ||
217 | 6 | |||
218 | 7 | 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 | 8 | |||
220 | 9 | Audit Log plugin produces the log of following events: | ||
221 | 10 | |||
222 | 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. | ||
223 | 12 | |||
224 | 13 | Example of the Audit event: :: | ||
225 | 14 | |||
226 | 15 | <AUDIT_RECORD | ||
227 | 16 | "NAME"="Audit" | ||
228 | 17 | "RECORD"="1_2014-04-29T09:29:40" | ||
229 | 18 | "TIMESTAMP"="2014-04-29T09:29:40 UTC" | ||
230 | 19 | "MYSQL_VERSION"="5.5.37-35.0-655.trusty" | ||
231 | 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" | ||
232 | 21 | "OS_VERSION"="x86_64-debian-linux-gnu", | ||
233 | 22 | /> | ||
234 | 23 | |||
235 | 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. | ||
236 | 25 | |||
237 | 26 | Example of the Disconnect event: :: | ||
238 | 27 | |||
239 | 28 | <AUDIT_RECORD | ||
240 | 29 | "NAME"="Quit" | ||
241 | 30 | "RECORD"="24_2014-04-29T09:29:40" | ||
242 | 31 | "TIMESTAMP"="2014-04-29T10:20:13 UTC" | ||
243 | 32 | "CONNECTION_ID"="49" | ||
244 | 33 | "STATUS"="0" | ||
245 | 34 | "USER"="" | ||
246 | 35 | "PRIV_USER"="" | ||
247 | 36 | "OS_LOGIN"="" | ||
248 | 37 | "PROXY_USER"="" | ||
249 | 38 | "HOST"="" | ||
250 | 39 | "IP"="" | ||
251 | 40 | "DB"="" | ||
252 | 41 | /> | ||
253 | 42 | |||
254 | 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. | ||
255 | 44 | |||
256 | 45 | Example of the Query event: :: | ||
257 | 46 | |||
258 | 47 | <AUDIT_RECORD | ||
259 | 48 | "NAME"="Query" | ||
260 | 49 | "RECORD"="23_2014-04-29T09:29:40" | ||
261 | 50 | "TIMESTAMP"="2014-04-29T10:20:10 UTC" | ||
262 | 51 | "COMMAND_CLASS"="select" | ||
263 | 52 | "CONNECTION_ID"="49" | ||
264 | 53 | "STATUS"="0" | ||
265 | 54 | "SQLTEXT"="SELECT * from mysql.user" | ||
266 | 55 | "USER"="root[root] @ localhost []" | ||
267 | 56 | "HOST"="localhost" | ||
268 | 57 | "OS_USER"="" | ||
269 | 58 | "IP"="" | ||
270 | 59 | /> | ||
271 | 60 | |||
272 | 61 | Installation | ||
273 | 62 | ============ | ||
274 | 63 | |||
275 | 64 | 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 | 65 | |||
277 | 66 | .. code-block:: mysql | ||
278 | 67 | |||
279 | 68 | INSTALL PLUGIN audit_log SONAME 'audit_log.so'; | ||
280 | 69 | |||
281 | 70 | You can check if the plugin is loaded correctly by running: | ||
282 | 71 | |||
283 | 72 | .. code-block:: mysql | ||
284 | 73 | |||
285 | 74 | SHOW PLUGINS; | ||
286 | 75 | |||
287 | 76 | Audit log should be listed in the output: | ||
288 | 77 | |||
289 | 78 | .. code-block:: mysql | ||
290 | 79 | |||
291 | 80 | +--------------------------------+----------+--------------------+--------------+---------+ | ||
292 | 81 | | Name | Status | Type | Library | License | | ||
293 | 82 | +--------------------------------+----------+--------------------+--------------+---------+ | ||
294 | 83 | ... | ||
295 | 84 | | audit_log | ACTIVE | AUDIT | audit_log.so | GPL | | ||
296 | 85 | +--------------------------------+----------+--------------------+--------------+---------+ | ||
297 | 86 | |||
298 | 87 | Log Format | ||
299 | 88 | ========== | ||
300 | 89 | |||
301 | 90 | 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 | 91 | |||
303 | 92 | Example of the ``OLD`` format: :: | ||
304 | 93 | |||
305 | 94 | <AUDIT_RECORD | ||
306 | 95 | "NAME"="Query" | ||
307 | 96 | "RECORD"="2_2014-04-28T09:29:40" | ||
308 | 97 | "TIMESTAMP"="2014-04-28T09:29:40 UTC" | ||
309 | 98 | "COMMAND_CLASS"="install_plugin" | ||
310 | 99 | "CONNECTION_ID"="47" | ||
311 | 100 | "STATUS"="0" | ||
312 | 101 | "SQLTEXT"="INSTALL PLUGIN audit_log SONAME 'audit_log.so'" | ||
313 | 102 | "USER"="root[root] @ localhost []" | ||
314 | 103 | "HOST"="localhost" | ||
315 | 104 | "OS_USER"="" | ||
316 | 105 | "IP"="" | ||
317 | 106 | /> | ||
318 | 107 | |||
319 | 108 | Example of the ``NEW`` format: :: | ||
320 | 109 | |||
321 | 110 | <AUDIT_RECORD> | ||
322 | 111 | <NAME>Quit</NAME> | ||
323 | 112 | <RECORD>10902_2014-04-28T11:02:54</RECORD> | ||
324 | 113 | <TIMESTAMP>2014-04-28T11:02:59 UTC</TIMESTAMP> | ||
325 | 114 | <CONNECTION_ID>36</CONNECTION_ID> | ||
326 | 115 | <STATUS>0</STATUS> | ||
327 | 116 | <USER></USER> | ||
328 | 117 | <PRIV_USER></PRIV_USER> | ||
329 | 118 | <OS_LOGIN></OS_LOGIN> | ||
330 | 119 | <PROXY_USER></PROXY_USER> | ||
331 | 120 | <HOST></HOST> | ||
332 | 121 | <IP></IP> | ||
333 | 122 | <DB></DB> | ||
334 | 123 | </AUDIT_RECORD> | ||
335 | 124 | |||
336 | 125 | System Variables | ||
337 | 126 | ================ | ||
338 | 127 | |||
339 | 128 | .. variable:: audit_log_strategy | ||
340 | 129 | |||
341 | 130 | :version 5.5.37-35.0: Implemented | ||
342 | 131 | :cli: Yes | ||
343 | 132 | :scope: Global | ||
344 | 133 | :dyn: No | ||
345 | 134 | :vartype: String | ||
346 | 135 | :default: ASYNCHRONOUS | ||
347 | 136 | :allowed values: ``ASYNCHRONOUS``, ``PERFORMANCE``, ``SEMISYNCHRONOUS``, ``SYNCHRONOUS`` | ||
348 | 137 | |||
349 | 138 | This variable is used to specify the audit log strategy, possible values are: | ||
350 | 139 | |||
351 | 140 | * ``ASYNCHRONOUS`` - (default) log using memory buffer, do not drop messages if buffer is full | ||
352 | 141 | * ``PERFORMANCE`` - log using memory buffer, drop messages if buffer is full | ||
353 | 142 | * ``SEMISYNCHRONOUS`` - log directly to file, do not flush and sync every event | ||
354 | 143 | * ``SYNCHRONOUS`` - log directly to file, flush and sync every event | ||
355 | 144 | |||
356 | 145 | .. variable:: audit_log_file | ||
357 | 146 | |||
358 | 147 | :version 5.5.37-35.0: Implemented | ||
359 | 148 | :cli: Yes | ||
360 | 149 | :scope: Global | ||
361 | 150 | :dyn: No | ||
362 | 151 | :vartype: String | ||
363 | 152 | :default: audit.log | ||
364 | 153 | |||
365 | 154 | 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 | 155 | |||
367 | 156 | .. variable:: audit_log_flush | ||
368 | 157 | |||
369 | 158 | :version 5.5.37-35.0: Implemented | ||
370 | 159 | :cli: Yes | ||
371 | 160 | :scope: Global | ||
372 | 161 | :dyn: No | ||
373 | 162 | :vartype: String | ||
374 | 163 | :default: OFF | ||
375 | 164 | |||
376 | 165 | When this variable is set to ``ON`` log file will be closed and reopened. This can be used for manual log rotation. | ||
377 | 166 | |||
378 | 167 | .. variable:: audit_log_buffer_size | ||
379 | 168 | |||
380 | 169 | :version 5.5.37-35.0: Implemented | ||
381 | 170 | :cli: Yes | ||
382 | 171 | :scope: Global | ||
383 | 172 | :dyn: No | ||
384 | 173 | :vartype: Numeric | ||
385 | 174 | :default: 4096 | ||
386 | 175 | |||
387 | 176 | 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 | 177 | |||
389 | 178 | .. variable:: audit_log_format | ||
390 | 179 | |||
391 | 180 | :version 5.5.37-35.0: Implemented | ||
392 | 181 | :cli: Yes | ||
393 | 182 | :scope: Global | ||
394 | 183 | :dyn: No | ||
395 | 184 | :vartype: String | ||
396 | 185 | :default: OLD | ||
397 | 186 | :allowed values: ``OLD``, ``NEW`` | ||
398 | 187 | |||
399 | 188 | 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 | 189 | |||
401 | 190 | .. variable:: audit_log_policy | ||
402 | 191 | |||
403 | 192 | :version 5.5.37-35.0: Implemented | ||
404 | 193 | :cli: Yes | ||
405 | 194 | :scope: Global | ||
406 | 195 | :dyn: Yes | ||
407 | 196 | :vartype: String | ||
408 | 197 | :default: ALL | ||
409 | 198 | :allowed values: ``ALL``, ``LOGINS``, ``QUERIES``, ``NONE`` | ||
410 | 199 | |||
411 | 200 | This variable is used to specify which events should be logged. Possible values are: | ||
412 | 201 | |||
413 | 202 | * ``ALL`` - all events will be logged | ||
414 | 203 | * ``LOGINS`` - only logins will be logged | ||
415 | 204 | * ``QUERIES`` - only queries will be logged | ||
416 | 205 | * ``NONE`` - no events will be logged | ||
417 | 206 | |||
418 | 207 | .. variable:: audit_log_rotate_on_size | ||
419 | 208 | |||
420 | 209 | :version 5.5.37-35.0: Implemented | ||
421 | 210 | :cli: Yes | ||
422 | 211 | :scope: Global | ||
423 | 212 | :dyn: No | ||
424 | 213 | :vartype: Numeric | ||
425 | 214 | :default: 0 (don't rotate the log file) | ||
426 | 215 | |||
427 | 216 | 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 | 217 | |||
429 | 218 | .. variable:: audit_log_rotations | ||
430 | 219 | |||
431 | 220 | :version 5.5.37-35.0: Implemented | ||
432 | 221 | :cli: Yes | ||
433 | 222 | :scope: Global | ||
434 | 223 | :dyn: No | ||
435 | 224 | :vartype: Numeric | ||
436 | 225 | :default: 0 | ||
437 | 226 | |||
438 | 227 | 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 | 228 | |||
440 | 229 | Version Specific Information | ||
441 | 230 | ============================ | ||
442 | 231 | |||
443 | 232 | * :rn:`5.5.37-35.0` | ||
444 | 233 | Audit Log plugin has been implemented in |Percona Server|. | ||
445 | 234 | |||
446 | 0 | 235 | ||
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 | 62 | 62 | ||
452 | 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*). |
453 | 64 | 64 | ||
455 | 65 | 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*). | 65 | 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 | 66 | 66 | ||
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 | 1 | .. rn:: 5.5.37-35.0 | ||
462 | 2 | |||
463 | 3 | ============================== | ||
464 | 4 | |Percona Server| 5.5.37-35.0 | ||
465 | 5 | ============================== | ||
466 | 6 | |||
467 | 7 | 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 | 8 | |||
469 | 9 | 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 | 10 | |||
471 | 11 | New Features | ||
472 | 12 | ============ | ||
473 | 13 | |||
474 | 14 | |Percona Server| now supports :ref:`scalability_metrics_plugin`. | ||
475 | 15 | |||
476 | 16 | |Percona Server| now supports :ref:`audit_log_plugin`. | ||
477 | 17 | |||
478 | 18 | |Percona Server| packages are now available for *Ubuntu* 14.04. | ||
479 | 19 | |||
480 | 20 | Bugs Fixed | ||
481 | 21 | ========== | ||
482 | 22 | |||
483 | 23 | |Percona Server| couldn't be built with *Bison* 3.0. Bug fixed :bug:`1262439`,upstream :mysqlbug:`71250` (*Ryan Gordon*). | ||
484 | 24 | |||
485 | 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`). | ||
486 | 26 | |||
487 | 27 | |Percona Server| debug packages were not built for the previous releases. Bug fixed :bug:`1298352`. | ||
488 | 28 | |||
489 | 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`. | ||
490 | 30 | |||
491 | 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`). | ||
492 | 32 | |||
493 | 33 | ``mysqld_safe`` did not correctly parse :variable:`flush_caches` and :variable:`numa_interleave` options. Bug fixed :bug:`1231110`. | ||
494 | 34 | |||
495 | 35 | :ref:`threadpool` would handle a new client connection without notifying Audit Plugin. Bug fixed :bug:`1282008`. | ||
496 | 36 | |||
497 | 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*). | ||
498 | 38 | |||
499 | 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`. | ||
500 | 40 | |||
501 | 41 | |Percona Server| source files were referencing *Maatkit* instead of |Percona Toolkit|. Bug fixed :bug:`1174779`. | ||
502 | 42 | |||
503 | 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`. | ||
504 | 44 | |||
505 | 45 | Other bugs fixed: :bug:`1272732`. | ||
506 | 0 | 46 | ||
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 | 6 | :maxdepth: 1 | 6 | :maxdepth: 1 |
512 | 7 | :glob: | 7 | :glob: |
513 | 8 | 8 | ||
514 | 9 | Percona-Server-5.5.37-35.0 | ||
515 | 9 | Percona-Server-5.5.36-34.2 | 10 | Percona-Server-5.5.36-34.2 |
516 | 10 | Percona-Server-5.5.36-34.1 | 11 | Percona-Server-5.5.36-34.1 |
517 | 11 | Percona-Server-5.5.36-34.0 | 12 | Percona-Server-5.5.36-34.0 |
518 | 12 | 13 | ||
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 | 5 | ============================================================= | 5 | ============================================================= |
524 | 6 | 6 | ||
525 | 7 | +-------------------------------------------------------------------------------------------------------------+ | 7 | +-------------------------------------------------------------------------------------------------------------+ |
526 | 8 | |:Upstream bug: :mysqlbug:`60782` - Audit plugin API: no MYSQL_AUDIT_GENERAL_LOG notifications with general...| | ||
527 | 9 | |:Launchpad bug: :bug:`1182535` | | ||
528 | 10 | |:Upstream state: Verified (checked on 2014-04-29) | | ||
529 | 11 | |:Fix Released: :rn:`5.5.37-35.0` | | ||
530 | 12 | |:Upstream fix: N/A | | ||
531 | 13 | +-------------------------------------------------------------------------------------------------------------+ | ||
532 | 14 | |:Upstream bug: :mysqlbug:`67352` - table_id is defined differently in sql/table.h vs sql/log_event.h | | ||
533 | 15 | |:Launchpad bug: :bug:`1070255` | | ||
534 | 16 | |:Upstream state: Closed | | ||
535 | 17 | |:Fix Released: :rn:`5.5.37-35.0` | | ||
536 | 18 | |:Upstream fix: N/A | | ||
537 | 19 | +-------------------------------------------------------------------------------------------------------------+ | ||
538 | 20 | |:Upstream bug: :mysqlbug:`71250` - Bison 3 breaks mysql build | | ||
539 | 21 | |:Launchpad bug: :bug:`1262439` | | ||
540 | 22 | |:Upstream state: Closed | | ||
541 | 23 | |:Fix Released: :rn:`5.5.37-35.0` | | ||
542 | 24 | |:Upstream fix: N/A | | ||
543 | 25 | +-------------------------------------------------------------------------------------------------------------+ | ||
544 | 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| |
545 | 9 | |:Launchpad bug: :bug:`1268735` | | 27 | |:Launchpad bug: :bug:`1268735` | |
547 | 10 | |:Upstream state: Verified (checked on 2014-03-17) | | 28 | |:Upstream state: Verified (checked on 2014-04-29) | |
548 | 11 | |:Fix Released: :rn:`5.5.36-34.1` | | 29 | |:Fix Released: :rn:`5.5.36-34.1` | |
549 | 12 | |:Upstream fix: N/A | | 30 | |:Upstream fix: N/A | |
550 | 13 | +-------------------------------------------------------------------------------------------------------------+ | 31 | +-------------------------------------------------------------------------------------------------------------+ |
551 | 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| |
552 | 15 | |:Launchpad bug: :bug:`1268729` | | 33 | |:Launchpad bug: :bug:`1268729` | |
554 | 16 | |:Upstream state: Verified (checked on 2014-03-17) | | 34 | |:Upstream state: Verified (checked on 2014-04-29) | |
555 | 17 | |:Fix Released: :rn:`5.5.36-34.1` | | 35 | |:Fix Released: :rn:`5.5.36-34.1` | |
556 | 18 | |:Upstream fix: N/A | | 36 | |:Upstream fix: N/A | |
557 | 19 | +-------------------------------------------------------------------------------------------------------------+ | 37 | +-------------------------------------------------------------------------------------------------------------+ |
558 | @@ -43,7 +61,7 @@ | |||
559 | 43 | +-------------------------------------------------------------------------------------------------------------+ | 61 | +-------------------------------------------------------------------------------------------------------------+ |
560 | 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 | |
561 | 45 | |:Launchpad bug: :bug:`1196460` | | 63 | |:Launchpad bug: :bug:`1196460` | |
563 | 46 | |:Upstream state: Open (checked on 2014-03-17) | | 64 | |:Upstream state: Open (checked on 2014-04-29) | |
564 | 47 | |:Fix Released: :rn:`5.5.33-31.1` | | 65 | |:Fix Released: :rn:`5.5.33-31.1` | |
565 | 48 | |:Upstream fix: N/A | | 66 | |:Upstream fix: N/A | |
566 | 49 | +-------------------------------------------------------------------------------------------------------------+ | 67 | +-------------------------------------------------------------------------------------------------------------+ |
567 | @@ -55,7 +73,7 @@ | |||
568 | 55 | +-------------------------------------------------------------------------------------------------------------+ | 73 | +-------------------------------------------------------------------------------------------------------------+ |
569 | 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 ... | |
570 | 57 | |:Launchpad bug: :bug:`1132194` | | 75 | |:Launchpad bug: :bug:`1132194` | |
572 | 58 | |:Upstream state: Verified (checked on 2014-03-17) | | 76 | |:Upstream state: Verified (checked on 2014-04-29) | |
573 | 59 | |:Fix Released: :rn:`5.5.32-31.0` | | 77 | |:Fix Released: :rn:`5.5.32-31.0` | |
574 | 60 | |:Upstream fix: N/A | | 78 | |:Upstream fix: N/A | |
575 | 61 | +-------------------------------------------------------------------------------------------------------------+ | 79 | +-------------------------------------------------------------------------------------------------------------+ |
576 | @@ -67,7 +85,7 @@ | |||
577 | 67 | +-------------------------------------------------------------------------------------------------------------+ | 85 | +-------------------------------------------------------------------------------------------------------------+ |
578 | 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 ... | |
579 | 69 | |:Launchpad bug: :bug:`1169494` | | 87 | |:Launchpad bug: :bug:`1169494` | |
581 | 70 | |:Upstream state: Verified (checked on 2014-03-17) | | 88 | |:Upstream state: Verified (checked on 2014-04-29) | |
582 | 71 | |:Fix Released: :rn:`5.5.32-31.0` | | 89 | |:Fix Released: :rn:`5.5.32-31.0` | |
583 | 72 | |:Upstream fix: N/A | | 90 | |:Upstream fix: N/A | |
584 | 73 | +-------------------------------------------------------------------------------------------------------------+ | 91 | +-------------------------------------------------------------------------------------------------------------+ |
585 | @@ -79,7 +97,7 @@ | |||
586 | 79 | +-------------------------------------------------------------------------------------------------------------+ | 97 | +-------------------------------------------------------------------------------------------------------------+ |
587 | 80 | |:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined | | 98 | |:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined | |
588 | 81 | |:Launchpad bug: :bug:`1183610` | | 99 | |:Launchpad bug: :bug:`1183610` | |
590 | 82 | |:Upstream state: No Feedback (checked on 2014-03-17) | | 100 | |:Upstream state: No Feedback (checked on 2014-04-29) | |
591 | 83 | |:Fix Released: :rn:`5.5.31-30.3` | | 101 | |:Fix Released: :rn:`5.5.31-30.3` | |
592 | 84 | |:Upstream fix: N/A | | 102 | |:Upstream fix: N/A | |
593 | 85 | +-------------------------------------------------------------------------------------------------------------+ | 103 | +-------------------------------------------------------------------------------------------------------------+ |
594 | @@ -91,7 +109,7 @@ | |||
595 | 91 | +-------------------------------------------------------------------------------------------------------------+ | 109 | +-------------------------------------------------------------------------------------------------------------+ |
596 | 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() | |
597 | 93 | |:Launchpad bug: :bug:`1163439` | | 111 | |:Launchpad bug: :bug:`1163439` | |
599 | 94 | |:Upstream state: Verified (checked on 2014-03-17) | | 112 | |:Upstream state: Verified (checked on 2014-04-29) | |
600 | 95 | |:Fix Released: :rn:`5.5.30-30.2` | | 113 | |:Fix Released: :rn:`5.5.30-30.2` | |
601 | 96 | |:Upstream fix: N/A | | 114 | |:Upstream fix: N/A | |
602 | 97 | +-------------------------------------------------------------------------------------------------------------+ | 115 | +-------------------------------------------------------------------------------------------------------------+ |
603 | @@ -121,13 +139,13 @@ | |||
604 | 121 | +-------------------------------------------------------------------------------------------------------------+ | 139 | +-------------------------------------------------------------------------------------------------------------+ |
605 | 122 | |:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() | | 140 | |:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() | |
606 | 123 | |:Launchpad bug: :bug:`1132350` | | 141 | |:Launchpad bug: :bug:`1132350` | |
608 | 124 | |:Upstream state: Verified (checked on 2014-03-17) | | 142 | |:Upstream state: Verified (checked on 2014-04-29) | |
609 | 125 | |:Fix Released: :rn:`5.5.30-30.1` | | 143 | |:Fix Released: :rn:`5.5.30-30.1` | |
610 | 126 | |:Upstream fix: N/A | | 144 | |:Upstream fix: N/A | |
611 | 127 | +-------------------------------------------------------------------------------------------------------------+ | 145 | +-------------------------------------------------------------------------------------------------------------+ |
612 | 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 ...| |
613 | 129 | |:Launchpad bug: :bug:`1100178` | | 147 | |:Launchpad bug: :bug:`1100178` | |
615 | 130 | |:Upstream state: Verified (checked on 2014-03-17) | | 148 | |:Upstream state: Verified (checked on 2014-04-29) | |
616 | 131 | |:Fix Released: :rn:`5.5.29-30.0` | | 149 | |:Fix Released: :rn:`5.5.29-30.0` | |
617 | 132 | |:Upstream fix: N/A | | 150 | |:Upstream fix: N/A | |
618 | 133 | +-------------------------------------------------------------------------------------------------------------+ | 151 | +-------------------------------------------------------------------------------------------------------------+ |
619 | @@ -229,7 +247,7 @@ | |||
620 | 229 | +-------------------------------------------------------------------------------------------------------------+ | 247 | +-------------------------------------------------------------------------------------------------------------+ |
621 | 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..| |
622 | 231 | |:Launchpad bug: :bug:`1042517` | | 249 | |:Launchpad bug: :bug:`1042517` | |
624 | 232 | |:Upstream state: Verified (checked on 2014-03-17) | | 250 | |:Upstream state: Verified (checked on 2014-04-29) | |
625 | 233 | |:Fix Released: :rn:`5.5.27-29.0` | | 251 | |:Fix Released: :rn:`5.5.27-29.0` | |
626 | 234 | |:Upstream fix: N/A | | 252 | |:Upstream fix: N/A | |
627 | 235 | +-------------------------------------------------------------------------------------------------------------+ | 253 | +-------------------------------------------------------------------------------------------------------------+ |
628 | @@ -241,7 +259,7 @@ | |||
629 | 241 | +-------------------------------------------------------------------------------------------------------------+ | 259 | +-------------------------------------------------------------------------------------------------------------+ |
630 | 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. | |
631 | 243 | |:Launchpad bug: :bug:`1013432` | | 261 | |:Launchpad bug: :bug:`1013432` | |
633 | 244 | |:Upstream state: Verified (checked on 2014-03-17) | | 262 | |:Upstream state: Verified (checked on 2014-04-29) | |
634 | 245 | |:Fix Released: :rn:`5.5.27-28.0` | | 263 | |:Fix Released: :rn:`5.5.27-28.0` | |
635 | 246 | |:Upstream fix: N/A | | 264 | |:Upstream fix: N/A | |
636 | 247 | +-------------------------------------------------------------------------------------------------------------+ | 265 | +-------------------------------------------------------------------------------------------------------------+ |
637 | @@ -289,7 +307,7 @@ | |||
638 | 289 | +-------------------------------------------------------------------------------------------------------------+ | 307 | +-------------------------------------------------------------------------------------------------------------+ |
639 | 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 | |
640 | 291 | |:Launchpad bug: :bug:`1262651` | | 309 | |:Launchpad bug: :bug:`1262651` | |
642 | 292 | |:Upstream state: Verified (checked on 2014-03-17) | | 310 | |:Upstream state: Verified (checked on 2014-04-29) | |
643 | 293 | |:Fix Released: :rn:`5.5.20-24.1` | | 311 | |:Fix Released: :rn:`5.5.20-24.1` | |
644 | 294 | |:Upstream fix: N/A | | 312 | |:Upstream fix: N/A | |
645 | 295 | +-------------------------------------------------------------------------------------------------------------+ | 313 | +-------------------------------------------------------------------------------------------------------------+ |
646 | @@ -313,13 +331,13 @@ | |||
647 | 313 | +-------------------------------------------------------------------------------------------------------------+ | 331 | +-------------------------------------------------------------------------------------------------------------+ |
648 | 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 | |
649 | 315 | |:Launchpad bug: :bug:`857590` | | 333 | |:Launchpad bug: :bug:`857590` | |
651 | 316 | |:Upstream state: Verified (checked on 2014-03-17) | | 334 | |:Upstream state: Verified (checked on 2014-04-29) | |
652 | 317 | |:Fix Released: :rn:`5.5.16-22.0` | | 335 | |:Fix Released: :rn:`5.5.16-22.0` | |
653 | 318 | |:Upstream fix: N/A | | 336 | |:Upstream fix: N/A | |
654 | 319 | +-------------------------------------------------------------------------------------------------------------+ | 337 | +-------------------------------------------------------------------------------------------------------------+ |
655 | 320 | |:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format | | 338 | |:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format | |
656 | 321 | |:Launchpad bug: N/A | | 339 | |:Launchpad bug: N/A | |
658 | 322 | |:Upstream state: Verified (checked on 2014-03-17) | | 340 | |:Upstream state: Verified (checked on 2014-04-29) | |
659 | 323 | |:Fix Released: :rn:`5.5.15-21.0` | | 341 | |:Fix Released: :rn:`5.5.15-21.0` | |
660 | 324 | |:Upstream fix: N/A | | 342 | |:Upstream fix: N/A | |
661 | 325 | +-------------------------------------------------------------------------------------------------------------+ | 343 | +-------------------------------------------------------------------------------------------------------------+ |
662 | @@ -337,7 +355,7 @@ | |||
663 | 337 | +-------------------------------------------------------------------------------------------------------------+ | 355 | +-------------------------------------------------------------------------------------------------------------+ |
664 | 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 | |
665 | 339 | |:Launchpad bug: :bug:`800035` | | 357 | |:Launchpad bug: :bug:`800035` | |
667 | 340 | |:Upstream state: Verified (checked on 2014-03-17) | | 358 | |:Upstream state: Verified (checked on 2014-04-29) | |
668 | 341 | |:Fix Released: :rn:`5.5.13-20.4` | | 359 | |:Fix Released: :rn:`5.5.13-20.4` | |
669 | 342 | |:Upstream fix: N/A | | 360 | |:Upstream fix: N/A | |
670 | 343 | +-------------------------------------------------------------------------------------------------------------+ | 361 | +-------------------------------------------------------------------------------------------------------------+ |
671 | @@ -367,7 +385,7 @@ | |||
672 | 367 | +-------------------------------------------------------------------------------------------------------------+ | 385 | +-------------------------------------------------------------------------------------------------------------+ |
673 | 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| |
674 | 369 | |:Launchpad bug: :bug:`1176496` | | 387 | |:Launchpad bug: :bug:`1176496` | |
676 | 370 | |:Upstream state: Open (checked on 2014-03-17) | | 388 | |:Upstream state: Open (checked on 2014-04-29) | |
677 | 371 | |:Fix Released: :rn:`5.5.8-20.0` | | 389 | |:Fix Released: :rn:`5.5.8-20.0` | |
678 | 372 | |:Upstream fix: N/A | | 390 | |:Upstream fix: N/A | |
679 | 373 | +-------------------------------------------------------------------------------------------------------------+ | 391 | +-------------------------------------------------------------------------------------------------------------+ |
Partial review:
- slow query log rate filtering docs need update for 1016991. ation of Oracle's one.
- 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
implement
- 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?