Merge lp:~hrvojem/percona-server/rn-5.5.36-34.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: 555
Proposed branch: lp:~hrvojem/percona-server/rn-5.5.36-34.0-5.6
Merge into: lp:percona-server/5.6
Diff against target: 763 lines (+330/-69)
10 files modified
doc/source/conf.py (+1/-1)
doc/source/flexibility/mysqlbinlog_change_db.rst (+2/-2)
doc/source/flexibility/slowlog_rotation.rst (+53/-0)
doc/source/index.rst (+2/-0)
doc/source/management/backup_locks.rst (+124/-0)
doc/source/performance/xtradb_performance_improvements_for_io-bound_highly-concurrent_workloads.rst (+22/-19)
doc/source/ps-versions-comparison.rst (+1/-4)
doc/source/release-notes/Percona-Server-5.6.16-64.0.rst (+34/-12)
doc/source/release-notes/release-notes_index.rst (+1/-1)
doc/source/upstream-bug-fixes.rst (+90/-30)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.5.36-34.0-5.6
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Alexey Kopytov (community) Needs Fixing
Review via email: mp+209921@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) wrote :

Where did the "Lightweight Locks" name come from? The feature is called backup locks in the blueprint.

Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :

> Where did the "Lightweight Locks" name come from? The feature is called backup
> locks in the blueprint.

BP says:
Add functionality to Percona Server and XtraBackup to support lightweight locks

Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :

> Where did the "Lightweight Locks" name come from? The feature is called backup
> locks in the blueprint.

Wrong BP in the last one, it should be:

Add functionality to Percona Server lightweight locks

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Hrvoje,

OK, I see. The feature has been renamed twice since the BP was created. Let's keep the "backup locks" name, as it is more explicit IMO.

review: Needs Fixing
Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :

> Hrvoje,
>
> OK, I see. The feature has been renamed twice since the BP was created. Let's
> keep the "backup locks" name, as it is more explicit IMO.

Ah, should be fixed now

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

    - 50: s/5.5/5.6
    - 142: s/another MDL lock type/another new MDL lock type
    - 252: "XtraDB utility thread" is too generic thread name (and
      incorrect: master, purge, cleaner threads are already
      collectively "InnoDB utility threads"). The fitting name could
      be either "LRU cleaner thread", either, as it is called in the
      code, "LRU manager thread". (it is called this way because there
      are plans to extend it to perform more than LRU flushing in the
      future). Please rename the rst file too.
    - 255 and a corresponding part in RN: s/has implemented a new
      .../has split a new ... out of the InnoDB cleaner thread
    - Remove 262, it is invalidated by upstream 5.6.16.
    - s/free lists/buffer pool free lists/g
    - The existing innodb_sched_priority_cleaner and
      innodb_priority_cleaner docs must be updated to indicate that
      they apply to the LRU manager
      too. innodb_sched_priority_cleaner docs are duplicated.
    - 342: FLUSH STATUS could cause a server crash on the next
      transaction commit if two XA-supporting storage engines are in
      use.
    - 358: "The fix for upstream bug ... Bug fixed :bug:`1279671`
      (upstream ... )" (yes this is different from my previous
      suggestion; sorry about that).
    - I don't see the "Percona Server source layout now matches MySQL
      layout better", which should be the same as in 5.5?
    - 1264952 needs description

review: Needs Fixing
Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :

> - The existing innodb_sched_priority_cleaner and
> innodb_priority_cleaner docs must be updated to indicate that
> they apply to the LRU manager
> too. innodb_sched_priority_cleaner docs are duplicated.

Fixed everything except this.

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

    - 257: s/thread/threads
    - 259: s/page cleaner/LRU manager
    - 263: s/mutex contentions, as the buffer pool free list
      mutex/buffer pool free list mutex contention, as the mutex
    - 263: s/was/is
    - 263: s/to the page cleaner thread/to the LRU manager thread
    - 276: s/cleaner/page cleaner
    - 316: s/LRU list/buffer pool LRU list
    - 316: s/buffer pool free lists/buffer pool free list
    - 325: s/cleaner and LRU manager priority thread/page cleaner and
      LRU manager threads
    - 378: s/an alternative/a lightweight alternative, s/for taking
      backups/for taking physical and logical backups
    - 433: Performance schema autosizing heuristics have been updated
      to account for Percona Server-specific
      wait/synch/mutex/sql/THD::LOCK_temporary_tables mutex.

review: Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

    - 263: s/by query thread/by a query thread
    - 276: no need to link to cleaner page tuning here?

