Merge lp:~hrvojem/percona-server/bug1325532-5.1 into lp:percona-server/5.1

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: no longer in the source branch.
Merged at revision: 616
Proposed branch: lp:~hrvojem/percona-server/bug1325532-5.1
Merge into: lp:percona-server/5.1
Diff against target: 208 lines (+36/-31)
5 files modified
doc/source/diagnostics/process_list.rst (+12/-15)
doc/source/diagnostics/slow_extended.rst (+1/-0)
doc/source/installation/yum_repo.rst (+3/-2)
doc/source/management/udf_percona_toolkit.rst (+3/-3)
doc/source/upstream-bug-fixes.rst (+17/-11)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1325532-5.1
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+222021@code.launchpad.net
To post a comment you must log in.
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
=== modified file 'doc/source/diagnostics/process_list.rst'
--- doc/source/diagnostics/process_list.rst 2012-12-13 12:31:02 +0000
+++ doc/source/diagnostics/process_list.rst 2014-06-04 15:28:27 +0000
@@ -22,9 +22,6 @@
22 :column STATE: An action, event, or state that indicates what the thread is doing.22 :column STATE: An action, event, or state that indicates what the thread is doing.
23 :column INFO: The statement that the thread is executing, or NULL if it is not executing any statement.23 :column INFO: The statement that the thread is executing, or NULL if it is not executing any statement.
24 :column TIME_MS: The time in milliseconds that the thread has been in its current state.24 :column TIME_MS: The time in milliseconds that the thread has been in its current state.
25 :column ROWS_EXAMINED: The number of rows examined by the statement being executed.
26 :column ROWS_SENT: The number of rows sent by the statement being executed.
27 :column ROWS_READ: The number of rows read by the statement being executed.
2825
2926
30Example Output27Example Output
@@ -33,21 +30,21 @@
33``SHOW PROCESSLIST`` Command: ::30``SHOW PROCESSLIST`` Command: ::
3431
35 mysql> show processlist;32 mysql> show processlist;
36 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+33 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+
37 | Id | User | Host | db | Command | Time | State | Info | ROWS_SENT | ROWS_EXAMINED | ROWS_READ |34 | Id | User | Host | db | Command | Time | State | Info |
38 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+35 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+
39 | 2 | root | localhost | test | Query | 0 | NULL | SHOW PROCESSLIST | 0 | 0 | 1 |36 | 2 | root | localhost | test | Query | 0 | NULL | SHOW PROCESSLIST |
40 | 14 | root | localhost | test | Query | 0 | User lock | SELECT GET_LOCK(``t``,1000) | 0 | 0 | 1 |37 | 14 | root | localhost | test | Query | 0 | User lock | SELECT GET_LOCK(``t``,1000) |
41 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+-----------+---------------+-----------+38 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+
4239
43Table :table:`PROCESSLIST`: ::40Table :table:`PROCESSLIST`: ::
4441
45 mysql> select * from information_schema.PROCESSLIST;42 mysql> select * from information_schema.PROCESSLIST;
46 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+43 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+
47 | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_EXAMINED | ROWS_SENT | ROWS_READ |44 | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
48 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+45 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+
49 | 14 | root | localhost | test | Query | 0 | User lock | SELECT GET_LOCK(``t``,1000) | 1 | 0 | 0 | 1 |46 | 14 | root | localhost | test | Query | 0 | User lock | SELECT GET_LOCK(``t``,1000) |
50 | 2 | root | localhost | test | Query | 0 | executing | SELECT * from INFORMATION_SCHEMA.PROCESSLIST | 0 | 0 | 0 | 1 |47 | 2 | root | localhost | test | Query | 0 | executing | SELECT * from INFORMATION_SCHEMA.PROCESSLIST |
51 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+----------+---------------+-----------+-----------+48 +------+-----------+-----------+--------+---------+------+------------+----------------------------------------------+
5249
53 50
5451
=== modified file 'doc/source/diagnostics/slow_extended.rst'
--- doc/source/diagnostics/slow_extended.rst 2013-01-15 08:26:36 +0000
+++ doc/source/diagnostics/slow_extended.rst 2014-06-04 15:28:27 +0000
@@ -91,6 +91,7 @@
91 :conf: Yes91 :conf: Yes
92 :scope: Global, session92 :scope: Global, session
93 :dyn: Yes93 :dyn: Yes
94 :range: 1-ULONG_MAX (either 4294967295 or 18446744073709551615, depending on the platform)
9495
95Specifies that only a fraction of sessions should be logged. Logging is enabled for every nth session. By default, n is 1, so logging is enabled for every session. Rate limiting is disabled for the replication thread.96Specifies that only a fraction of sessions should be logged. Logging is enabled for every nth session. By default, n is 1, so logging is enabled for every session. Rate limiting is disabled for the replication thread.
9697
9798
=== modified file 'doc/source/installation/yum_repo.rst'
--- doc/source/installation/yum_repo.rst 2014-05-14 13:42:20 +0000
+++ doc/source/installation/yum_repo.rst 2014-06-04 15:28:27 +0000
@@ -70,7 +70,7 @@
7070
71* *CentOS* 5 and *RHEL* 571* *CentOS* 5 and *RHEL* 5
7272
73* *CentOS* 6 and *RHEL* 6 (Current Stable) [#f1]_ 73* *CentOS* 6 and *RHEL* 6 (Current Stable) [#f1]_
7474
75* *Amazon Linux AMI* (works the same as *CentOS* 5)75* *Amazon Linux AMI* (works the same as *CentOS* 5)
7676
@@ -86,4 +86,5 @@
8686
87.. rubric:: Footnotes87.. rubric:: Footnotes
8888
89.. [#f1] Because there is no official CentOS way to support/get latest OpenSSL on CentOS versions prior to 6.5. Similarly, and also as a result thereof, we decided that there is no official Percona way to support latest |Percona Server| builds on CentOS versions prior to 6.5. Added to this is the fact that many would need to upgrade to OpenSSL 1.0.1g in any case (due to `Heartbleed <http://heartbleed.com>`_ vulnerabilty), and this is not available from any official repo for 6.4 and prior. For any officially unsupported system ``src.rpm`` packages may be used to rebuild |Percona Server| for any environment. 89.. [#f1] "Current Stable": We support only the current stable RHEL6/CentOS6 release, because there is no official (i.e. RedHat provided) method to support or download the latest OpenSSL on RHEL/CentOS versions prior to 6.5. Similarly, and also as a result thereof, there is no official Percona way to support the latest Percona Server builds on RHEL/CentOS versions prior to 6.5. Additionally, many users will need to upgrade to OpenSSL 1.0.1g or later (due to the `Heartbleed vulnerability <http://www.percona.com/resources/ceo-customer-advisory-heartbleed>`_), and this OpenSSL version is not available for download from any official RHEL/Centos repository for versions 6.4 and prior. For any officially unsupported system, src.rpm packages may be used to rebuild Percona Server for any environment. Please contact our `support service <http://www.percona.com/products/mysql-support>`_ if you require further information on this.
90
9091
=== modified file 'doc/source/management/udf_percona_toolkit.rst'
--- doc/source/management/udf_percona_toolkit.rst 2013-10-24 07:48:42 +0000
+++ doc/source/management/udf_percona_toolkit.rst 2014-06-04 15:28:27 +0000
@@ -29,9 +29,9 @@
2929
30These UDFs are part of the |Percona Server| packages. To install one of the UDFs into the server, execute one of the following commands, depending on which UDF you want to install: ::30These UDFs are part of the |Percona Server| packages. To install one of the UDFs into the server, execute one of the following commands, depending on which UDF you want to install: ::
3131
32 $ mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME ``libfnv1a_udf.so``" 32 mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
33 $ mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME ``libfnv_udf.so``" 33 mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
34 $ mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME ``libmurmur_udf.so``"34 mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
3535
36Executing each of these commands will install its respective UDF into the server.36Executing each of these commands will install its respective UDF into the server.
3737
3838
=== modified file 'doc/source/upstream-bug-fixes.rst'
--- doc/source/upstream-bug-fixes.rst 2014-02-05 10:59:08 +0000
+++ doc/source/upstream-bug-fixes.rst 2014-06-04 15:28:27 +0000
@@ -7,7 +7,7 @@
7+-------------------------------------------------------------------------------------------------------------+7+-------------------------------------------------------------------------------------------------------------+
8|:Upstream bug: :mysqlbug:`69407` - Build warnings with mysql |8|:Upstream bug: :mysqlbug:`69407` - Build warnings with mysql |
9|:Launchpad bug: :bug:`1244154` |9|:Launchpad bug: :bug:`1244154` |
10|:Upstream state: Duplicate (checked on 2014-02-05) |10|:Upstream state: Duplicate |
11|:Fix Released: :rn:`5.1.73-14.11` |11|:Fix Released: :rn:`5.1.73-14.11` |
12|:Upstream fix: N/A |12|:Upstream fix: N/A |
13+-------------------------------------------------------------------------------------------------------------+13+-------------------------------------------------------------------------------------------------------------+
@@ -25,13 +25,13 @@
25+-------------------------------------------------------------------------------------------------------------+25+-------------------------------------------------------------------------------------------------------------+
26|:Upstream bug: :mysqlbug:`69379` - MySQL clients return bogus errno for host-not-found errors on Ubuntu 13.04|26|:Upstream bug: :mysqlbug:`69379` - MySQL clients return bogus errno for host-not-found errors on Ubuntu 13.04|
27|:Launchpad bug: :bug:`1186690` |27|:Launchpad bug: :bug:`1186690` |
28|:Upstream state: Verified (checked on 2014-02-05) |28|:Upstream state: Verified (checked on 2014-06-04) |
29|:Fix Released: :rn:`5.1.69-14.7` |29|:Fix Released: :rn:`5.1.69-14.7` |
30|:Upstream fix: N/A |30|:Upstream fix: N/A |
31+-------------------------------------------------------------------------------------------------------------+31+-------------------------------------------------------------------------------------------------------------+
32|:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|32|:Upstream bug: :mysqlbug:`68116` - InnoDB monitor may hit an assertion error in buf_page_get_gen in debug ...|
33|:Launchpad bug: :bug:`1100178` |33|:Launchpad bug: :bug:`1100178` |
34|:Upstream state: Verified (checked on 2014-02-05) |34|:Upstream state: Verified (checked on 2014-06-04) |
35|:Fix Released: :rn:`5.1.67-14.4` |35|:Fix Released: :rn:`5.1.67-14.4` |
36|:Upstream fix: N/A |36|:Upstream fix: N/A |
37+-------------------------------------------------------------------------------------------------------------+37+-------------------------------------------------------------------------------------------------------------+
@@ -47,6 +47,12 @@
47|:Fix Released: :rn:`5.1.67-14.3` |47|:Fix Released: :rn:`5.1.67-14.3` |
48|:Upstream fix: N/A |48|:Upstream fix: N/A |
49+-------------------------------------------------------------------------------------------------------------+49+-------------------------------------------------------------------------------------------------------------+
50|:Upstream bug: :mysqlbug:`71603` - file name is not escaped in binlog for LOAD DATA INFILE statement |
51|:Launchpad bug: :bug:`1277351` |
52|:Upstream state: N/A |
53|:Fix Released: :rn:`5.1.66-14.2` |
54|:Upstream fix: N/A |
55+-------------------------------------------------------------------------------------------------------------+
50|:Upstream bug: :mysqlbug:`66237` - Temporary files created by binary log cache are not purged after transa...|56|:Upstream bug: :mysqlbug:`66237` - Temporary files created by binary log cache are not purged after transa...|
51|:Launchpad bug: :bug:`1070856` |57|:Launchpad bug: :bug:`1070856` |
52|:Upstream state: Closed |58|:Upstream state: Closed |
@@ -79,13 +85,13 @@
79+-------------------------------------------------------------------------------------------------------------+85+-------------------------------------------------------------------------------------------------------------+
80|:Upstream bug: :mysqlbug:`61180` - korr/store macros in my_global.h assume the argument to be a char ... |86|:Upstream bug: :mysqlbug:`61180` - korr/store macros in my_global.h assume the argument to be a char ... |
81|:Launchpad bug: :bug:`1042517` |87|:Launchpad bug: :bug:`1042517` |
82|:Upstream state: Verified (checked on 2014-02-05) |88|:Upstream state: Closed |
83|:Fix Released: :rn:`5.1.66-14.1` |89|:Fix Released: :rn:`5.1.66-14.1` |
84|:Upstream fix: N/A |90|:Upstream fix: N/A |
85+-------------------------------------------------------------------------------------------------------------+91+-------------------------------------------------------------------------------------------------------------+
86|:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|92|:Upstream bug: :mysqlbug:`61178` - Incorrect implementation of intersect(ulonglong) in non-optimized Bitmap..|
87|:Launchpad bug: :bug:`1042517` |93|:Launchpad bug: :bug:`1042517` |
88|:Upstream state: Verified (checked on 2014-02-05) |94|:Upstream state: Verified (checked on 2014-06-04) |
89|:Fix Released: :rn:`5.1.66-14.1` |95|:Fix Released: :rn:`5.1.66-14.1` |
90|:Upstream fix: N/A |96|:Upstream fix: N/A |
91+-------------------------------------------------------------------------------------------------------------+97+-------------------------------------------------------------------------------------------------------------+
@@ -139,7 +145,7 @@
139+-------------------------------------------------------------------------------------------------------------+145+-------------------------------------------------------------------------------------------------------------+
140|:Upstream bug: :mysqlbug:`64127` - MTR --warnings option misses some of InnoDB errors and warnings |146|:Upstream bug: :mysqlbug:`64127` - MTR --warnings option misses some of InnoDB errors and warnings |
141|:Launchpad bug: :bug:`937859` |147|:Launchpad bug: :bug:`937859` |
142|:Upstream state: Verified (checked on 2014-02-05) |148|:Upstream state: Verified (checked on 2014-06-04) |
143|:Fix Released: :rn:`5.1.62-13.3` |149|:Fix Released: :rn:`5.1.62-13.3` |
144|:Upstream fix: N/A |150|:Upstream fix: N/A |
145+-------------------------------------------------------------------------------------------------------------+151+-------------------------------------------------------------------------------------------------------------+
@@ -163,7 +169,7 @@
163+-------------------------------------------------------------------------------------------------------------+169+-------------------------------------------------------------------------------------------------------------+
164|:Upstream bug: :mysqlbug:`62516` - Fast index creation does not update index statistics |170|:Upstream bug: :mysqlbug:`62516` - Fast index creation does not update index statistics |
165|:Launchpad bug: :bug:`857590` |171|:Launchpad bug: :bug:`857590` |
166|:Upstream state: Verified (checked on 2014-02-05) |172|:Upstream state: Verified (checked on 2014-06-04) |
167|:Fix Released: :rn:`5.1.59-13.0` |173|:Fix Released: :rn:`5.1.59-13.0` |
168|:Upstream fix: N/A |174|:Upstream fix: N/A |
169+-------------------------------------------------------------------------------------------------------------+175+-------------------------------------------------------------------------------------------------------------+
@@ -187,7 +193,7 @@
187+-------------------------------------------------------------------------------------------------------------+193+-------------------------------------------------------------------------------------------------------------+
188|:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |194|:Upstream bug: :mysqlbug:`71183` - os_file_fsync() should handle fsync() returning EINTR |
189|:Launchpad bug: :bug:`1262651` |195|:Launchpad bug: :bug:`1262651` |
190|:Upstream state: Verified (checked on 2014-02-05) |196|:Upstream state: Verified (checked on 2014-06-04) |
191|:Fix Released: :rn:`5.1.56-12.7` |197|:Fix Released: :rn:`5.1.56-12.7` |
192|:Upstream fix: N/A |198|:Upstream fix: N/A |
193+-------------------------------------------------------------------------------------------------------------+199+-------------------------------------------------------------------------------------------------------------+
@@ -229,7 +235,7 @@
229+-------------------------------------------------------------------------------------------------------------+235+-------------------------------------------------------------------------------------------------------------+
230|:Upstream bug: :mysqlbug:`55032` - Query cache sometime insert queries to cache, but doesn't find ... |236|:Upstream bug: :mysqlbug:`55032` - Query cache sometime insert queries to cache, but doesn't find ... |
231|:Launchpad bug: none |237|:Launchpad bug: none |
232|:Upstream state: Verified (checked on 2014-02-05) |238|:Upstream state: Verified (checked on 2014-06-04) |
233|:Fix Released: :rn:`5.1.47-rel11.2` |239|:Fix Released: :rn:`5.1.47-rel11.2` |
234|:Upstream fix: N/A |240|:Upstream fix: N/A |
235+-------------------------------------------------------------------------------------------------------------+241+-------------------------------------------------------------------------------------------------------------+
@@ -277,7 +283,7 @@
277+-------------------------------------------------------------------------------------------------------------+283+-------------------------------------------------------------------------------------------------------------+
278|:Upstream bug: :mysqlbug:`44140` - Insert buffer operation may destroy the page during its recovery process |284|:Upstream bug: :mysqlbug:`44140` - Insert buffer operation may destroy the page during its recovery process |
279|:Launchpad bug: none |285|:Launchpad bug: none |
280|:Upstream state: Open (checked on 2014-02-05) |286|:Upstream state: Won't fix |
281|:Fix Released: :rn:`1.0.3-7` |287|:Fix Released: :rn:`1.0.3-7` |
282|:Upstream fix: N/A |288|:Upstream fix: N/A |
283+-------------------------------------------------------------------------------------------------------------+289+-------------------------------------------------------------------------------------------------------------+
@@ -289,7 +295,7 @@
289+-------------------------------------------------------------------------------------------------------------+295+-------------------------------------------------------------------------------------------------------------+
290|:Upstream bug: :mysqlbug:`20001` - Support for temp-tables in INFORMATION_SCHEMA |296|:Upstream bug: :mysqlbug:`20001` - Support for temp-tables in INFORMATION_SCHEMA |
291|:Launchpad bug: none |297|:Launchpad bug: none |
292|:Upstream state: Verified (checked on 2014-02-05) |298|:Upstream state: Verified (checked on 2014-06-04) |
293|:Fix Released: :rn:`1.0.3-7` |299|:Fix Released: :rn:`1.0.3-7` |
294|:Upstream fix: N/A |300|:Upstream fix: N/A |
295+-------------------------------------------------------------------------------------------------------------+301+-------------------------------------------------------------------------------------------------------------+

Subscribers

People subscribed via source and target branches