Merge lp:~hrvojem/percona-server/bug1229583-5.6 into lp:percona-server/5.6

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: 436
Merged at revision: 440
Proposed branch: lp:~hrvojem/percona-server/bug1229583-5.6
Merge into: lp:percona-server/5.6
Diff against target: 94 lines (+47/-0)
4 files modified
doc/source/diagnostics/user_stats.rst (+6/-0)
doc/source/faq.rst (+5/-0)
doc/source/scalability/innodb_io.rst (+30/-0)
doc/source/upstream-bug-fixes.rst (+6/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1229583-5.6
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+188424@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

- "but it is skipped for all log files writes" change is lost from the 5.5 MP.
- For innodb_flush_method, at "This is an existing |MySQL| 5.6 system variable.", please clarify what is the Percona addition, for example, " system variable, that has a new allowed value ALL_O_DIRECT" or similar.

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

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/diagnostics/user_stats.rst'
2--- doc/source/diagnostics/user_stats.rst 2013-07-12 08:38:41 +0000
3+++ doc/source/diagnostics/user_stats.rst 2013-10-01 06:08:42 +0000
4@@ -127,6 +127,9 @@
5 | mysql | tables_priv | PRIMARY | 2 |
6 +--------------+-----------------------+--------------------+-----------+
7
8+.. note::
9+
10+ Current implementation of index statistics doesn't support partitioned tables.
11
12
13 .. table:: INFORMATION_SCHEMA.TABLE_STATISTICS
14@@ -149,6 +152,9 @@
15 | mysql | tables_priv | 2 | 0 | 0 |
16 +--------------+-------------------------------+-----------+--------------+------------------------+
17
18+.. note::
19+
20+ Current implementation of table statistics doesn't support partitioned tables.
21
22 .. table:: INFORMATION_SCHEMA.THREAD_STATISTICS
23
24
25=== modified file 'doc/source/faq.rst'
26--- doc/source/faq.rst 2013-05-27 13:46:13 +0000
27+++ doc/source/faq.rst 2013-10-01 06:08:42 +0000
28@@ -18,3 +18,8 @@
29 ===================================================
30
31 A: No, you don't need to change anything on the clients. |Percona Server| is 100% compatible with all existing client libraries and connectors.
32+
33+Q: When using the |Percona XtraBackup| to setup a replication slave on Debian based systems I'm getting: "ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)"
34+==========================================================================================================================================================================================================
35+
36+A: In case you're using init script on Debian based system to start ``mysqld``, be sure that the password for ``debian-sys-maint`` user has been updated and it's the same as that user's password from the server that the backup has been taken from. Password can be seen and updated in :file:`/etc/mysql/debian.cnf`. For more information on how to set up a replication slave using |Percona XtraBackup| see `this how-to <http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/setting_up_replication.html>`_.
37
38=== modified file 'doc/source/scalability/innodb_io.rst'
39--- doc/source/scalability/innodb_io.rst 2013-07-12 08:38:41 +0000
40+++ doc/source/scalability/innodb_io.rst 2013-10-01 06:08:42 +0000
41@@ -47,6 +47,36 @@
42
43 This variable changes the size of transaction log records. The default size of 512 bytes is good in most situations. However, setting it to 4096 may be a good optimization with SSD cards. While settings other than 512 and 4096 are possible, as a practical matter these are really the only two that it makes sense to use. Clean restart and removal of the old logs is needed for the variable :variable:`innodb_log_block_size` to be changed.
44
45+.. variable:: innodb_flush_method
46+
47+ :Version Info: - :rn:`5.6.13-61.0` - Ported from |Percona Server| 5.5
48+ :cli: Yes
49+ :conf: Yes
50+ :scope: Global
51+ :Dyn: No
52+ :vartype: Enumeration
53+ :default: ``fdatasync``
54+ :allowed: ``fdatasync``, ``O_DSYNC``, ``O_DIRECT``, ``O_DIRECT_NO_FSYNC``, ``ALL_O_DIRECT``
55+
56+This is an existing |MySQL| 5.6 system variable that has a new allowed value ``ALL_O_DIRECT``. It determines the method |InnoDB| uses to flush its data and log files. (See ``innodb_flush_method`` in the |MySQL| 5.6 `Reference Manual <https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_flush_method>`_).
57+
58+The following values are allowed:
59+
60+ * ``fdatasync``:
61+ use ``fsync()`` to flush both the data and log files.
62+
63+ * ``O_SYNC``:
64+ use O_SYNC to open and flush the log files; use ``fsync()`` to flush the data files.
65+
66+ * ``O_DIRECT``:
67+ use O_DIRECT to open the data files and fsync() system call to flush both the data and log files.
68+
69+ * ``O_DIRECT_NO_FSYNC``:
70+ use O_DIRECT to open the data files but don't use ``fsync()`` system call to flush both the data and log files. This option isn't suitable for *XFS* file system.
71+
72+ * ``ALL_O_DIRECT``:
73+ use O_DIRECT to open both data and log files, and use ``fsync()`` to flush the data files but not the log files. This option is recommended when |InnoDB| log files are big (more than 8GB), otherwise there might be even a performance degradation. **Note**: When using this option on *ext4* filesystem variable :variable:`innodb_log_block_size` should be set to 4096 (default log-block-size in *ext4*) in order to avoid the ``unaligned AIO/DIO`` warnings.
74+
75 Status Variables
76 ----------------
77
78
79=== modified file 'doc/source/upstream-bug-fixes.rst'
80--- doc/source/upstream-bug-fixes.rst 2013-09-27 11:57:54 +0000
81+++ doc/source/upstream-bug-fixes.rst 2013-10-01 06:08:42 +0000
82@@ -71,6 +71,12 @@
83 |:Fix Released: :rn:`5.6.12-60.4` |
84 |:Upstream fix: N/A |
85 +-------------------------------------------------------------------------------------------------------------+
86+|:Upstream bug: :mysqlbug:`70277` - last argument of LOAD DATA ... SET ... statement repeated twice in binlog |
87+|:Launchpad bug: :bug:`1223196` |
88+|:Upstream state: Verified (checked on 2013-09-30) |
89+|:Fix Released: :rn:`5.6.11-60.3` |
90+|:Upstream fix: N/A |
91++-------------------------------------------------------------------------------------------------------------+
92 |:Upstream bug: :mysqlbug:`69252` - All the parts.partition_max* tests are broken with MTR --parallel |
93 |:Launchpad bug: :bug:`1180481` |
94 |:Upstream state: Verified (checked on 2013-09-27) |

Subscribers

People subscribed via source and target branches