Merge lp:~hrvojem/percona-server/rn-5.6.21-69.0-5.6 into lp:percona-server/5.6
- rn-5.6.21-69.0-5.6
- Merge into 5.6
Proposed by
Hrvoje Matijakovic
Status: | Merged |
---|---|
Approved by: | Laurynas Biveinis |
Approved revision: | no longer in the source branch. |
Merged at revision: | 672 |
Proposed branch: | lp:~hrvojem/percona-server/rn-5.6.21-69.0-5.6 |
Merge into: | lp:percona-server/5.6 |
Diff against target: |
693 lines (+318/-45) 9 files modified
doc/source/changed_in_56.rst (+10/-3) doc/source/conf.py (+1/-1) doc/source/diagnostics/response_time_distribution.rst (+226/-0) doc/source/index.rst (+1/-0) doc/source/index_info_schema_tables.rst (+2/-0) doc/source/ps-versions-comparison.rst (+1/-1) doc/source/release-notes/Percona-Server-5.6.21-69.0.rst (+36/-0) doc/source/release-notes/release-notes_index.rst (+1/-0) doc/source/upstream-bug-fixes.rst (+40/-40) |
To merge this branch: | bzr merge lp:~hrvojem/percona-server/rn-5.6.21-69.0-5.6 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Review via email: mp+237030@code.launchpad.net |
Commit message
Description of the change
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
review:
Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
The 5.5 version collects slave SQL thread info, the 5.6 does not - this bit needs to be present not only in the 5.6 feature doc, but in the 5.6 upgrade notes too. It also needs to say that SHOW and FLUSH statements of 5.5 are not supported and tell the 5.6 alternatives.
Two mode diff comments.
review:
Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) : | # |
review:
Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) : | # |
review:
Approve
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'doc/source/changed_in_56.rst' |
2 | --- doc/source/changed_in_56.rst 2014-06-27 10:15:23 +0000 |
3 | +++ doc/source/changed_in_56.rst 2014-10-07 07:14:23 +0000 |
4 | @@ -25,6 +25,12 @@ |
5 | * ``SHOW ENGINE INNODB STATUS`` sections on memory usage for InnoDB/XtraDB hash tables has been replaced by the :table:`XTRADB_INTERNAL_HASH_TABLES` INFORMATION_SCHEMA table. |
6 | * The :table:`INNODB_RSEG` table has been renamed to :table:`XTRADB_RSEG`. |
7 | * :ref:`buff_read_ahead_area` has been implemented differently. Buffer read-ahead area size is now precalculated once per buffer pool instance initialization instead of hardcoding it at 64MB (like it was done in previous |Percona Server| versions). |
8 | + * :ref:`response_time_distribution` feature has been implemented as a plugin. It has the following changes from the 5.5 implementation: |
9 | + - the plugin requires installation before the feature can be used; |
10 | + - variable :variable:`have_response_time_distribution` has been removed. The presence of the feature can be determined by querying ``SHOW PLUGINS`` instead; |
11 | + - replication updates performed by the slave SQL threads are not tracked; |
12 | + - command ``SHOW QUERY_RESPONSE_TIME;`` has been removed in favor of :table:`QUERY_RESPONSE_TIME` table; |
13 | + - command ``FLUSH QUERY_RESPONSE_TIME;`` has been replaced with :variable:`query_response_time_flush` variable. |
14 | |
15 | Features available in |Percona Server| 5.5 that have been replaced with |MySQL| 5.6 features |
16 | ============================================================================================ |
17 | @@ -87,6 +93,7 @@ |
18 | :ref:`innodb_split_buf_pool_mutex` :rn:`5.6.13-60.6` |
19 | :ref:`innodb_adaptive_hash_index_partitions_page` :rn:`5.6.13-60.6` |
20 | :ref:`handlersocket_page` :rn:`5.6.17-66.0` |
21 | + :ref:`response_time_distribution` :rn:`5.6.21-69.0` |
22 | ================================================= =================== |
23 | |
24 | List of status variables that are no longer available in |Percona Server| 5.6 |
25 | @@ -150,7 +157,7 @@ |
26 | * - :variable:`have_flashcache` |
27 | - Information if the server has been compiled with the Flashcache support has not been ported to |Percona Server| 5.6 |
28 | * - :variable:`have_response_time_distribution` |
29 | - - :ref:`Response Time Distribution <ps55:response_time_distribution>` feature containing this variable has not been ported to |Percona Server| 5.6 yet |
30 | + - :ref:`Response Time Distribution <ps55:response_time_distribution>` feature has been ported to |Percona Server| 5.6 without this variable |
31 | * - :variable:`innodb_adaptive_flushing_method` |
32 | - replaced by MySQL 5.6 `flushing <http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html#innodb-lru-background-flushing>`_ implementation |
33 | * - :variable:`innodb_blocking_buffer_pool_restore` |
34 | @@ -206,7 +213,7 @@ |
35 | * - :variable:`optimizer_fix` |
36 | - this variable has been deprecated and removed in |Percona Server| 5.5 |
37 | * - :variable:`query_response_time_range_base` |
38 | - - :ref:`Response Time Distribution <ps55:response_time_distribution>` feature containing this variable has not been ported to |Percona Server| 5.6 yet |
39 | + - :ref:`Response Time Distribution <ps55:response_time_distribution>` feature containing this variable has been ported to |Percona Server| 5.6, but requires plugin installation in order to work. More information can be found in :ref:`response_time_distribution` documentation. |
40 | * - :variable:`query_response_time_stats` |
41 | - - :ref:`Response Time Distribution <ps55:response_time_distribution>` feature containing this variable has not been ported to |Percona Server| 5.6 yet |
42 | + - :ref:`Response Time Distribution <ps55:response_time_distribution>` feature containing this variable has been ported to |Percona Server| 5.6, but requires plugin installation in order to work. More information can be found in :ref:`response_time_distribution` documentation. |
43 | |
44 | |
45 | === modified file 'doc/source/conf.py' |
46 | --- doc/source/conf.py 2014-10-02 13:44:18 +0000 |
47 | +++ doc/source/conf.py 2014-10-07 07:14:23 +0000 |
48 | @@ -54,7 +54,7 @@ |
49 | # The short X.Y version. |
50 | version = '5.6' |
51 | # The full version, including alpha/beta/rc tags. |
52 | -release = '5.6.20-68.0' |
53 | +release = '5.6.21-69.0' |
54 | |
55 | # The language for content autogenerated by Sphinx. Refer to documentation |
56 | # for a list of supported languages. |
57 | |
58 | === added file 'doc/source/diagnostics/response_time_distribution.rst' |
59 | --- doc/source/diagnostics/response_time_distribution.rst 1970-01-01 00:00:00 +0000 |
60 | +++ doc/source/diagnostics/response_time_distribution.rst 2014-10-07 07:14:23 +0000 |
61 | @@ -0,0 +1,226 @@ |
62 | +.. _response_time_distribution: |
63 | + |
64 | +============================ |
65 | + Response Time Distribution |
66 | +============================ |
67 | + |
68 | +The slow query log provides exact information about queries that take a long time to execute. However, sometimes there are a large number of queries that each take a very short amount of time to execute. This feature provides a tool for analyzing that information by counting and displaying the number of queries according to the length of time they took to execute. The user can define time intervals that divide the range 0 to positive infinity into smaller intervals and then collect the number of commands whose execution times fall into each of those intervals. |
69 | + |
70 | +Note that in a replication environment, the server will not take into account *any* queries executed by the slave SQL threads (whether they are slow or not) for the time distribution. |
71 | + |
72 | +Each interval is described as: :: |
73 | + |
74 | +(range_base ^ n; range_base ^ (n+1)] |
75 | + |
76 | +The range_base is some positive number (see Limitations). The interval is defined as the difference between two nearby powers of the range base. |
77 | + |
78 | +For example, if the range base=10, we have the following intervals: :: |
79 | + |
80 | + (0; 10 ^ -6], (10 ^ -6; 10 ^ -5], (10 ^ -5; 10 ^ -4], ..., (10 ^ -1; 10 ^1], (10^1; 10^2]...(10^7; positive infinity] |
81 | + |
82 | +or :: |
83 | + |
84 | + (0; 0.000001], (0.000001; 0.000010], (0.000010; 0.000100], ..., (0.100000; 1.0]; (1.0; 10.0]...(1000000; positive infinity] |
85 | + |
86 | +For each interval, a count is made of the queries with execution times that fell into that interval. |
87 | + |
88 | +You can select the range of the intervals by changing the range base. For example, for base range=2 we have the following intervals: :: |
89 | + |
90 | + (0; 2 ^ -19], (2 ^ -19; 2 ^ -18], (2 ^ -18; 2 ^ -17], ..., (2 ^ -1; 2 ^1], (2 ^ 1; 2 ^ 2]...(2 ^ 25; positive infinity] |
91 | + |
92 | +or :: |
93 | + |
94 | + (0; 0.000001], (0.000001, 0.000003], ..., (0.25; 0.5], (0.5; 2], (2; 4]...(8388608; positive infinity] |
95 | + |
96 | +Small numbers look strange (i.e., don't look like powers of 2), because we lose precision on division when the ranges are calculated at runtime. In the resulting table, you look at the high boundary of the range. |
97 | + |
98 | +For example, you may see: :: |
99 | + |
100 | + +----------------+-------+------------+ |
101 | + | time | count | total | |
102 | + +----------------+-------+------------| |
103 | + | 0.000001 | 0 | 0.000000 | |
104 | + | 0.000010 | 17 | 0.000094 | |
105 | + | 0.000100 | 4301 | 0.236555 | |
106 | + | 0.001000 | 1499 | 0.824450 | |
107 | + | 0.010000 | 14851 | 81.680502 | |
108 | + | 0.100000 | 8066 | 443.635693 | |
109 | + | 1.000000 | 0 | 0.000000 | |
110 | + | 10.000000 | 0 | 0.000000 | |
111 | + | 100.000000 | 1 | 55.937094 | |
112 | + | 1000.000000 | 0 | 0.000000 | |
113 | + | 10000.000000 | 0 | 0.000000 | |
114 | + | 100000.000000 | 0 | 0.000000 | |
115 | + | 1000000.000000 | 0 | 0.000000 | |
116 | + | TOO LONG QUERY | 0 | 0.000000 | |
117 | + +----------------+-------+------------+ |
118 | + |
119 | +This means there were: :: |
120 | + |
121 | + * 17 queries with 0.000001 < query execution time < = 0.000010 seconds; total execution time of the 17 queries = 0.000094 seconds |
122 | + |
123 | + * 4301 queries with 0.000010 < query execution time < = 0.000100 seconds; total execution time of the 4301 queries = 0.236555 seconds |
124 | + |
125 | + * 1499 queries with 0.000100 < query execution time < = 0.001000 seconds; total execution time of the 1499 queries = 0.824450 seconds |
126 | + |
127 | + * 14851 queries with 0.001000 < query execution time < = 0.010000 seconds; total execution time of the 14851 queries = 81.680502 seconds |
128 | + |
129 | + * 8066 queries with 0.010000 < query execution time < = 0.100000 seconds; total execution time of the 8066 queries = 443.635693 seconds |
130 | + |
131 | + * 1 query with 10.000000 < query execution time < = 100.0000 seconds; total execution time of the 1 query = 55.937094 seconds |
132 | + |
133 | +Installing the plugins |
134 | +====================== |
135 | + |
136 | +In order to enable this feature you'll need to install the necessary plugins: |
137 | + |
138 | +.. code-block:: mysql |
139 | + |
140 | + mysql> INSTALL PLUGIN QUERY_RESPONSE_TIME_AUDIT SONAME 'query_response_time.so'; |
141 | + |
142 | +This plugin is used for gathering statistics. |
143 | + |
144 | +.. code-block:: mysql |
145 | + |
146 | + mysql> INSTALL PLUGIN QUERY_RESPONSE_TIME SONAME 'query_response_time.so'; |
147 | + |
148 | +This plugin provides the interface (:table:`QUERY_RESPONSE_TIME`) to output gathered statistics. |
149 | + |
150 | +You can check if plugins are installed correctly by running: |
151 | + |
152 | +.. code-block:: mysql |
153 | + |
154 | + mysql> SHOW PLUGINS; |
155 | + |
156 | + ... |
157 | + | QUERY_RESPONSE_TIME | ACTIVE | INFORMATION SCHEMA | query_response_time.so | GPL | |
158 | + | QUERY_RESPONSE_TIME_AUDIT | ACTIVE | AUDIT | query_response_time.so | GPL | |
159 | + +-----------------------------+----------+--------------------+------------------------+---------+ |
160 | + |
161 | +Usage |
162 | +===== |
163 | + |
164 | +SELECT |
165 | +------ |
166 | + |
167 | +You can get the distribution using the query: |
168 | + |
169 | +.. code-block:: mysql |
170 | + |
171 | + mysql> SELECT * from INFORMATION_SCHEMA.QUERY_RESPONSE_TIME |
172 | + time count total |
173 | + 0.000001 0 0.000000 |
174 | + 0.000010 0 0.000000 |
175 | + 0.000100 1 0.000072 |
176 | + 0.001000 0 0.000000 |
177 | + 0.010000 0 0.000000 |
178 | + 0.100000 0 0.000000 |
179 | + 1.000000 0 0.000000 |
180 | + 10.000000 8 47.268416 |
181 | + 100.000000 0 0.000000 |
182 | + 1000.000000 0 0.000000 |
183 | + 10000.000000 0 0.000000 |
184 | + 100000.000000 0 0.000000 |
185 | + 1000000.000000 0 0.000000 |
186 | + TOO LONG QUERY 0 0.000000 |
187 | + |
188 | +You can write a complex query like: |
189 | + |
190 | +.. code-block:: mysql |
191 | + |
192 | + SELECT c.count, c.time, |
193 | + (SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count, |
194 | + (SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count, |
195 | + (SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count |
196 | + FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0; |
197 | + |
198 | +**Note:** If :variable:`query_response_time_stats` is ON, the execution times for these two ``SELECT`` queries will also be collected. |
199 | + |
200 | +FLUSH |
201 | +----- |
202 | + |
203 | +Flushing can be done by setting the :variable:`query_response_time_flush` to ``ON`` (or ``1``): |
204 | + |
205 | +.. code-block:: mysql |
206 | + |
207 | + mysql> SET GLOBAL query_response_time_flush='ON'; |
208 | + |
209 | +``FLUSH`` does two things: |
210 | + |
211 | + * Clears the collected times from the :table:`QUERY_RESPONSE_TIME` table |
212 | + |
213 | + * Reads the value of :variable:`query_response_time_range_base` and uses it to set the range base for the table |
214 | + |
215 | +**Note:** The execution time for the ``FLUSH`` query will also be collected. |
216 | + |
217 | +Stored procedures |
218 | +----------------- |
219 | + |
220 | +Stored procedure calls count as a single query. |
221 | + |
222 | +Collect time point |
223 | +------------------ |
224 | + |
225 | +Time is collected after query execution completes (before clearing data structures). |
226 | + |
227 | +Version Specific Information |
228 | +============================ |
229 | + |
230 | + * :rn:`5.6.21-69.0`: |
231 | + Feature ported from |Percona Server| 5.5 as a plugin |
232 | + |
233 | +System Variables |
234 | +================ |
235 | + |
236 | +.. variable:: query_response_time_flush |
237 | + |
238 | + :version 5.6.21-69.0: Introduced. |
239 | + :scope: Global |
240 | + :dyn: No |
241 | + :vartype: Boolean |
242 | + :default: OFF |
243 | + :range: OFF/ON |
244 | + |
245 | +Setting this variable to ``ON`` will flush the statistics and re-read the :variable:`query_response_time_range_base`. |
246 | + |
247 | + |
248 | +.. variable:: query_response_time_range_base |
249 | + |
250 | + :cli: Yes |
251 | + :conf: Yes |
252 | + :scope: Global |
253 | + :dyn: Yes |
254 | + :vartype: Numeric |
255 | + :default: 10 |
256 | + :range: 2-1000 |
257 | + |
258 | +Sets up the logarithm base for the scale. |
259 | + |
260 | +**NOTE:** The variable takes effect only after this command has been executed: |
261 | + |
262 | +.. code-block:: mysql |
263 | + |
264 | + mysql> SET GLOBAL query_response_time_flush=1; |
265 | + |
266 | +.. variable:: query_response_time_stats |
267 | + |
268 | + :version 5.6.21-69.0: Introduced. |
269 | + :cli: Yes |
270 | + :conf: Yes |
271 | + :scope: Global |
272 | + :dyn: Yes |
273 | + :vartype: Boolean |
274 | + :default: OFF |
275 | + :range: ON/OFF |
276 | + |
277 | +This variable enables and disables collection of query times. |
278 | + |
279 | +INFORMATION_SCHEMA Tables |
280 | +========================= |
281 | + |
282 | +.. table:: INFORMATION_SCHEMA.QUERY_RESPONSE_TIME |
283 | + |
284 | + :column VARCHAR TIME: Interval range in which the query occurred |
285 | + :column INT(11) COUNT: Number of queries with execution times that fell into that interval |
286 | + :column VARCHAR TOTAL: Total execution time of the queries |
287 | + |
288 | |
289 | === modified file 'doc/source/index.rst' |
290 | --- doc/source/index.rst 2014-06-27 10:15:23 +0000 |
291 | +++ doc/source/index.rst 2014-10-07 07:14:23 +0000 |
292 | @@ -147,6 +147,7 @@ |
293 | diagnostics/misc_info_schema_tables |
294 | diagnostics/thread_based_profiling |
295 | diagnostics/scalability_metrics_plugin |
296 | + diagnostics/response_time_distribution |
297 | |
298 | TokuDB |
299 | ====== |
300 | |
301 | === modified file 'doc/source/index_info_schema_tables.rst' |
302 | --- doc/source/index_info_schema_tables.rst 2013-06-03 10:01:08 +0000 |
303 | +++ doc/source/index_info_schema_tables.rst 2014-10-07 07:14:23 +0000 |
304 | @@ -14,6 +14,8 @@ |
305 | |
306 | * :table:`INNODB_CHANGED_PAGES` |
307 | |
308 | + * :table:`QUERY_RESPONSE_TIME` |
309 | + |
310 | * :table:`TABLE_STATISTICS` |
311 | |
312 | * :table:`TEMPORARY_TABLES` |
313 | |
314 | === modified file 'doc/source/ps-versions-comparison.rst' |
315 | --- doc/source/ps-versions-comparison.rst 2014-05-30 13:32:03 +0000 |
316 | +++ doc/source/ps-versions-comparison.rst 2014-10-07 07:14:23 +0000 |
317 | @@ -174,7 +174,7 @@ |
318 | - :ref:`Log All Client Commands (syslog) <ps56:mysql_syslog>` |
319 | * - :ref:`Response Time Distribution <ps51:response_time_distribution>` |
320 | - :ref:`Response Time Distribution <ps55:response_time_distribution>` |
321 | - - Feature not implemented |
322 | + - :ref:`Response Time Distribution <ps56:response_time_distribution>` |
323 | * - :ref:`Show Storage Engines <ps51:show_engines>` |
324 | - :ref:`Show Storage Engines <ps55:show_engines>` |
325 | - :ref:`Show Storage Engines <ps56:show_engines>` |
326 | |
327 | === added file 'doc/source/release-notes/Percona-Server-5.6.21-69.0.rst' |
328 | --- doc/source/release-notes/Percona-Server-5.6.21-69.0.rst 1970-01-01 00:00:00 +0000 |
329 | +++ doc/source/release-notes/Percona-Server-5.6.21-69.0.rst 2014-10-07 07:14:23 +0000 |
330 | @@ -0,0 +1,36 @@ |
331 | +.. rn:: 5.6.21-69.0 |
332 | + |
333 | +============================== |
334 | + |Percona Server| 5.6.21-69.0 |
335 | +============================== |
336 | + |
337 | +Percona is glad to announce the release of |Percona Server| 5.6.21-69.0 on October 7th, 2014 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.21-69.0/>`_ and from the :doc:`Percona Software Repositories </installation>`). |
338 | + |
339 | +Based on `MySQL 5.6.21 <http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-21.html>`_, including all the bug fixes in it, |Percona Server| 5.6.21-69.0 is the current GA release in the |Percona Server| 5.6 series. All of |Percona|'s software is open-source and free, all the details of the release can be found in the `5.6.21-69.0 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.6.21-69.0>`_. |
340 | + |
341 | + |
342 | +New Features |
343 | +============ |
344 | + |
345 | + :ref:`response_time_distribution` feature has been from |Percona Server| 5.5 as a plugin. |
346 | + |
347 | + TokuDB storage engine package has been updated to version `7.5.1 <http://docs.tokutek.com/tokudb/tokudb-release-notes.html#tokudb-7-5-0>`_. |
348 | + |
349 | +Bugs Fixed |
350 | +========== |
351 | + |
352 | + :ref:`backup_locks` did not guarantee consistent ``SHOW SLAVE STATUS`` information with binary log disabled. Bug fixed :bug:`1358836`. |
353 | + |
354 | + :ref:`audit_log_plugin` would rotate the audit log in middle of an audit message. Bug fixed :bug:`1363370`. |
355 | + |
356 | + When the binary log is enabled on a replication slave, ``SHOW SLAVE STATUS`` performed under an active BINLOG lock could lead to a deadlock. Bug fixed :bug:`1372806`. |
357 | + |
358 | + Fixed a memory leak in :ref:`scalability_metrics_plugin`. Bug fixed :bug:`1334570`. |
359 | + |
360 | + Fixed a memory leak if :ref:`secure-file-priv <secure_file_priv_extended>` option was used with no argument. Bug fixed :bug:`1334719`. |
361 | + |
362 | + ``LOCK TABLES FOR BACKUP`` is now incompatible with ``LOCK TABLES``, ``FLUSH TABLES WITH READ LOCK``, and ``FLUSH TABLES FOR EXPORT`` in the same connection. Bug fixed :bug:`1360064`. |
363 | + |
364 | +Other bugs fixed: :bug:`1361568`. |
365 | + |
366 | + |
367 | |
368 | === modified file 'doc/source/release-notes/release-notes_index.rst' |
369 | --- doc/source/release-notes/release-notes_index.rst 2014-10-02 13:44:18 +0000 |
370 | +++ doc/source/release-notes/release-notes_index.rst 2014-10-07 07:14:23 +0000 |
371 | @@ -6,6 +6,7 @@ |
372 | :maxdepth: 1 |
373 | :glob: |
374 | |
375 | + Percona-Server-5.6.21-69.0 |
376 | Percona-Server-5.6.20-68.0 |
377 | Percona-Server-5.6.19-67.0 |
378 | Percona-Server-5.6.17-66.0 |
379 | |
380 | === modified file 'doc/source/upstream-bug-fixes.rst' |
381 | --- doc/source/upstream-bug-fixes.rst 2014-10-02 13:44:18 +0000 |
382 | +++ doc/source/upstream-bug-fixes.rst 2014-10-07 07:14:23 +0000 |
383 | @@ -7,37 +7,37 @@ |
384 | +-------------------------------------------------------------------------------------------------------------+ |
385 | |:Upstream bug: :mysqlbug:`70860` - --tc-heuristic-recover option values are broken | |
386 | |:Launchpad bug: :bug:`1334330` | |
387 | -|:Upstream state: Open (checked on 2014-08-29) | |
388 | +|:Upstream state: Open (checked on 2014-10-06) | |
389 | |:Fix Released: :rn:`5.6.20-68.0` | |
390 | |:Upstream fix: N/A | |
391 | +-------------------------------------------------------------------------------------------------------------+ |
392 | |:Upstream bug: :mysqlbug:`73418` - Add --manual-lldb option to mysql-test-run.pl | |
393 | |:Launchpad bug: :bug:`1328482` | |
394 | -|:Upstream state: Verified (checked on 2014-08-29) | |
395 | +|:Upstream state: Verified (checked on 2014-10-06) | |
396 | |:Fix Released: :rn:`5.6.20-68.0` | |
397 | |:Upstream fix: N/A | |
398 | +-------------------------------------------------------------------------------------------------------------+ |
399 | |:Upstream bug: :mysqlbug:`67806` - Multiple user level lock per connection | |
400 | |:Launchpad bug: N/A ` | |
401 | -|:Upstream state: Verified (checked on 2014-08-29) | |
402 | +|:Upstream state: Closed | |
403 | |:Fix Released: :rn:`5.6.19-67.0` | |
404 | |:Upstream fix: N/A | |
405 | +-------------------------------------------------------------------------------------------------------------+ |
406 | |:Upstream bug: :mysqlbug:`1118` - Allow multiple concurrent locks with GET_LOCK() | |
407 | |:Launchpad bug: N/A | |
408 | -|:Upstream state: Verified (checked on 2014-08-29) | |
409 | +|:Upstream state: Closed | |
410 | |:Fix Released: :rn:`5.6.19-67.0` | |
411 | |:Upstream fix: N/A | |
412 | +-------------------------------------------------------------------------------------------------------------+ |
413 | |:Upstream bug: :mysqlbug:`72615` - MTR --mysqld=--default-storage-engine=foo incompatible w/ dynamically... | |
414 | |:Launchpad bug: :bug:`1318537` | |
415 | -|:Upstream state: Verified (checked on 2014-08-29) | |
416 | +|:Upstream state: Verified (checked on 2014-10-06) | |
417 | |:Fix Released: :rn:`5.6.17-66.0` | |
418 | |:Upstream fix: N/A | |
419 | +-------------------------------------------------------------------------------------------------------------+ |
420 | |:Upstream bug: :mysqlbug:`72163` - Rev 5774 broke rpl_plugin_load | |
421 | |:Launchpad bug: :bug:`1299688` | |
422 | -|:Upstream state: Verified (checked on 2014-08-29) | |
423 | +|:Upstream state: Verified (checked on 2014-10-06) | |
424 | |:Fix Released: :rn:`5.6.17-65.0` | |
425 | |:Upstream fix: N/A | |
426 | +-------------------------------------------------------------------------------------------------------------+ |
427 | @@ -55,19 +55,19 @@ |
428 | +-------------------------------------------------------------------------------------------------------------+ |
429 | |:Upstream bug: :mysqlbug:`71374` - Slave IO thread won't attempt auto reconnect to the master/error-code 1159| |
430 | |:Launchpad bug: :bug:`1268729` | |
431 | -|:Upstream state: Verified (checked on 2014-08-29) | |
432 | +|:Upstream state: Verified (checked on 2014-10-06) | |
433 | |:Fix Released: :rn:`5.6.16-64.1` | |
434 | |:Upstream fix: N/A | |
435 | +-------------------------------------------------------------------------------------------------------------+ |
436 | |:Upstream bug: :mysqlbug:`71988` - page_cleaner: aggressive background flushing | |
437 | |:Launchpad bug: :bug:`1238039` | |
438 | -|:Upstream state: Verified (checked on 2014-08-29) | |
439 | +|:Upstream state: Verified (checked on 2014-10-06) | |
440 | |:Fix Released: :rn:`5.6.16-64.0` | |
441 | |:Upstream fix: N/A | |
442 | +-------------------------------------------------------------------------------------------------------------+ |
443 | |:Upstream bug: :mysqlbug:`71624` - printf size_t results in a fatal warning in 32-bit debug builds | |
444 | |:Launchpad bug: :bug:`1277505` | |
445 | -|:Upstream state: Can't repeat (checked on 2014-08-29) | |
446 | +|:Upstream state: Can't repeat (checked on 2014-10-06) | |
447 | |:Fix Released: :rn:`5.6.16-64.0` | |
448 | |:Upstream fix: N/A | |
449 | +-------------------------------------------------------------------------------------------------------------+ |
450 | @@ -109,13 +109,13 @@ |
451 | +-------------------------------------------------------------------------------------------------------------+ |
452 | |:Upstream bug: :mysqlbug:`71270` - Failures to end bulk insert for partitioned tables handled incorrectly | |
453 | |:Launchpad bug: :bug:`1204871` | |
454 | -|:Upstream state: Verified (checked on 2014-08-29) | |
455 | +|:Upstream state: Verified (checked on 2014-10-06) | |
456 | |:Fix Released: :rn:`5.6.16-64.0` | |
457 | |:Upstream fix: N/A | |
458 | +-------------------------------------------------------------------------------------------------------------+ |
459 | |:Upstream bug: :mysqlbug:`71217` - Threadpool - add thd_wait_begin/thd_wait_end to the network IO functions | |
460 | |:Launchpad bug: :bug:`1159743` | |
461 | -|:Upstream state: Open (checked on 2014-08-29) | |
462 | +|:Upstream state: Open (checked on 2014-10-06) | |
463 | |:Fix Released: :rn:`5.6.15-63.0` | |
464 | |:Upstream fix: N/A | |
465 | +-------------------------------------------------------------------------------------------------------------+ |
466 | @@ -133,7 +133,7 @@ |
467 | +-------------------------------------------------------------------------------------------------------------+ |
468 | |:Upstream bug: :mysqlbug:`71411` - buf_flush_LRU() does not return correct number in case of compressed pages| |
469 | |:Launchpad bug: :bug:`1231918` | |
470 | -|:Upstream state: Verified (checked on 2014-08-29) | |
471 | +|:Upstream state: Verified (checked on 2014-10-06) | |
472 | |:Fix Released: :rn:`5.6.13-61.0` | |
473 | |:Upstream fix: N/A | |
474 | +-------------------------------------------------------------------------------------------------------------+ |
475 | @@ -145,7 +145,7 @@ |
476 | +-------------------------------------------------------------------------------------------------------------+ |
477 | |:Upstream bug: :mysqlbug:`70490` - Suppression is too strict on some systems | |
478 | |:Launchpad bug: :bug:`1205196` | |
479 | -|:Upstream state: No Feedback (checked on 2014-08-29) | |
480 | +|:Upstream state: No Feedback (checked on 2014-10-06) | |
481 | |:Fix Released: :rn:`5.6.13-61.0` | |
482 | |:Upstream fix: N/A | |
483 | +-------------------------------------------------------------------------------------------------------------+ |
484 | @@ -157,7 +157,7 @@ |
485 | +-------------------------------------------------------------------------------------------------------------+ |
486 | |:Upstream bug: :mysqlbug:`70500` - Page cleaner should perform LRU flushing regardless of server activity | |
487 | |:Launchpad bug: :bug:`1234562` | |
488 | -|:Upstream state: Open (checked on 2014-08-29) | |
489 | +|:Upstream state: Open (checked on 2014-10-06) | |
490 | |:Fix Released: :rn:`5.6.13-61.0` | |
491 | |:Upstream fix: N/A | |
492 | +-------------------------------------------------------------------------------------------------------------+ |
493 | @@ -175,31 +175,31 @@ |
494 | +-------------------------------------------------------------------------------------------------------------+ |
495 | |:Upstream bug: :mysqlbug:`68481` - InnoDB LRU flushing for MySQL 5.6 needs work | |
496 | |:Launchpad bug: :bug:`1232406` | |
497 | -|:Upstream state: Verified (checked on 2014-08-29) | |
498 | +|:Upstream state: Verified (checked on 2014-10-06) | |
499 | |:Fix Released: :rn:`5.6.13-61.0` | |
500 | |:Upstream fix: N/A | |
501 | +-------------------------------------------------------------------------------------------------------------+ |
502 | |:Upstream bug: :mysqlbug:`70453` - Add hard timeouts to page cleaner flushes | |
503 | |:Launchpad bug: :bug:`1232101` | |
504 | -|:Upstream state: Verified (checked on 2014-08-29) | |
505 | +|:Upstream state: Verified (checked on 2014-10-06) | |
506 | |:Fix Released: :rn:`5.6.13-61.0` | |
507 | |:Upstream fix: N/A | |
508 | +-------------------------------------------------------------------------------------------------------------+ |
509 | |:Upstream bug: :mysqlbug:`69170` - buf_flush_LRU is lazy | |
510 | |:Launchpad bug: :bug:`1231918` | |
511 | -|:Upstream state: Verified (checked on 2014-08-29) | |
512 | +|:Upstream state: Verified (checked on 2014-10-06) | |
513 | |:Fix Released: :rn:`5.6.13-61.0` | |
514 | |:Upstream fix: N/A | |
515 | +-------------------------------------------------------------------------------------------------------------+ |
516 | |:Upstream bug: :mysqlbug:`68555` - thread convoys from log_checkpoint_margin with innodb_buffer_pool_inst... | |
517 | |:Launchpad bug: :bug:`1236884` | |
518 | -|:Upstream state: Verified (checked on 2014-08-29) | |
519 | +|:Upstream state: Verified (checked on 2014-10-06) | |
520 | |:Fix Released: :rn:`5.6.13-61.0` | |
521 | |:Upstream fix: N/A | |
522 | +-------------------------------------------------------------------------------------------------------------+ |
523 | |:Upstream bug: :mysqlbug:`70228` - Is buf_LRU_free_page() really supposed to make non-zip block sticky at ...| |
524 | |:Launchpad bug: :bug:`1220544` | |
525 | -|:Upstream state: Verified (checked on 2014-08-29) | |
526 | +|:Upstream state: Closed | |
527 | |:Fix Released: :rn:`5.6.13-60.6` | |
528 | |:Upstream fix: N/A | |
529 | +-------------------------------------------------------------------------------------------------------------+ |
530 | @@ -217,13 +217,13 @@ |
531 | +-------------------------------------------------------------------------------------------------------------+ |
532 | |:Upstream bug: :mysqlbug:`70216` - Unnecessary overhead from persistent adaptive hash index latches | |
533 | |:Launchpad bug: :bug:`1218347` | |
534 | -|:Upstream state: Verified (checked on 2014-08-29) | |
535 | +|:Upstream state: Verified (checked on 2014-10-06) | |
536 | |:Fix Released: :rn:`5.6.13-60.6` | |
537 | |:Upstream fix: N/A | |
538 | +-------------------------------------------------------------------------------------------------------------+ |
539 | |:Upstream bug: :mysqlbug:`62018` - innodb adaptive hash index mutex contention | |
540 | |:Launchpad bug: :bug:`1216804` | |
541 | -|:Upstream state: Verified (checked on 2014-08-29) | |
542 | +|:Upstream state: Verified (checked on 2014-10-06) | |
543 | |:Fix Released: :rn:`5.6.13-60.6` | |
544 | |:Upstream fix: N/A | |
545 | +-------------------------------------------------------------------------------------------------------------+ |
546 | @@ -241,13 +241,13 @@ |
547 | +-------------------------------------------------------------------------------------------------------------+ |
548 | |:Upstream bug: :mysqlbug:`42415` - UPDATE/DELETE with LIMIT clause unsafe for SBL even with ORDER BY PK ... | |
549 | |:Launchpad bug: :bug:`1132194` | |
550 | -|:Upstream state: Verified (checked on 2014-08-29) | |
551 | +|:Upstream state: Verified (checked on 2014-10-06) | |
552 | |:Fix Released: :rn:`5.6.13-60.5` | |
553 | |:Upstream fix: N/A | |
554 | +-------------------------------------------------------------------------------------------------------------+ |
555 | |:Upstream bug: :mysqlbug:`69639` - mysql failed to build with dtrace Sun D 1.11 | |
556 | |:Launchpad bug: :bug:`1196460` | |
557 | -|:Upstream state: Open (checked on 2014-08-29) | |
558 | +|:Upstream state: Open (checked on 2014-10-06) | |
559 | |:Fix Released: :rn:`5.6.13-60.5` | |
560 | |:Upstream fix: N/A | |
561 | +-------------------------------------------------------------------------------------------------------------+ |
562 | @@ -265,7 +265,7 @@ |
563 | +-------------------------------------------------------------------------------------------------------------+ |
564 | |:Upstream bug: :mysqlbug:`69856` - mysql_install_db does not function properly in 5.6 for debug builds | |
565 | |:Launchpad bug: :bug:`1179359` | |
566 | -|:Upstream state: Verified (checked on 2014-08-29) | |
567 | +|:Upstream state: Verified (checked on 2014-10-06) | |
568 | |:Fix Released: :rn:`5.6.12-60.4` | |
569 | |:Upstream fix: N/A | |
570 | +-------------------------------------------------------------------------------------------------------------+ |
571 | @@ -277,7 +277,7 @@ |
572 | +-------------------------------------------------------------------------------------------------------------+ |
573 | |:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR | |
574 | |:Launchpad bug: :bug:`1262651` | |
575 | -|:Upstream state: Verified (checked on 2014-08-29) | |
576 | +|:Upstream state: Verified (checked on 2014-10-06) | |
577 | |:Fix Released: :rn:`5.6.11-60.3` | |
578 | |:Upstream fix: N/A | |
579 | +-------------------------------------------------------------------------------------------------------------+ |
580 | @@ -307,7 +307,7 @@ |
581 | +-------------------------------------------------------------------------------------------------------------+ |
582 | |:Upstream bug: :mysqlbug:`68714` - Remove literal statement digest values from perfschema tests | |
583 | |:Launchpad bug: :bug:`1157078` | |
584 | -|:Upstream state: Verified (checked on 2014-08-29) | |
585 | +|:Upstream state: Verified (checked on 2014-10-06) | |
586 | |:Fix Released: :rn:`5.6.11-60.3` | |
587 | |:Upstream fix: N/A | |
588 | +-------------------------------------------------------------------------------------------------------------+ |
589 | @@ -331,13 +331,13 @@ |
590 | +-------------------------------------------------------------------------------------------------------------+ |
591 | |:Upstream bug: :mysqlbug:`68970` - fsp_reserve_free_extents switches from small to big tblspace handling ... | |
592 | |:Launchpad bug: :bug:`1169494` | |
593 | -|:Upstream state: Verified (checked on 2014-08-29) | |
594 | +|:Upstream state: Verified (checked on 2014-10-06) | |
595 | |:Fix Released: :rn:`5.6.11-60.3` | |
596 | |:Upstream fix: N/A | |
597 | +-------------------------------------------------------------------------------------------------------------+ |
598 | |:Upstream bug: :mysqlbug:`68713` - create_duplicate_weedout_tmp_table() leaves key_part_flag uninitialized | |
599 | |:Launchpad bug: :bug:`1157037` | |
600 | -|:Upstream state: Verified (checked on 2014-08-29) | |
601 | +|:Upstream state: Verified (checked on 2014-10-06) | |
602 | |:Fix Released: :rn:`5.6.11-60.3` | |
603 | |:Upstream fix: N/A | |
604 | +-------------------------------------------------------------------------------------------------------------+ |
605 | @@ -349,13 +349,13 @@ |
606 | +-------------------------------------------------------------------------------------------------------------+ |
607 | |:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined | |
608 | |:Launchpad bug: :bug:`1183610` | |
609 | -|:Upstream state: No Feedback (checked on 2014-08-29) | |
610 | +|:Upstream state: No Feedback (checked on 2014-10-06) | |
611 | |:Fix Released: :rn:`5.6.11-60.3` | |
612 | |:Upstream fix: N/A | |
613 | +-------------------------------------------------------------------------------------------------------------+ |
614 | |:Upstream bug: :mysqlbug:`68845` - Unnecessary log_sys->mutex reacquisition in mtr_log_reserve_and_write() | |
615 | |:Launchpad bug: :bug:`1163439` | |
616 | -|:Upstream state: Verified (checked on 2014-08-29) | |
617 | +|:Upstream state: Verified (checked on 2014-10-06) | |
618 | |:Fix Released: :rn:`5.6.11-60.3` | |
619 | |:Upstream fix: N/A | |
620 | +-------------------------------------------------------------------------------------------------------------+ |
621 | @@ -385,7 +385,7 @@ |
622 | +-------------------------------------------------------------------------------------------------------------+ |
623 | |:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() | |
624 | |:Launchpad bug: :bug:`1132350` | |
625 | -|:Upstream state: Verified (checked on 2014-08-29) | |
626 | +|:Upstream state: Verified (checked on 2014-10-06) | |
627 | |:Fix Released: :rn:`5.6.11-60.3` | |
628 | |:Upstream fix: N/A | |
629 | +-------------------------------------------------------------------------------------------------------------+ |
630 | @@ -445,7 +445,7 @@ |
631 | +-------------------------------------------------------------------------------------------------------------+ |
632 | |:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..| |
633 | |:Launchpad bug: :bug:`1042517` | |
634 | -|:Upstream state: Verified (checked on 2014-08-29) | |
635 | +|:Upstream state: Verified (checked on 2014-10-06) | |
636 | |:Fix Released: :rn:`5.6.11-60.3` | |
637 | |:Upstream fix: N/A | |
638 | +-------------------------------------------------------------------------------------------------------------+ |
639 | @@ -457,7 +457,7 @@ |
640 | +-------------------------------------------------------------------------------------------------------------+ |
641 | |:Upstream bug: :mysqlbug:`64800` - mysqldump with --include-master-host-port putting quotes around port no. | |
642 | |:Launchpad bug: :bug:`1013432` | |
643 | -|:Upstream state: Verified (checked on 2014-08-29) | |
644 | +|:Upstream state: Verified (checked on 2014-10-06) | |
645 | |:Fix Released: :rn:`5.6.11-60.3` | |
646 | |:Upstream fix: N/A | |
647 | +-------------------------------------------------------------------------------------------------------------+ |
648 | @@ -486,14 +486,14 @@ |
649 | |:Upstream fix: N/A | |
650 | +-------------------------------------------------------------------------------------------------------------+ |
651 | |:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format | |
652 | -|:Launchpad bug: N/A | |
653 | -|:Upstream state: Verified (checked on 2014-08-29) | |
654 | +|:Launchpad bug: :bug:`1148822` | |
655 | +|:Upstream state: Verified (checked on 2014-10-06) | |
656 | |:Fix Released: :rn:`5.6.11-60.3` | |
657 | |:Upstream fix: N/A | |
658 | +-------------------------------------------------------------------------------------------------------------+ |
659 | |:Upstream bug: :mysqlbug:`61595` - mysql-test/include/wait_for_slave_param.inc timeout logic is incorrect | |
660 | |:Launchpad bug: :bug:`800035` | |
661 | -|:Upstream state: Verified (checked on 2014-08-29) | |
662 | +|:Upstream state: Verified (checked on 2014-10-06) | |
663 | |:Fix Released: :rn:`5.6.11-60.3` | |
664 | |:Upstream fix: N/A | |
665 | +-------------------------------------------------------------------------------------------------------------+ |
666 | @@ -505,9 +505,9 @@ |
667 | +-------------------------------------------------------------------------------------------------------------+ |
668 | |:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...| |
669 | |:Launchpad bug: :bug:`1100178` | |
670 | -|:Upstream state: Verified (checked on 2014-08-29) | |
671 | +|:Upstream state: Closed | |
672 | |:Fix Released: :rn:`5.6.10-60.2` | |
673 | -|:Upstream fix: N/A | |
674 | +|:Upstream fix: 5.6.22 | |
675 | +-------------------------------------------------------------------------------------------------------------+ |
676 | |:Upstream bug: :mysqlbug:`65946` - Sid_map::Sid_map calls DBUG which may have unitialized THR_KEY_mysys and..| |
677 | |:Launchpad bug: :bug:`1050758` | |
678 | @@ -517,13 +517,13 @@ |
679 | +-------------------------------------------------------------------------------------------------------------+ |
680 | |:Upstream bug: :mysqlbug:`20001` - Support for temp-tables in INFORMATION_SCHEMA | |
681 | |:Launchpad bug: N/A | |
682 | -|:Upstream state: Verified (checked on 2014-08-29) | |
683 | +|:Upstream state: Verified (checked on 2014-10-06) | |
684 | |:Fix Released: :rn:`5.6.5-60.0` | |
685 | |:Upstream fix: N/A | |
686 | +-------------------------------------------------------------------------------------------------------------+ |
687 | |:Upstream bug: :mysqlbug:`69146` - Optimization in buf_pool_get_oldest_modification if srv_buf_pool_instances| |
688 | |:Launchpad bug: :bug:`1176496` | |
689 | -|:Upstream state: Verified (checked on 2014-08-29) | |
690 | +|:Upstream state: Verified (checked on 2014-10-06) | |
691 | |:Fix Released: :rn:`5.6.5-60.0` | |
692 | |:Upstream fix: N/A | |
693 | +-------------------------------------------------------------------------------------------------------------+ |
Needs updates in www.percona. com/doc/ percona- server/ 5.6/ps- versions- comparison. html www.percona. com/doc/ percona- server/ 5.6/changed_ in_56.html www.percona. com/doc/ percona- server/ 5.6/index_ info_schema_ tables. html
http://
http://
Refresh of http://
The rest of the review in the diff comments