Merge lp:~hrvojem/percona-server/rn-5.6.21-69.0-5.6 into lp:percona-server/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
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+237030@code.launchpad.net
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 +-------------------------------------------------------------------------------------------------------------+

Subscribers

People subscribed via source and target branches