Percona Server moved to https://jira.percona.com/projects/PS

Merge lp:~hrvojem/percona-server/rn-5.6.13-61.0 into lp:percona-server/5.6

  1. rn-5.6.13-61.0
  2. Merge into 5.6
Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: no longer in the source branch.
Merged at revision: 465
Proposed branch: lp:~hrvojem/percona-server/rn-5.6.13-61.0
Merge into: lp:percona-server/5.6
Diff against target: 232 lines (+201/-0)
4 files modified
doc/source/feature_comparison.rst (+140/-0)
doc/source/index.rst (+1/-0)
doc/source/release-notes/Percona-Server-5.6.13-61.0.rst (+59/-0)
doc/source/release-notes/release-notes_index.rst (+1/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/rn-5.6.13-61.0
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+189618@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

    - what is "Active Change Buffer Purging"?
    - In New features, XtraDB perf improvements go first, then page
      cleaner tuning, SELECT INTO last.
    - For page cleaner improvements, link to the docs page (probably
      you would have, mentioning just in case)
    - 1217002: due to an incompatible upstream change that went
      unnoticed, the page cleaner thread would attempt to replay any
      file operations it encountered. In most cases this were a
      no-op, but there were race conditions for certain DDL
      operations that would have resulted in server crash.
    - 1159621: Percona Server now ships with memcached plugins.
    - 1194097 1201442 1204873 missing description.
    - 1224432: a server could have crashed under a heavy I/O-bound
      workload involving compressed InnoDB tables.
    - 1115048: a potential deadlock, involving DDL, SELECT, SHOW
      INNODB STATUS, and KILL, has been fixed.
    - 1166638: a memory leak in (link) feature has been fixed.
    - 1191580: a server could crash due to a race condition between a
      INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query and bitmap file
      delete by PURGE CHANGED_PAGE_BITMAP or directly on the file
      system.
    - 235: what is our policy re bugs that were listed on new
      features?
    - The list is incomplete yet, right?

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

    - 201: s/went/went in
    - 215: not all crashes are shutdown. In this case probably let's
      remove the shutdown specifics and leave generic wording could
      crash if threadpool was enabled.

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

    - 175: s/number/a number
    - 177: s/improvements/a number of performance improvements
    - 188: s/went/went in
    - 202: not all crashes are shutdown. In this case probably let's
      remove the shutdown specifics and leave generic wording could
      crash if threadpool was enabled.

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

    - 175: s/number/a number
    - 177: s/improvements/a number of performance improvements

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=== added file 'doc/source/feature_comparison.rst'
2--- doc/source/feature_comparison.rst 1970-01-01 00:00:00 +0000
3+++ doc/source/feature_comparison.rst 2013-10-07 16:50:45 +0000
4@@ -0,0 +1,140 @@
5+=====================================
6+ |Percona Server| Feature Comparison
7+=====================================
8+
9+|Percona Server| is an enhanced drop-in replacement for |MySQL|. With |Percona Server|,
10+
11+ * Your queries will run faster and more consistently.
12+
13+ * You will consolidate servers on powerful hardware.
14+
15+ * You will delay sharding, or avoid it entirely.
16+
17+ * You will save money on hosting fees and power.
18+
19+ * You will spend less time tuning and administering.
20+
21+ * You will achieve higher uptime.
22+
23+ * You will troubleshoot without guesswork.
24+
25+We provide these benefits by significantly enhancing |Percona Server| as compared to the standard |MySQL| database server:
26+
27++---------------------------------------+----------------------+--------------+
28+|Features |Percona Server 5.6.13 |MySQL 5.6.13 |
29++=======================================+======================+==============+
30+|Open source | Yes | Yes |
31++---------------------------------------+----------------------+--------------+
32+|ACID Compliance | Yes | Yes |
33++---------------------------------------+----------------------+--------------+
34+|Multi-Version Concurrency Control | Yes | Yes |
35++---------------------------------------+----------------------+--------------+
36+|Row-Level Locking | Yes | Yes |
37++---------------------------------------+----------------------+--------------+
38+|Automatic Crash Recovery | Yes | Yes |
39++---------------------------------------+----------------------+--------------+
40+|Table Partitioning | Yes | Yes |
41++---------------------------------------+----------------------+--------------+
42+|Views | Yes | Yes |
43++---------------------------------------+----------------------+--------------+
44+|Subqueries | Yes | Yes |
45++---------------------------------------+----------------------+--------------+
46+|Triggers | Yes | Yes |
47++---------------------------------------+----------------------+--------------+
48+|Stored Procedures | Yes | Yes |
49++---------------------------------------+----------------------+--------------+
50+|Foreign Keys | Yes | Yes |
51++---------------------------------------+----------------------+--------------+
52+|GTID Replication | Yes | Yes |
53++---------------------------------------+----------------------+--------------+
54+
55++---------------------------------------+----------------------+--------------+
56+|Extra Features for Developers |Percona Server 5.6.13 |MySQL 5.6.13 |
57++=======================================+======================+==============+
58+|NoSQL Socket-Level Interface | Yes | Yes |
59++---------------------------------------+----------------------+--------------+
60+|Extra Hash/Digest Functions | Yes | |
61++---------------------------------------+----------------------+--------------+
62+
63++---------------------------------------+----------------------+--------------+
64+|Extra Diagnostic Features |Percona Server 5.6.13 |MySQL 5.6.13 |
65++=======================================+======================+==============+
66+|INFORMATION_SCHEMA Tables | 70 | 59 |
67++---------------------------------------+----------------------+--------------+
68+|Global Performance and Status Counters | 398 | 341 |
69++---------------------------------------+----------------------+--------------+
70+|Per-Table Performance Counters | Yes | |
71++---------------------------------------+----------------------+--------------+
72+|Per-Index Performance Counters | Yes | |
73++---------------------------------------+----------------------+--------------+
74+|Per-User Performance Counters | Yes | |
75++---------------------------------------+----------------------+--------------+
76+|Per-Client Performance Counters | Yes | |
77++---------------------------------------+----------------------+--------------+
78+|Per-Thread Performance Counters | Yes | |
79++---------------------------------------+----------------------+--------------+
80+|Global Query Response Time Statistics | Yes | |
81++---------------------------------------+----------------------+--------------+
82+|InnoDB Data Dictionary as I_S Tables | Yes | |
83++---------------------------------------+----------------------+--------------+
84+|Access to InnoDB Data Statistics | Yes | |
85++---------------------------------------+----------------------+--------------+
86+|Enhanced SHOW ENGINE INNODB STATUS | Yes | |
87++---------------------------------------+----------------------+--------------+
88+|Enhanced Mutex Diagnostics | Yes | |
89++---------------------------------------+----------------------+--------------+
90+|Undo Segment Information | Yes | |
91++---------------------------------------+----------------------+--------------+
92+
93++---------------------------------------+----------------------+--------------+
94+|Performance & Scalability Enhancements |Percona Server 5.6.13 |MySQL 5.6.13 |
95++=======================================+======================+==============+
96+|Fine-Grained Mutex Locking | Yes | |
97++---------------------------------------+----------------------+--------------+
98+|Lock-Free Algorithms | Yes | |
99++---------------------------------------+----------------------+--------------+
100+|Improved MEMORY Storage Engine | Yes | |
101++---------------------------------------+----------------------+--------------+
102+|Partitioned Adaptive Hash Search | Yes | |
103++---------------------------------------+----------------------+--------------+
104+|Support for FlashCache | Yes | |
105++---------------------------------------+----------------------+--------------+
106+|Read-Ahead Improvements | Yes | |
107++---------------------------------------+----------------------+--------------+
108+
109++---------------------------------------+----------------------+--------------+
110+|Extra Features for DBA/Operations Staff|Percona Server 5.6.13 |MySQL 5.6.13 |
111++=======================================+======================+==============+
112+|Configurable Page Sizes | Yes | Yes |
113++---------------------------------------+----------------------+--------------+
114+|Configurable Insert Buffer Size | Yes | |
115++---------------------------------------+----------------------+--------------+
116+|Error/Warning Logging Enhancements | Yes | |
117++---------------------------------------+----------------------+--------------+
118+|Configurable Fast Index Creation | Yes | |
119++---------------------------------------+----------------------+--------------+
120+|Support for Fake Changes | Yes | |
121++---------------------------------------+----------------------+--------------+
122+|Changed Page Tracking | Yes | |
123++---------------------------------------+----------------------+--------------+
124+|PAM Authentication | Yes | Yes [#n-1]_ |
125++---------------------------------------+----------------------+--------------+
126+|Threadpool | Yes | Yes [#n-1]_ |
127++---------------------------------------+----------------------+--------------+
128+|Log Archiving | Yes | |
129++---------------------------------------+----------------------+--------------+
130+
131+
132++---------------------------------------+----------------------+--------------+
133+|Running Database as a Service |Percona Server 5.6.13 |MySQL 5.6.13 |
134++=======================================+======================+==============+
135+|Special Utility User | Yes | |
136++---------------------------------------+----------------------+--------------+
137+|Expanded Program Option Modifiers | Yes | |
138++---------------------------------------+----------------------+--------------+
139+|Extended ``secure-file-priv`` option | Yes | |
140++---------------------------------------+----------------------+--------------+
141+|Enforcing the Specific Storage Engine | Yes | |
142++---------------------------------------+----------------------+--------------+
143+
144+.. [#n-1] Feature available in Enterprise version only
145
146=== modified file 'doc/source/index.rst'
147--- doc/source/index.rst 2013-10-07 16:28:01 +0000
148+++ doc/source/index.rst 2013-10-07 16:50:45 +0000
149@@ -40,6 +40,7 @@
150
151 percona_xtradb
152 ps-versions-comparison
153+ feature_comparison
154 changed_in_56
155
156 Installation
157
158=== added file 'doc/source/release-notes/Percona-Server-5.6.13-61.0.rst'
159--- doc/source/release-notes/Percona-Server-5.6.13-61.0.rst 1970-01-01 00:00:00 +0000
160+++ doc/source/release-notes/Percona-Server-5.6.13-61.0.rst 2013-10-07 16:50:45 +0000
161@@ -0,0 +1,59 @@
162+.. rn:: 5.6.13-61.0
163+
164+==============================
165+ |Percona Server| 5.6.13-61.0
166+==============================
167+
168+Percona is glad to announce the first GA (Generally Available) release of |Percona Server| 5.6.13-61.0 on October 7th, 2013 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.13-61.0/>`_ and from the :doc:`Percona Software Repositories </installation>`.
169+
170+Based on `MySQL 5.6.13 <http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-13.html>`_, including all the bug fixes in it, |Percona Server| 5.6.13-61.0 is the first 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.13-60.6 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.6.13-61.0>`_.
171+
172+New Features
173+============
174+
175+ |Percona Server| has implemented a number of :ref:`xtradb_performance_improvements` for high-concurrency scenarios.
176+
177+ |Percona Server| has implemented a number of performance improvements for :ref:`page_cleaner_tuning`. This feature fixes the upstream bugs: :mysqlbug:`69170` (:bug:`1231918`), :mysqlbug:`70453` (:bug:`1232101`) and :mysqlbug:`68481` (:bug:`1232406`).
178+
179+ ``ALL_O_DIRECT`` method for :variable:`innodb_flush_method` has been ported from |Percona Server| 5.5.
180+
181+ :ref:`statement_timeout` feature has been ported from the Twitter branch.
182+
183+ |Percona Server| has :ref:`extended <extended_select_into_outfile>` the ``SELECT INTO ... OUTFILE`` and ``SELECT INTO DUMPFILE`` to add the support for UNIX sockets and named pipes.
184+
185+Bugs Fixed
186+==========
187+
188+ Due to an incompatible upstream change that went in unnoticed, the page cleaner thread would attempt to replay any file operations it encountered. In most cases this were a no-op, but there were race conditions for certain DDL operations that would have resulted in server crash. Bug fixed :bug:`1217002`.
189+
190+ ``apt-get upgrade`` of |Percona Server| would fail in post-installation step if server failed to start. Bug fixed :bug:`1002500`.
191+
192+ |Percona Server| 5.6 now ships with memcached plugins. Bug fixed :bug:`1159621`.
193+
194+ Fixed the ``libssl.so.6`` dependency issues in binary tarballs releases. Bug fixed :bug:`1172916`.
195+
196+ Error in ``install_layout.cmake`` could cause that some library files, during the build, end up in different directories on x86_64 environment. Bug fixed :bug:`1174300`.
197+
198+ Server would crash if empty string was passed to ``AES_ENCRYPT`` when older ``OpenSSL`` version was used. Upstream bug fixed :mysqlbug:`70489`, bug fixed :bug:`1201033`.
199+
200+ :ref:`innodb_kill_idle_trx` feature didn't work correctly if :ref:`threadpool` was enabled. Bug fixed :bug:`1201440`.
201+
202+ |Percona Server| :rn:`5.6.12-60.4` would crash if server was started with :ref:`threadpool` feature enabled. Bugs fixed :bug:`1201681`, :bug:`1194097` and :bug:`1201442`.
203+
204+ Memory leak was introduced by the fix for bug :bug:`1132194`. Bug fixed :bug:`1204873`.
205+
206+ A server could have crashed under a heavy I/O-bound workload involving compressed InnoDB tables. Bug fixed :bug:`1224432`.
207+
208+ A potential deadlock, involving ``DDL``, ``SELECT``, ``SHOW ENGINE INNODB STATUS``, and ``KILL``, has been fixed. Fixed the upstream bug :mysqlbug:`60682`, bug fixed :bug:`1115048`.
209+
210+ A memory leak in :ref:`psaas_utility_user` feature has been fixed. Bug fixed :bug:`1166638`.
211+
212+ A server could crash due to a race condition between a :table:`INNODB_CHANGED_PAGES` query and bitmap file delete by ``PURGE CHANGED_PAGE_BITMAP`` or directly on the file system. Bug fixed :bug:`1191580`.
213+
214+ |Percona Server| could not be built with :ref:`threadpool` feature and ``-DWITH_PERFSCHEMA_ENGINE=OFF`` option. Bug fixed :bug:`1196383`.
215+
216+ Page cleaner should perform LRU flushing regardless of server activity. Fixed the upstream bug :mysqlbug:`70500`, bug fixed :bug:`1234562`.
217+
218+ Fixed the upstream bug :mysqlbug:`64556` which could cause an unrelated warning to be raised if a query inside |InnoDB| was interrupted. Bug fixed :bug:`1115158`.
219+
220+Other bugs fixed: bug fixed :bug:`1131949`, bug fixed :bug:`1191589`, bug fixed :bug:`1229583`, upstream bug fixed :mysqlbug:`70490` bug fixed :bug:`1205196`,upstream bug fixed :mysqlbug:`70417` bug fixed :bug:`1230220`.
221
222=== modified file 'doc/source/release-notes/release-notes_index.rst'
223--- doc/source/release-notes/release-notes_index.rst 2013-09-20 13:13:37 +0000
224+++ doc/source/release-notes/release-notes_index.rst 2013-10-07 16:50:45 +0000
225@@ -6,6 +6,7 @@
226 :maxdepth: 1
227 :glob:
228
229+ Percona-Server-5.6.13-61.0
230 Percona-Server-5.6.13-60.6
231 Percona-Server-5.6.13-60.5
232 Percona-Server-5.6.12-60.4

Subscribers

People subscribed via source and target branches