review: Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
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/conf.py'
2--- doc/source/conf.py 2014-03-04 06:02:56 +0000
3+++ doc/source/conf.py 2014-03-10 15:06:07 +0000
4@@ -54,7 +54,7 @@
5 # The short X.Y version.
6 version = '5.6'
7 # The full version, including alpha/beta/rc tags.
8-release = '5.6.16-64.0-tokudb'
9+release = '5.6.16-64.0'
10
11 # The language for content autogenerated by Sphinx. Refer to documentation
12 # for a list of supported languages.
13
14=== modified file 'doc/source/flexibility/mysqlbinlog_change_db.rst'
15--- doc/source/flexibility/mysqlbinlog_change_db.rst 2014-03-03 18:32:52 +0000
16+++ doc/source/flexibility/mysqlbinlog_change_db.rst 2014-03-10 15:06:07 +0000
17@@ -32,7 +32,7 @@
18 COMMIT/*!*/;
19 DELIMITER ;
20
21-**mysqlbinlog** output when the new variable is used: ::
22+**mysqlbinlog** output when the new option is used: ::
23
24 $ mysqlbinlog --rewrite-db='world->new_world' mysql-bin.000005
25 ...
26@@ -67,7 +67,7 @@
27 ============================
28
29 * :rn:`5.6.16-64.0`
30- Feature ported from |Percona Server| 5.1
31+ Full functionality.
32
33 Client Command Line Parameter
34 =============================
35
36=== added file 'doc/source/flexibility/slowlog_rotation.rst'
37--- doc/source/flexibility/slowlog_rotation.rst 1970-01-01 00:00:00 +0000
38+++ doc/source/flexibility/slowlog_rotation.rst 2014-03-10 15:06:07 +0000
39@@ -0,0 +1,53 @@
40+.. _slowlog_rotation:
41+
42+========================================
43+ Slow Query Log Rotation and Expiration
44+========================================
45+
46+.. note::
47+
48+ This feature is currently considered BETA quality.
49+
50+Percona has implemented two new variables, :variable:`max_slowlog_size` and :variable:`max_slowlog_files` to provide users with ability to control the slow query log disk usage. These variables have the same behavior as upstream variable `max_binlog_size <https://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_max_binlog_size>`_ and :variable:`max_binlog_files` variable used for controlling the binary log.
51+
52+.. warning::
53+
54+ For this feature to work variable :variable:`slow_query_log_file` needs to be set up manually and without the ``.log`` sufix. The slow query log files will be named using :variable:`slow_query_log_file` as a stem, to which a dot and a sequence number will be appended.
55+
56+Version Specific Information
57+============================
58+
59+ * :rn:`5.6.16-64.0`:
60+ Variable :variable:`max_slowlog_size` introduced.
61+
62+ * :rn:`5.6.16-64.0`:
63+ Variable :variable:`max_slowlog_files` introduced.
64+
65+System Variables
66+================
67+
68+.. variable:: max_slowlog_size
69+
70+ :version 5.6.16-64.0: Introduced.
71+ :cli: Yes
72+ :conf: Yes
73+ :scope: Global
74+ :dyn: Yes
75+ :vartype: numeric
76+ :default: 0 (unlimited)
77+ :range: 4096 - 1073741824
78+
79+Slow query log will be rotated automatically when its size exceeds this value. The default is ``0``, don't limit the size. When this feature is enabled slow query log file will be renamed to :variable:`slow_query_log_file`.000001.
80+
81+.. variable:: max_slowlog_files
82+
83+ :version 5.6.16-64.0: Introduced.
84+ :cli: Yes
85+ :conf: Yes
86+ :scope: Global
87+ :dyn: Yes
88+ :vartype: numeric
89+ :default: 0 (unlimited)
90+ :range: 0 - 102400
91+
92+Maximum number of slow query log files. Used with :variable:`max_slowlog_size` this can be used to limit the total amount of slow query log files. When this number is reached server will create a new slow query log file with increased sequence number. Log file with the lowest sequence number will be deleted.
93
94=== modified file 'doc/source/index.rst'
95--- doc/source/index.rst 2014-03-04 06:02:56 +0000
96+++ doc/source/index.rst 2014-03-10 15:06:07 +0000
97@@ -89,6 +89,7 @@
98 flexibility/extended_select_into_outfile
99 flexibility/per_query_variable_statement
100 flexibility/extended_mysqlbinlog
101+ flexibility/slowlog_rotation
102 flexibility/mysqlbinlog_change_db
103
104 Reliability Improvements
105@@ -122,6 +123,7 @@
106 management/innodb_expanded_fast_index_creation
107 management/log_archiving
108 management/statement_timeout
109+ management/backup_locks
110
111 Diagnostics Improvements
112 ========================
113
114=== added file 'doc/source/management/backup_locks.rst'
115--- doc/source/management/backup_locks.rst 1970-01-01 00:00:00 +0000
116+++ doc/source/management/backup_locks.rst 2014-03-10 15:06:07 +0000
117@@ -0,0 +1,124 @@
118+.. _backup_locks:
119+
120+==============
121+ Backup Locks
122+==============
123+
124+|Percona Server| has implemented this feature in :rn:`5.6.16-64.0` to be a lightweight alternative to ``FLUSH TABLES WITH READ LOCK`` for both physical and logical backups. Three new statements are now available: ``LOCK TABLES FOR BACKUP``, ``LOCK BINLOG FOR BACKUP`` and ``UNLOCK BINLOG``.
125+
126+``LOCK TABLES FOR BACKUP``
127+---------------------------
128+
129+``LOCK TABLES FOR BACKUP`` uses a new MDL lock type to block updates to non-transactional tables and DDL statements for all tables. More specifically, if there's an active ``LOCK TABLES FOR BACKUP`` lock, all DDL statements and all updates to MyISAM, CSV, MEMORY and ARCHIVE tables will be blocked in the ``Waiting for backup lock`` status as visible in ``PERFORMANCE_SCHEMA`` or ``PROCESSLIST``. ``SELECT`` queries for all tables and ``INSERT/REPLACE/UPDATE/DELETE`` against |InnoDB|, Blackhole and Federated tables are not affected by ``LOCK TABLES FOR BACKUP``. Blackhole tables obviously have no relevance for backups, and Federated tables are ignored by both logical and physical backup tools.
130+
131+Unlike ``FLUSH TABLES WITH READ LOCK``, ``LOCK TABLES FOR BACKUP`` does not flush tables, i.e. storage engines are not forced to close tables and tables are not expelled from the table cache. As a result, ``LOCK TABLES FOR BACKUP`` only waits for conflicting statements to complete (i.e. DDL and updates to non-transactional tables). It never waits for SELECTs, or UPDATEs to |InnoDB| tables to complete, for example.
132+
133+If an "unsafe" statement is executed in the same connection that is holding a ``LOCK TABLES FOR BACKUP`` lock, it fails with the following error: ::
134+
135+ ERROR 1880 (HY000): Can't execute the query because you have a conflicting backup lock
136+
137+ UNLOCK TABLES releases the lock acquired by LOCK TABLES FOR BACKUP.
138+
139+``LOCK BINLOG FOR BACKUP``
140+---------------------------
141+
142+``LOCK BINLOG FOR BACKUP`` uses another new MDL lock type to block all operations that might change either binary log position or ``Exec_Master_Log_Pos`` or ``Exec_Gtid_Set`` (i.e. master binary log coordinates corresponding to the current SQL thread state on a replication slave) as reported by ``SHOW MASTER``/``SLAVE STATUS``. More specifically, a commit will only be blocked if the binary log is enabled (both globally, and for connection with sql_log_bin), or if commit is performed by a slave thread and would advance ``Exec_Master_Log_Pos`` or ``Executed_Gtid_Set``. Connections that are currently blocked on the global binlog lock can be identified by the ``Waiting for binlog lock`` status in ``PROCESSLIST``.
143+
144+``UNLOCK BINLOG``
145+------------------
146+
147+``UNLOCK BINLOG`` releases the ``LOCK BINLOG FOR BACKUP`` lock, if acquired by the current connection. The intended use case for |Percona XtraBackup| is: ::
148+
149+ LOCK TABLES FOR BACKUP
150+ ... copy .frm, MyISAM, CSV, etc. ...
151+ LOCK BINLOG FOR BACKUP
152+ UNLOCK TABLES
153+ ... get binlog coordinates ...
154+ ... wait for redo log copying to finish ...
155+ UNLOCK BINLOG
156+
157+Privileges
158+----------
159+
160+Both ``LOCK TABLES FOR BACKUP`` and ``LOCK BINLOG FOR BACKUP`` require the ``RELOAD`` privilege. The reason for that is to have the same requirements as ``FLUSH TABLES WITH READ LOCK``.
161+
162+Interaction with other global locks
163+-----------------------------------
164+
165+Both ``LOCK TABLES FOR BACKUP`` and ``LOCK BINLOG FOR BACKUP`` have no effect if the current connection already owns a ``FLUSH TABLES WITH READ LOCK`` lock, as it's a more restrictive lock. If ``FLUSH TABLES WITH READ LOCK`` is executed in a connection that has acquired ``LOCK TABLES FOR BACKUP`` or ``LOCK BINLOG FOR BACKUP``, ``FLUSH TABLES WITH READ LOCK`` fails with an error.
166+
167+If the server is operating in the read-only mode (i.e. :variable:`read_only` set to ``1``), statements that are unsafe for backups will be either blocked or fail with an error, depending on whether they are executed in the same connection that owns ``LOCK TABLES FOR BACKUP`` lock, or other connections.
168+
169+MyISAM index and data buffering
170+-------------------------------
171+
172+|MyISAM| key buffering is normally write-through, i.e. by the time each update to a |MyISAM| table is completed, all index updates are written to disk. The only exception is delayed key writing feature which is disabled by default.
173+
174+When the global system variable :variable:`delay_key_write` is set to ``ALL``, key buffers for all |MyISAM| tables are not flushed between updates, so a physical backup of those tables may result in broken |MyISAM| indexes. To prevent this, ``LOCK TABLES FOR BACKUP`` will fail with an error if ``delay_key_write`` is set to ``ALL``. An attempt to set :variable:`delay_key_write` to ``ALL`` when there's an active backup lock will also fail with an error.
175+
176+Another option to involve delayed key writing is to create |MyISAM| tables with the DELAY_KEY_WRITE option and set the :variable:`delay_key_write` variable to ``ON`` (which is the default). In this case, ``LOCK TABLES FOR BACKUP`` will not be able to prevent stale index files from appearing in the backup. Users are encouraged to set :variable:`delay_key_writes` to ``OFF`` in the configuration file, :file:`my.cnf`, or repair |MyISAM| indexes after restoring from a physical backup created with backup locks.
177+
178+|MyISAM| may also cache data for bulk inserts, e.g. when executing multi-row INSERTs or ``LOAD DATA`` statements. Those caches, however, are flushed between statements, so have no effect on physical backups as long as all statements updating |MyISAM| tables are blocked.
179+
180+mysqldump
181+---------
182+
183+``mysqldump`` has also been extended with a new option, :option:`lock-for-backup` (disabled by default). When used together with the :option:`--single-transaction` option, the option makes ``mysqldump`` issue ``LOCK TABLES FOR BACKUP`` before starting the dump operation to prevent unsafe statements that would normally result in an inconsistent backup.
184+
185+When used without the :option:`single-transaction` option, :option:`lock-for-backup` is automatically converted to :option:`lock-all-tables`.
186+
187+Option :option:`lock-for-backup` is mutually exclusive with :option:`lock-all-tables`, i.e. specifying both on the command line will lead to an error.
188+
189+If the backup locks feature is not supported by the target server, but :option:`lock-for-backup` is specified on the command line, ``mysqldump`` aborts with an error.
190+
191+If :option:`master-data` is used together with :option:`single-transaction`, :option:`lock-for-backup` does not have any effect, i.e. ``FLUSH TABLES WITH READ LOCK`` will still be used to get the binary log coordinates. This limitation will be removed after implementing the following `blueprint <https://blueprints.launchpad.net/percona-server/+spec/enhancements-for-start-transaction-with-consistent>`_.
192+
193+System Variables
194+================
195+
196+.. variable:: have_backup_locks
197+
198+ :version 5.6.16-64.0: Implemented
199+ :cli: Yes
200+ :conf: No
201+ :scope: Global
202+ :dyn: No
203+ :vartype: Boolean
204+ :default: YES
205+
206+This is a server variable implemented to help other utilities decide what locking strategy can be implemented for a server. When available, the backup locks feature is supported by the server and the variable value is always ``YES``.
207+
208+Status Variables
209+================
210+
211+.. variable:: Com_lock_tables_for_backup
212+
213+ :version 5.6.16-64.0: Implemented
214+ :vartype: Numeric
215+
216+.. variable:: Com_lock_binlog_for_backup
217+
218+ :version 5.6.16-64.0: Implemented
219+ :vartype: Numeric
220+
221+.. variable:: Com_unlock_binlog
222+
223+ :version 5.6.16-64.0: Implemented
224+ :vartype: Numeric
225+
226+These status variables indicate the number of times the corresponding statements have been executed.
227+
228+Client Command Line Parameter
229+=============================
230+
231+.. option:: lock-for-backup
232+
233+ :version 5.6.16-64.0: Implemented
234+ :cli: Yes
235+ :scope: Global
236+ :dyn: No
237+ :vartype: String
238+ :default: Off
239+
240+When used together with the :option:`--single-transaction` option, the option makes ``mysqldump`` issue ``LOCK TABLES FOR BACKUP`` before starting the dump operation to prevent unsafe statements that would normally result in an inconsistent backup.
241+
242
243=== modified file 'doc/source/performance/xtradb_performance_improvements_for_io-bound_highly-concurrent_workloads.rst'
244--- doc/source/performance/xtradb_performance_improvements_for_io-bound_highly-concurrent_workloads.rst 2013-10-24 09:04:33 +0000
245+++ doc/source/performance/xtradb_performance_improvements_for_io-bound_highly-concurrent_workloads.rst 2014-03-10 15:06:07 +0000
246@@ -12,13 +12,13 @@
247 In highly-concurrent I/O-bound workloads the following situation may happen:
248
249 1) Buffer pool free lists are used faster than they are refilled by the LRU cleaner thread.
250- 2) Buffer pool free lists become empty and more and more query and utility (i.e. purge) thread stall, checking whether a free list has became non-empty, sleeping, performing single-page LRU flushes.
251- 3) The number of free list mutex waiters increases.
252- 4) When the page cleaner thread (or a single page LRU flush by a query thread) finally produces a free page, it is starved from putting it on the free list as it must acquire the free list mutex too. However, being one thread in up to hundreds, the chances of a prompt acquisition are low.
253-
254-To avoid this |Percona Server| has implemented priority refill for the buffer pool free list in :rn:`5.6.13-61.0`. This implementation adjusts the free list producer to always acquire the mutex with high priority and free list consumer to always acquire the mutex with low priority. The implementation makes use of :ref:`thread priority lock framework <thread_priority>`.
255-
256-Even the above implementation does not fully resolve the mutex contentions, as the free list mutex is still being acquired needlessly whenever the free list is empty. This was addressed by delegating all the LRU flushes to the page cleaner thread, never attempting to evict a page or perform a LRU single page flush by query thread, and introducing a backoff algorithm to reduce free list mutex pressure on empty free lists. This is controlled through a new system variable :variable:`innodb_empty_free_list_algorithm`.
257+ 2) Buffer pool free lists become empty and more and more query and utility (i.e. purge) threads stall, checking whether a buffer pool free list has became non-empty, sleeping, performing single-page LRU flushes.
258+ 3) The number of buffer pool free list mutex waiters increases.
259+ 4) When the LRU manager thread (or a single page LRU flush by a query thread) finally produces a free page, it is starved from putting it on the buffer pool free list as it must acquire the buffer pool free list mutex too. However, being one thread in up to hundreds, the chances of a prompt acquisition are low.
260+
261+To avoid this |Percona Server| has implemented priority refill for the buffer pool buffer pool free list in :rn:`5.6.13-61.0`. This implementation adjusts the buffer pool free list producer to always acquire the mutex with high priority and buffer pool free list consumer to always acquire the mutex with low priority. The implementation makes use of :ref:`thread priority lock framework <thread_priority>`.
262+
263+Even the above implementation does not fully resolve the buffer pool free list mutex contention, as the mutex is still being acquired needlessly whenever the buffer pool free list is empty. This is addressed by delegating all the LRU flushes to the to the LRU manager thread, never attempting to evict a page or perform a LRU single page flush by a query thread, and introducing a backoff algorithm to reduce buffer pool free list mutex pressure on empty buffer pool free lists. This is controlled through a new system variable :variable:`innodb_empty_free_list_algorithm`.
264
265 .. variable:: innodb_empty_free_list_algorithm
266
267@@ -32,6 +32,18 @@
268
269 When ``legacy`` option is set, server will used the upstream algorithm and when the ``backoff`` is selected, |Percona| implementation will be used.
270
271+.. _lru_manager_thread:
272+
273+LRU manager thread
274+===================
275+
276+|Percona Server| :rn:`5.6.16-64.0` has split a new LRU manager thread out of the |InnoDB| page cleaner thread, that performs LRU flushes and evictions to refill the buffer pool free lists. Before this implementation this was done by the page_cleaner thread together with the flush list flushes.
277+
278+Downsides of that approach were:
279+
280+ * The cleaner thread sleep time has to take into account both LRU and flush list needs, by using the shorter sleep time of the times requested by both. This meant that the code paths for the other one is called at times needlessly.
281+ * LRU/flush list flushes in the cleaner are serialized, which may cause transient stalls (up to LRU/flush list flush timeout values, which are 1 second by default) for user threads in the cases of empty buffer pool free lists and large checkpoint age at the same time.
282+
283 Backoff for sync preflushes
284 ===========================
285
286@@ -71,7 +83,7 @@
287 :values: 1-39
288 :default: 19
289
290-This variable is used to set a thread scheduling priority. Values correspond to Linux ``nice`` values of ``-20..19``, where 0 is 19 (lowest priority) and 39 is -20 (highest priority).
291+This variable is used to set a thread scheduling priority. Values correspond to Linux ``nice`` values of ``-20..19``, where 0 is 19 (lowest priority) and 39 is -20 (highest priority). This priority value affects both cleaner and LRU manager threads.
292
293 |Percona Server| has introduced several options, only available in builds compiled with ``UNIV_PERF_DEBUG`` C preprocessor define.
294
295@@ -93,15 +105,6 @@
296 :dyn: Yes
297 :vartype: Boolean
298
299-.. variable:: innodb_sched_priority_cleaner
300-
301- :version 5.6.13-61.0: Introduced.
302- :cli: Yes
303- :conf: Yes
304- :scope: Global
305- :dyn: Yes
306- :vartype: Boolean
307-
308 .. variable:: innodb_sched_priority_master
309
310 :version 5.6.13-61.0: Introduced.
311@@ -116,7 +119,7 @@
312 Thread Priority Locks
313 =====================
314
315-The |InnoDB| worker threads compete for the shared resource accesses with the query threads. Performance experiments show that under high concurrency the worker threads must acquire the shared resources with priority. To this end, a priority mutex and a priority RW lock locking primitives have been implemented, that use the existing sync array code to wake up any high-priority waiting threads before any low-priority waiting threads, as well as reduce any low-priority thread spinning if any high-priority waiters are already present for a given sync object. The following mutexes have been converted to be priority mutexes: dict_sys, LRU list, free list, rseg, log_sys, and internal hash table sync object array mutexes. The following RW locks have been converted to priority RW locks: fsp, page_hash, AHI, index, and purge. To specify which threads are high-priority for shared resource acquisition, |Percona Server| has introduced several tuning options, only available in builds compiled with ``UNIV_PERF_DEBUG`` C preprocessor define.
316+The |InnoDB| worker threads compete for the shared resource accesses with the query threads. Performance experiments show that under high concurrency the worker threads must acquire the shared resources with priority. To this end, a priority mutex and a priority RW lock locking primitives have been implemented, that use the existing sync array code to wake up any high-priority waiting threads before any low-priority waiting threads, as well as reduce any low-priority thread spinning if any high-priority waiters are already present for a given sync object. The following mutexes have been converted to be priority mutexes: dict_sys, buffer pool LRU list, buffer pool free list, rseg, log_sys, and internal hash table sync object array mutexes. The following RW locks have been converted to priority RW locks: fsp, page_hash, AHI, index, and purge. To specify which threads are high-priority for shared resource acquisition, |Percona Server| has introduced several tuning options, only available in builds compiled with ``UNIV_PERF_DEBUG`` C preprocessor define.
317
318 .. variable:: innodb_priority_purge
319
320@@ -149,7 +152,7 @@
321 :dyn: Yes
322 :vartype: Boolean
323
324-When this option is enabled buffer pool cleaner thread acquire shared resources with priority.
325+When this option is enabled buffer pool page cleaner and LRU manager threads acquire shared resources with priority.
326
327 .. variable:: innodb_priority_master
328
329
330=== modified file 'doc/source/ps-versions-comparison.rst'
331--- doc/source/ps-versions-comparison.rst 2014-03-03 18:32:52 +0000
332+++ doc/source/ps-versions-comparison.rst 2014-03-10 15:06:07 +0000
333@@ -45,7 +45,7 @@
334 - Replaced by the upstream implementation [#n-4]_
335 * - :ref:`Reduced Buffer Pool Mutex Contention <ps51:innodb_opt_lru_count>`
336 - :ref:`Reduced Buffer Pool Mutex Contention <ps55:innodb_opt_lru_count>`
337- - Feature not implemented
338+ - Feature not implemented
339 * - :ref:`InnoDB timer-based Concurrency Throttling <ps51:innodb_thread_concurrency_timer_based_page>`
340 - :ref:`InnoDB timer-based Concurrency Throttling <ps55:innodb_thread_concurrency_timer_based_page>`
341 - Replaced by the upstream implementation [#n-5]_
342@@ -208,9 +208,6 @@
343 * - Feature not implemented
344 - Feature not implemented
345 - :ref:`Per-query variable statement <ps56:per_query_variable_statement>`
346- * - Feature not implemented
347- - :ref:`Extended mysqlbinlog <ps55:extended_mysqlbinlog>`
348- - :ref:`Extended mysqlbinlog <ps56:extended_mysqlbinlog>`
349
350
351 Other Reading
352
353=== modified file 'doc/source/release-notes/Percona-Server-5.6.16-64.0.rst'
354--- doc/source/release-notes/Percona-Server-5.6.16-64.0.rst 2014-03-03 18:32:52 +0000
355+++ doc/source/release-notes/Percona-Server-5.6.16-64.0.rst 2014-03-10 15:06:07 +0000
356@@ -1,47 +1,69 @@
357 .. rn:: 5.6.16-64.0
358
359-=================================================
360- |Percona Server| 5.6.16-64.0 [Not Released Yet]
361-=================================================
362+==============================
363+ |Percona Server| 5.6.16-64.0
364+==============================
365
366-Percona is glad to announce the release of |Percona Server| 5.6.16-64.0 on March 6th, 2014 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.16-64.0/>`_ and from the :doc:`Percona Software Repositories </installation>`).
367+Percona is glad to announce the release of |Percona Server| 5.6.16-64.0 on March 10th, 2014 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.16-64.0/>`_ and from the :doc:`Percona Software Repositories </installation>`).
368
369 Based on `MySQL 5.6.16 <http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-16.html>`_, including all the bug fixes in it, |Percona Server| 5.6.16-64.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.16-64.0 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.6.16-64.0>`_.
370
371 New Features
372 ============
373
374- |Percona Server| now supports :ref:`tokudb_compression` algorithms.
375-
376- In order to comply with Linux distribution packaging standards |Percona|'s version of ``libmysqlclient`` has been renamed to ``libperconaserver``. The reason this was done was to avoid name conflicts with packages upstream name and library conflicts, otherwise, ``libmysqlclient`` and ``libperconaserverclient`` of same version have no differences. Users will have to use ``libmysqlclient`` of respective distributions, for *CentOS* it is ``mysql-libs`` and for *Ubuntu*/*Debian* it is ``libmysqlclient18`` package.
377-
378+ |Percona Server| has implemented :ref:`backup_locks` that can be used as a lightweight alternative to ``FLUSH TABLES WITH READ LOCK`` for taking physical and logical backups.
379+
380+ |Percona Server| has split a new :ref:`lru_manager_thread` out of the InnoDB cleaner thread, that performs ``LRU`` flushes and evictions to refill the free lists.
381+
382+ |Percona Server| now has server-side support for :ref:`tokudb_compression` option syntax.
383+
384+ |Percona Server| has implemented :ref:`slowlog_rotation` feature to provide users with better control of slow query log disk space usage.
385+
386 :ref:`mysqlbinlog_change_db` has been ported from |Percona Server| 5.1.
387
388+ In order to comply with Linux distribution packaging standards |Percona|'s version of ``libmysqlclient`` has been renamed to ``libperconaserver``. The old name was conflicting with the upstream ``libmysqlclient``. Except for packaging, ``libmysqlclient`` and ``libperconaserverclient`` of the same version do not have any differences. Users wishing to continue using ``libmysqlclient`` will have to install the corresponding package of their distribution, such as ``mysql-lib`` for *CentOS* and ``libmysqlclient18`` for *Ubuntu*/*Debian*. Users wishing to build software against ``libperconaserverclient`` should install ``libperconaserverclient-dev`` package. An old version of Percona-built ``libmysqlclient`` will be available for `download <http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.15-rel63.0/deb/>`_.
389+
390 Bugs Fixed
391 ==========
392
393+ The |XtraDB| version number in ``univ.i`` was incorrect. Bug fixed :bug:`1277383`.
394+
395+ :ref:`udf_percona_toolkit` were only shipped with RPM packages. Bug fixed :bug:`1159625`.
396+
397+ A debug server build will crash if, while performing a bulk insert to a partitioned table, one of the partitions will return a failure for ``end_bulk_insert`` handler call. Bug fixed :bug:`1204871` (upstream :mysqlbug:`71270`).
398+
399 |Percona Server| 5.6 installation on *Debian* would fail due to default config reference to ``/etc/mysql/conf.d`` which didn't exist. Bug fixed :bug:`1206648`.
400
401 Due to a regression in the buffer pool mutex split, a combination of |InnoDB| compression, write workload, and multiple active purge threads could lead to a server crash. Bug fixed :bug:`1247021`.
402
403- Several fixes for multiple XA engine support in the server have been ported from |MariaDB|. Bugs fixed :bug:`1255551` (upstream :mysqlbug:`70854`) and :bug:`1255549` (upstream :mysqlbug:`47134`).
404+ Server would crash on startup when XA support functions were activated by a second storage engine. Fix for this bug was ported from |MariaDB|. Bug fixed :bug:`1255549` (upstream :mysqlbug:`47134`).
405+
406+ ``FLUSH STATUS`` could cause a server crash on the next transaction commit if two XA-supporting storage engines are in use. Fix for this bug was ported from |MariaDB|. Bugs fixed :bug:`1255551` (upstream :mysqlbug:`70854`).
407
408 ``auth_pam.so`` shared library needed for :ref:`pam_plugin` was missing from ``RPM`` packages. Bug fixed :bug:`1268246`.
409
410 Fix for bug :bug:`1227581`, a buffer pool mutex split regression, was not complete, thus a combination of write workload to |InnoDB| compressed table and a tablespace drop could crash the server. Bug fixed :bug:`1269352`.
411
412+ Binary RPM packages couldn't be built from source tarballs on *Fedora* 19. Bug fixed :bug:`1229598`.
413+
414 |Percona Server| compilation with Performance Schema turned off would fail due to regression introduced by the 5.6 priority mutex framework. Bug fixed :bug:`1272747`.
415
416- The |InnoDB| page cleaner thread could have incorrectly decided whether the server is busy or idle on some of its iterations and consequently issue a too big flush list flushing request on a busy server, causing performance instabilities. Bug fixed :bug:`1238039`.
417+ The |InnoDB| page cleaner thread could have incorrectly decided whether the server is busy or idle on some of its iterations and consequently issue a too big flush list flushing request on a busy server, causing performance instabilities. Bug fixed :bug:`1238039` (upstream :mysqlbug:`71988`).
418
419 |Percona Server| had different server version value when installing from Source and from Binary/RPM. Bug fixed :bug:`1244178`.
420
421 |InnoDB| did not handle the cases of asynchronous and synchronous I/O requests completing partially or being interrupted. Bugs fixed :bug:`1262500` (upstream :mysqlbug:`54430`), and :bug:`1263087` (*Andrew Gaul*).
422
423- Fixed the upstream bug :mysqlbug:`70768`: the fix for upstream bug :mysqlbug:`70768` may cause a high rate of RW lock creations and desctructions, resulting in a performance regression on some workloads. Bug fixed :bug:`1279671`.
424+ The fix for upstream bug :mysqlbug:`70768` may cause a high rate of RW lock creations and destructions, resulting in a performance regression on some workloads. Bug fixed :bug:`1279671` (upstream :mysqlbug:`71708`).
425
426 *Debian* and *Ubuntu* packaging has been reworked to meet the packaging standards. Bug fixed :bug:`1281261`.
427
428 Fixed the ``CMake`` warnings that were happening when ``Makefile`` was generated. Bugs fixed :bug:`1274827`, upstream bug fixed :mysqlbug:`71089` and :bug:`1274411` (upstream :mysqlbug:`71094`).
429
430-Other bugs fixed: :bug:`1052636`, :bug:`1014477`, :bug:`1276445`, :bug:`1274827` (upstream :mysqlbug:`71089`), :bug:`1264952`, :bug:`1005787`, :bug:`1285064`, :bug:`1229598`, :bug:`1277505` (upstream :mysqlbug:`71624`), and :bug:`1204871` (upstream :mysqlbug:`71270`).
431+ On *Ubuntu* Precise multiple architecture versions of ``libmysqlclient18`` couldn't be installed side by side. Bug fixed :bug:`1052636`.
432+
433+ |Percona Server| source tree has been reorganized to match the |MySQL| source tree layout closer. Bug fixed :bug:`1014477`.
434+
435+ Performance schema autosizing heuristics have been updated to account for Percona Server-specific ``wait/synch/mutex/sql/THD::LOCK_temporary_tables`` mutex. Bug fixed :bug:`1264952`.
436+
437+Other bugs fixed: :bug:`1276445`, :bug:`1005787`, :bug:`1285064`, :bug:`1229598`, and :bug:`1277505` (upstream :mysqlbug:`71624`).
438
439=== modified file 'doc/source/release-notes/release-notes_index.rst'
440--- doc/source/release-notes/release-notes_index.rst 2014-03-04 06:02:56 +0000
441+++ doc/source/release-notes/release-notes_index.rst 2014-03-10 15:06:07 +0000
442@@ -6,8 +6,8 @@
443 :maxdepth: 1
444 :glob:
445
446+ Percona-Server-5.6.16-64.0
447 Percona-Server-5.6.16-64.0-tokudb
448- Percona-Server-5.6.16-64.0
449 Percona-Server-5.6.15-63.0
450 Percona-Server-5.6.14-62.0
451 Percona-Server-5.6.13-61.0
452
453=== modified file 'doc/source/upstream-bug-fixes.rst'
454--- doc/source/upstream-bug-fixes.rst 2014-03-03 17:51:33 +0000
455+++ doc/source/upstream-bug-fixes.rst 2014-03-10 15:06:07 +0000
456@@ -5,9 +5,63 @@
457 =============================================================
458
459 +-------------------------------------------------------------------------------------------------------------+
460+|:Upstream bug: :mysqlbug:`71988` - page_cleaner: aggressive background flushing |
461+|:Launchpad bug: :bug:`1238039` |
462+|:Upstream state: Verified (checked on 2014-03-10) |
463+|:Fix Released: :rn:`5.6.16-64.0` |
464+|:Upstream fix: N/A |
465++-------------------------------------------------------------------------------------------------------------+
466+|:Upstream bug: :mysqlbug:`71624` - printf size_t results in a fatal warning in 32-bit debug builds |
467+|:Launchpad bug: :bug:`1277505` |
468+|:Upstream state: Can't repeat (checked on 2014-03-07) |
469+|:Fix Released: :rn:`5.6.16-64.0` |
470+|:Upstream fix: N/A |
471++-------------------------------------------------------------------------------------------------------------+
472+|:Upstream bug: :mysqlbug:`71094` - ssl.cmake related warnings |
473+|:Launchpad bug: :bug:`1274411` |
474+|:Upstream state: Closed |
475+|:Fix Released: :rn:`5.6.16-64.0` |
476+|:Upstream fix: N/A |
477++-------------------------------------------------------------------------------------------------------------+
478+|:Upstream bug: :mysqlbug:`71089` - CMake warning when generating Makefile |
479+|:Launchpad bug: :bug:`1274827` |
480+|:Upstream state: Closed |
481+|:Fix Released: :rn:`5.6.16-64.0` |
482+|:Upstream fix: 5.6.18 |
483++-------------------------------------------------------------------------------------------------------------+
484+|:Upstream bug: :mysqlbug:`71708` - 70768 fix perf regression: high rate of RW lock creation and destruction |
485+|:Launchpad bug: :bug:`1279671` |
486+|:Upstream state: Verified (checked on 2014-03-07) |
487+|:Fix Released: :rn:`5.6.16-64.0` |
488+|:Upstream fix: N/A |
489++-------------------------------------------------------------------------------------------------------------+
490+|:Upstream bug: :mysqlbug:`54430` - innodb should retry partial reads/writes where errno was 0 |
491+|:Launchpad bug: :bug:`1262500` |
492+|:Upstream state: Closed |
493+|:Fix Released: :rn:`5.6.16-64.0` |
494+|:Upstream fix: N/A |
495++-------------------------------------------------------------------------------------------------------------+
496+|:Upstream bug: :mysqlbug:`70854` - Tc_log_page_size should be unflushable or server crashes if 2 XA SEs ... |
497+|:Launchpad bug: :bug:`1255551` |
498+|:Upstream state: Closed |
499+|:Fix Released: :rn:`5.6.16-64.0` |
500+|:Upstream fix: N/A |
501++-------------------------------------------------------------------------------------------------------------+
502+|:Upstream bug: :mysqlbug:`47134` - Crash on startup when XA support functions activated by a second engine |
503+|:Launchpad bug: :bug:`1255549` |
504+|:Upstream state: Closed |
505+|:Fix Released: :rn:`5.6.16-64.0` |
506+|:Upstream fix: N/A |
507++-------------------------------------------------------------------------------------------------------------+
508+|:Upstream bug: :mysqlbug:`71270` - Failures to end bulk insert for partitioned tables handled incorrectly |
509+|:Launchpad bug: :bug:`1204871` |
510+|:Upstream state: Verified (checked on 2014-03-07) |
511+|:Fix Released: :rn:`5.6.16-64.0` |
512+|:Upstream fix: N/A |
513++-------------------------------------------------------------------------------------------------------------+
514 |:Upstream bug: :mysqlbug:`71217` - Threadpool - add thd_wait_begin/thd_wait_end to the network IO functions |
515 |:Launchpad bug: :bug:`1159743` |
516-|:Upstream state: Open (checked on 2014-02-05) |
517+|:Upstream state: Open (checked on 2014-03-07) |
518 |:Fix Released: :rn:`5.6.15-63.0` |
519 |:Upstream fix: N/A |
520 +-------------------------------------------------------------------------------------------------------------+
521@@ -25,7 +79,7 @@
522 +-------------------------------------------------------------------------------------------------------------+
523 |:Upstream bug: :mysqlbug:`71411` - buf_flush_LRU() does not return correct number in case of compressed pages|
524 |:Launchpad bug: :bug:`1231918` |
525-|:Upstream state: Verified (checked on 2014-02-05) |
526+|:Upstream state: Verified (checked on 2014-03-07) |
527 |:Fix Released: :rn:`5.6.13-61.0` |
528 |:Upstream fix: N/A |
529 +-------------------------------------------------------------------------------------------------------------+
530@@ -37,7 +91,7 @@
531 +-------------------------------------------------------------------------------------------------------------+
532 |:Upstream bug: :mysqlbug:`70490` - Suppression is too strict on some systems |
533 |:Launchpad bug: :bug:`1205196` |
534-|:Upstream state: No Feedback (checked on 2014-02-05) |
535+|:Upstream state: No Feedback (checked on 2014-03-07) |
536 |:Fix Released: :rn:`5.6.13-61.0` |
537 |:Upstream fix: N/A |
538 +-------------------------------------------------------------------------------------------------------------+
539@@ -49,7 +103,7 @@
540 +-------------------------------------------------------------------------------------------------------------+
541 |:Upstream bug: :mysqlbug:`70500` - Page cleaner should perform LRU flushing regardless of server activity |
542 |:Launchpad bug: :bug:`1234562` |
543-|:Upstream state: Open (checked on 2014-02-05) |
544+|:Upstream state: Open (checked on 2014-03-07) |
545 |:Fix Released: :rn:`5.6.13-61.0` |
546 |:Upstream fix: N/A |
547 +-------------------------------------------------------------------------------------------------------------+
548@@ -67,31 +121,31 @@
549 +-------------------------------------------------------------------------------------------------------------+
550 |:Upstream bug: :mysqlbug:`68481` - InnoDB LRU flushing for MySQL 5.6 needs work |
551 |:Launchpad bug: :bug:`1232406` |
552-|:Upstream state: Verified (checked on 2014-02-05) |
553+|:Upstream state: Verified (checked on 2014-03-07) |
554 |:Fix Released: :rn:`5.6.13-61.0` |
555 |:Upstream fix: N/A |
556 +-------------------------------------------------------------------------------------------------------------+
557 |:Upstream bug: :mysqlbug:`70453` - Add hard timeouts to page cleaner flushes |
558 |:Launchpad bug: :bug:`1232101` |
559-|:Upstream state: Verified (checked on 2014-02-05) |
560+|:Upstream state: Verified (checked on 2014-03-07) |
561 |:Fix Released: :rn:`5.6.13-61.0` |
562 |:Upstream fix: N/A |
563 +-------------------------------------------------------------------------------------------------------------+
564 |:Upstream bug: :mysqlbug:`69170` - buf_flush_LRU is lazy |
565 |:Launchpad bug: :bug:`1231918` |
566-|:Upstream state: Verified (checked on 2014-02-05) |
567+|:Upstream state: Verified (checked on 2014-03-07) |
568 |:Fix Released: :rn:`5.6.13-61.0` |
569 |:Upstream fix: N/A |
570 +-------------------------------------------------------------------------------------------------------------+
571 |:Upstream bug: :mysqlbug:`68555` - thread convoys from log_checkpoint_margin with innodb_buffer_pool_inst... |
572 |:Launchpad bug: :bug:`1236884` |
573-|:Upstream state: Verified (checked on 2014-02-05) |
574+|:Upstream state: Verified (checked on 2014-03-07) |
575 |:Fix Released: :rn:`5.6.13-61.0` |
576 |:Upstream fix: N/A |
577 +-------------------------------------------------------------------------------------------------------------+
578 |:Upstream bug: :mysqlbug:`70228` - Is buf_LRU_free_page() really supposed to make non-zip block sticky at ...|
579 |:Launchpad bug: :bug:`1220544` |
580-|:Upstream state: Verified (checked on 2014-02-05) |
581+|:Upstream state: Verified (checked on 2014-03-07) |
582 |:Fix Released: :rn:`5.6.13-60.6` |
583 |:Upstream fix: N/A |
584 +-------------------------------------------------------------------------------------------------------------+
585@@ -109,13 +163,13 @@
586 +-------------------------------------------------------------------------------------------------------------+
587 |:Upstream bug: :mysqlbug:`70216` - Unnecessary overhead from persistent adaptive hash index latches |
588 |:Launchpad bug: :bug:`1218347` |
589-|:Upstream state: Verified (checked on 2014-02-05) |
590+|:Upstream state: Verified (checked on 2014-03-07) |
591 |:Fix Released: :rn:`5.6.13-60.6` |
592 |:Upstream fix: N/A |
593 +-------------------------------------------------------------------------------------------------------------+
594 |:Upstream bug: :mysqlbug:`62018` - innodb adaptive hash index mutex contention |
595 |:Launchpad bug: :bug:`1216804` |
596-|:Upstream state: Verified (checked on 2014-02-05) |
597+|:Upstream state: Verified (checked on 2014-03-07) |
598 |:Fix Released: :rn:`5.6.13-60.6` |
599 |:Upstream fix: N/A |
600 +-------------------------------------------------------------------------------------------------------------+
601@@ -133,13 +187,13 @@
602 +-------------------------------------------------------------------------------------------------------------+
603 |:Upstream bug: :mysqlbug:`42415` - UPDATE/DELETE with LIMIT clause unsafe for SBL even with ORDER BY PK ... |
604 |:Launchpad bug: :bug:`1132194` |
605-|:Upstream state: Verified (checked on 2014-02-05) |
606+|:Upstream state: Verified (checked on 2014-03-07) |
607 |:Fix Released: :rn:`5.6.13-60.5` |
608 |:Upstream fix: N/A |
609 +-------------------------------------------------------------------------------------------------------------+
610 |:Upstream bug: :mysqlbug:`69639` - mysql failed to build with dtrace Sun D 1.11 |
611 |:Launchpad bug: :bug:`1196460` |
612-|:Upstream state: Open (checked on 2014-02-05) |
613+|:Upstream state: Open (checked on 2014-03-07) |
614 |:Fix Released: :rn:`5.6.13-60.5` |
615 |:Upstream fix: N/A |
616 +-------------------------------------------------------------------------------------------------------------+
617@@ -157,13 +211,19 @@
618 +-------------------------------------------------------------------------------------------------------------+
619 |:Upstream bug: :mysqlbug:`69856` - mysql_install_db does not function properly in 5.6 for debug builds |
620 |:Launchpad bug: :bug:`1179359` |
621-|:Upstream state: Verified (checked on 2014-02-05) |
622+|:Upstream state: Verified (checked on 2014-03-07) |
623 |:Fix Released: :rn:`5.6.12-60.4` |
624 |:Upstream fix: N/A |
625 +-------------------------------------------------------------------------------------------------------------+
626+|:Upstream bug: :mysqlbug:`71603` - file name is not escaped in binlog for LOAD DATA INFILE statement |
627+|:Launchpad bug: :bug:`1277351` |
628+|:Upstream state: N/A |
629+|:Fix Released: :rn:`5.6.11-60.3` |
630+|:Upstream fix: N/A |
631++-------------------------------------------------------------------------------------------------------------+
632 |:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |
633 |:Launchpad bug: :bug:`1262651` |
634-|:Upstream state: Verified (checked on 2014-02-05) |
635+|:Upstream state: Verified (checked on 2014-03-07) |
636 |:Fix Released: :rn:`5.6.11-60.3` |
637 |:Upstream fix: N/A |
638 +-------------------------------------------------------------------------------------------------------------+
639@@ -181,7 +241,7 @@
640 +-------------------------------------------------------------------------------------------------------------+
641 |:Upstream bug: :mysqlbug:`69252` - All the parts.partition_max* tests are broken with MTR --parallel |
642 |:Launchpad bug: :bug:`1180481` |
643-|:Upstream state: Verified (checked on 2014-02-05) |
644+|:Upstream state: Verified (checked on 2014-03-07) |
645 |:Fix Released: :rn:`5.6.11-60.3` |
646 |:Upstream fix: N/A |
647 +-------------------------------------------------------------------------------------------------------------+
648@@ -193,7 +253,7 @@
649 +-------------------------------------------------------------------------------------------------------------+
650 |:Upstream bug: :mysqlbug:`68714` - Remove literal statement digest values from perfschema tests |
651 |:Launchpad bug: :bug:`1157078` |
652-|:Upstream state: Verified (checked on 2014-02-05) |
653+|:Upstream state: Verified (checked on 2014-03-07) |
654 |:Fix Released: :rn:`5.6.11-60.3` |
655 |:Upstream fix: N/A |
656 +-------------------------------------------------------------------------------------------------------------+
657@@ -217,13 +277,13 @@
658 +-------------------------------------------------------------------------------------------------------------+
659 |:Upstream bug: :mysqlbug:`68970` - fsp_reserve_free_extents switches from small to big tblspace handling ... |
660 |:Launchpad bug: :bug:`1169494` |
661-|:Upstream state: Verified (checked on 2014-02-05) |
662+|:Upstream state: Verified (checked on 2014-03-07) |
663 |:Fix Released: :rn:`5.6.11-60.3` |
664 |:Upstream fix: N/A |
665 +-------------------------------------------------------------------------------------------------------------+
666 |:Upstream bug: :mysqlbug:`68713` - create_duplicate_weedout_tmp_table() leaves key_part_flag uninitialized |
667 |:Launchpad bug: :bug:`1157037` |
668-|:Upstream state: Verified (checked on 2014-02-05) |
669+|:Upstream state: Verified (checked on 2014-03-07) |
670 |:Fix Released: :rn:`5.6.11-60.3` |
671 |:Upstream fix: N/A |
672 +-------------------------------------------------------------------------------------------------------------+
673@@ -235,13 +295,13 @@
674 +-------------------------------------------------------------------------------------------------------------+
675 |:Upstream bug: :mysqlbug:`68999` - SSL_OP_NO_COMPRESSION not defined |
676 |:Launchpad bug: :bug:`1183610` |
677-|:Upstream state: No Feedback (checked on 2014-02-05) |
678+|:Upstream state: No Feedback (checked on 2014-03-07) |
679 |:Fix Released: :rn:`5.6.11-60.3` |
680 |:Upstream fix: N/A |
681 +-------------------------------------------------------------------------------------------------------------+
682 |:Upstream bug: :mysqlbug:`68845` - Unnecessary log_sys->mutex reacquisition in mtr_log_reserve_and_write() |
683 |:Launchpad bug: :bug:`1163439` |
684-|:Upstream state: Verified (checked on 2014-02-05) |
685+|:Upstream state: Verified (checked on 2014-03-07) |
686 |:Fix Released: :rn:`5.6.11-60.3` |
687 |:Upstream fix: N/A |
688 +-------------------------------------------------------------------------------------------------------------+
689@@ -271,7 +331,7 @@
690 +-------------------------------------------------------------------------------------------------------------+
691 |:Upstream bug: :mysqlbug:`68476` - Suboptimal code in my_strnxfrm_simple() |
692 |:Launchpad bug: :bug:`1132350` |
693-|:Upstream state: Verified (checked on 2014-02-05) |
694+|:Upstream state: Verified (checked on 2014-03-07) |
695 |:Fix Released: :rn:`5.6.11-60.3` |
696 |:Upstream fix: N/A |
697 +-------------------------------------------------------------------------------------------------------------+
698@@ -325,13 +385,13 @@
699 +-------------------------------------------------------------------------------------------------------------+
700 |:Upstream bug: :mysqlbug:`61180` - korr/store macros in my_global.h assume the argument to be a char pointer |
701 |:Launchpad bug: :bug:`1042517` |
702-|:Upstream state: Verified (checked on 2014-02-05) |
703+|:Upstream state: Closed |
704 |:Fix Released: :rn:`5.6.11-60.3` |
705 |:Upstream fix: N/A |
706 +-------------------------------------------------------------------------------------------------------------+
707 |:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|
708 |:Launchpad bug: :bug:`1042517` |
709-|:Upstream state: Verified (checked on 2014-02-05) |
710+|:Upstream state: Verified (checked on 2014-03-07) |
711 |:Fix Released: :rn:`5.6.11-60.3` |
712 |:Upstream fix: N/A |
713 +-------------------------------------------------------------------------------------------------------------+
714@@ -343,7 +403,7 @@
715 +-------------------------------------------------------------------------------------------------------------+
716 |:Upstream bug: :mysqlbug:`64800` - mysqldump with --include-master-host-port putting quotes around port no. |
717 |:Launchpad bug: :bug:`1013432` |
718-|:Upstream state: Verified (checked on 2014-02-05) |
719+|:Upstream state: Verified (checked on 2014-03-07) |
720 |:Fix Released: :rn:`5.6.11-60.3` |
721 |:Upstream fix: N/A |
722 +-------------------------------------------------------------------------------------------------------------+
723@@ -373,13 +433,13 @@
724 +-------------------------------------------------------------------------------------------------------------+
725 |:Upstream bug: :mysqlbug:`25007` - memory tables with dynamic rows format |
726 |:Launchpad bug: N/A |
727-|:Upstream state: Verified (checked on 2014-02-05) |
728+|:Upstream state: Verified (checked on 2014-03-07) |
729 |:Fix Released: :rn:`5.6.11-60.3` |
730 |:Upstream fix: N/A |
731 +-------------------------------------------------------------------------------------------------------------+
732 |:Upstream bug: :mysqlbug:`61595` - mysql-test/include/wait_for_slave_param.inc timeout logic is incorrect |
733 |:Launchpad bug: :bug:`800035` |
734-|:Upstream state: Verified (checked on 2014-02-05) |
735+|:Upstream state: Verified (checked on 2014-03-07) |
736 |:Fix Released: :rn:`5.6.11-60.3` |
737 |:Upstream fix: N/A |
738 +-------------------------------------------------------------------------------------------------------------+
739@@ -391,7 +451,7 @@
740 +-------------------------------------------------------------------------------------------------------------+
741 |:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|
742 |:Launchpad bug: :bug:`1100178` |
743-|:Upstream state: Verified (checked on 2014-02-05) |
744+|:Upstream state: Verified (checked on 2014-03-07) |
745 |:Fix Released: :rn:`5.6.10-60.2` |
746 |:Upstream fix: N/A |
747 +-------------------------------------------------------------------------------------------------------------+
748@@ -403,13 +463,13 @@
749 +-------------------------------------------------------------------------------------------------------------+
750 |:Upstream bug: :mysqlbug:`20001` - Support for temp-tables in INFORMATION_SCHEMA |
751 |:Launchpad bug: N/A |
752-|:Upstream state: Verified (checked on 2014-02-05) |
753+|:Upstream state: Verified (checked on 2014-03-07) |
754 |:Fix Released: :rn:`5.6.5-60.0` |
755 |:Upstream fix: N/A |
756 +-------------------------------------------------------------------------------------------------------------+
757 |:Upstream bug: :mysqlbug:`69146` - Optimization in buf_pool_get_oldest_modification if srv_buf_pool_instances|
758 |:Launchpad bug: :bug:`1176496` |
759-|:Upstream state: Open (checked on 2014-02-05) |
760+|:Upstream state: Open (checked on 2014-03-07) |
761 |:Fix Released: :rn:`5.6.5-60.0` |
762 |:Upstream fix: N/A |
763 +-------------------------------------------------------------------------------------------------------------+

Subscribers

People subscribed via source and target branches