Merge lp:~hrvojem/percona-server/rn-5.5.36-34.0-5.6 into lp:percona-server/5.6
- rn-5.5.36-34.0-5.6
- Merge into 5.6
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 |
Related bugs: | |
Related blueprints: |
Document backup locks
(High)
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Alexey Kopytov (community) | Needs Fixing | ||
Review via email: mp+209921@code.launchpad.net |
Commit message
Description of the change
Alexey Kopytov (akopytov) wrote : | # |
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
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
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.
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
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_
innodb_
they apply to the LRU manager
too. innodb_
- 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
Hrvoje Matijakovic (hrvojem) wrote : | # |
> - The existing innodb_
> innodb_
> they apply to the LRU manager
> too. innodb_
Fixed everything except this.
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/
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- 263: s/by query thread/by a query thread
- 276: no need to link to cleaner page tuning here?
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
https:/
Laurynas Biveinis (laurynas-biveinis) : | # |
Preview Diff
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 | +-------------------------------------------------------------------------------------------------------------+ |
Where did the "Lightweight Locks" name come from? The feature is called backup locks in the blueprint.