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

Proposed by Hrvoje Matijakovic on 2014-11-14
Status: Merged
Approved by: Hrvoje Matijakovic on 2014-11-16
Approved revision: 696
Merged at revision: 696
Proposed branch: lp:~hrvojem/percona-server/bug1392253-5.6
Merge into: lp:percona-server/5.6
Diff against target: 65 lines (+8/-8)
2 files modified
doc/source/management/super_read_only.rst (+2/-2)
doc/source/performance/innodb_numa_support.rst (+6/-6)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1392253-5.6
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) 2014-11-14 Approve on 2014-11-16
Review via email: mp+241814@code.launchpad.net
To post a comment you must log in.
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/management/super_read_only.rst'
2--- doc/source/management/super_read_only.rst 2014-10-29 18:21:06 +0000
3+++ doc/source/management/super_read_only.rst 2014-11-14 14:57:38 +0000
4@@ -4,12 +4,12 @@
5 ``super-read-only`` option
6 ============================
7
8-|Percona Server| has ported new option, :variable:`super_read_only` from *WebScaleSQL*, which is like the `read-only <http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_read_only>`_ option, but affecting users with ``SUPER`` privileges as well. Enabling :variable:`super_read_only` implies regular ``read-only`` as well.
9+|Percona Server| has ported a new option, :variable:`super_read_only` from *WebScaleSQL*, which is like the `read-only <http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_read_only>`_ option, but affecting users with ``SUPER`` privileges as well. Enabling :variable:`super_read_only` implies regular ``read-only`` as well.
10
11 Interaction with :variable:`read_only` variable:
12
13 * Turning :variable:`read_only` off also turns off :variable:`super_read_only`.
14- * Turning :variable:`super_read_only` on also turns :variable:`read_only`` on.
15+ * Turning :variable:`super_read_only` on also turns :variable:`read_only` on.
16 * All other changes to either one of these have no affect on the other.
17
18 System Variables
19
20=== modified file 'doc/source/performance/innodb_numa_support.rst'
21--- doc/source/performance/innodb_numa_support.rst 2013-09-27 11:57:54 +0000
22+++ doc/source/performance/innodb_numa_support.rst 2014-11-14 14:57:38 +0000
23@@ -4,7 +4,7 @@
24 Improved ``NUMA`` support
25 ===========================
26
27-In cases where the buffer pool memory allocation was bigger than size of the node, system would start swapping already allocated memory even if there is available memory on other node. This is would happen if the default :term:`NUMA` memory allocation policy was selected. In that case system would favor one node more than other which caused the node to run out of memory. Changing the allocation policy to interleaving, memory will be allocated in round-robing fashion over the available node. This can be done by using the mysqld_safe :variable:`numa_interleave` option.
28+In cases where the buffer pool memory allocation was bigger than size of the node, system would start swapping already allocated memory even if there is available memory on other node. This is would happen if the default :term:`NUMA` memory allocation policy was selected. In that case system would favor one node more than other which caused the node to run out of memory. Changing the allocation policy to interleaving, memory will be allocated in round-robin fashion over the available node. This can be done by using the mysqld_safe :variable:`numa_interleave` option.
29
30 Another improvement implemented is preallocating the pages in the buffer pool on startup with :variable:`innodb_buffer_pool_populate` variable. This forces ``NUMA`` allocation decisions to be made immediately while the buffer cache is clean.
31
32@@ -22,7 +22,7 @@
33 .. variable:: innodb_buffer_pool_populate
34
35 :cli: Yes
36- :conf: No
37+ :conf: Yes
38 :location: mysqld
39 :scope: Global
40 :dyn: No
41@@ -32,12 +32,12 @@
42
43 When this variable is enabled, |InnoDB| preallocates pages in the buffer pool on startup to force ``NUMA`` allocation decisions to be made immediately while the buffer cache is clean.
44
45-Command-line Options
46-=====================
47+Command-line Options for mysqld_safe
48+====================================
49
50 .. variable:: flush_caches
51
52- :cli: No
53+ :cli: Yes
54 :conf: Yes
55 :location: mysqld_safe
56 :dyn: No
57@@ -49,7 +49,7 @@
58
59 .. variable:: numa_interleave
60
61- :cli: No
62+ :cli: Yes
63 :conf: Yes
64 :location: mysqld_safe
65 :dyn: No

Subscribers

People subscribed via source and target branches