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

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Hrvoje Matijakovic
Approved revision: no longer in the source branch.
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) Approve
Review via email: mp+241814@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/management/super_read_only.rst'
--- doc/source/management/super_read_only.rst 2014-10-29 18:21:06 +0000
+++ doc/source/management/super_read_only.rst 2014-11-14 14:57:38 +0000
@@ -4,12 +4,12 @@
4 ``super-read-only`` option 4 ``super-read-only`` option
5============================5============================
66
7|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.7|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.
88
9Interaction with :variable:`read_only` variable:9Interaction with :variable:`read_only` variable:
1010
11 * Turning :variable:`read_only` off also turns off :variable:`super_read_only`.11 * Turning :variable:`read_only` off also turns off :variable:`super_read_only`.
12 * Turning :variable:`super_read_only` on also turns :variable:`read_only`` on.12 * Turning :variable:`super_read_only` on also turns :variable:`read_only` on.
13 * All other changes to either one of these have no affect on the other.13 * All other changes to either one of these have no affect on the other.
1414
15System Variables15System Variables
1616
=== modified file 'doc/source/performance/innodb_numa_support.rst'
--- doc/source/performance/innodb_numa_support.rst 2013-09-27 11:57:54 +0000
+++ doc/source/performance/innodb_numa_support.rst 2014-11-14 14:57:38 +0000
@@ -4,7 +4,7 @@
4 Improved ``NUMA`` support4 Improved ``NUMA`` support
5===========================5===========================
66
7In 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.7In 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.
88
9Another 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.9Another 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.
1010
@@ -22,7 +22,7 @@
22.. variable:: innodb_buffer_pool_populate22.. variable:: innodb_buffer_pool_populate
2323
24 :cli: Yes24 :cli: Yes
25 :conf: No25 :conf: Yes
26 :location: mysqld26 :location: mysqld
27 :scope: Global27 :scope: Global
28 :dyn: No28 :dyn: No
@@ -32,12 +32,12 @@
3232
33When 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.33When 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.
3434
35Command-line Options35Command-line Options for mysqld_safe
36=====================36====================================
3737
38.. variable:: flush_caches38.. variable:: flush_caches
3939
40 :cli: No40 :cli: Yes
41 :conf: Yes41 :conf: Yes
42 :location: mysqld_safe42 :location: mysqld_safe
43 :dyn: No43 :dyn: No
@@ -49,7 +49,7 @@
4949
50.. variable:: numa_interleave50.. variable:: numa_interleave
5151
52 :cli: No52 :cli: Yes
53 :conf: Yes53 :conf: Yes
54 :location: mysqld_safe54 :location: mysqld_safe
55 :dyn: No55 :dyn: No

Subscribers

People subscribed via source and target branches