NUMA settings does not take on/off booleans

Bug #1500664 reported by Jervin R
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.6
Fix Released
Medium
Hrvoje Matijakovic
5.7
Fix Released
Medium
Hrvoje Matijakovic

Bug Description

Percona Server 5.6.26:

[mysqld]
innodb_buffer_pool_size = 8G

[mysqld_safe]
numa_interleave = 1|ON|on
flush_caches = 1|ON|on

What numastat shows, only integer values are properly used contrary to documentation https://www.percona.com/doc/percona-server/5.6/performance/innodb_numa_support.html

Enabled with 1 values:
Per-node process memory usage (in MBs) for PID 23414 (mysqld)
                           Node 0 Node 1 Total
                  --------------- --------------- ---------------
Huge 0.00 0.00 0.00
Heap 0.00 0.00 0.00
Stack 292.19 292.42 584.61
Private 233.39 235.55 468.95
---------------- --------------- --------------- ---------------
Total 525.58 527.97 1053.55

"on" values:
Per-node process memory usage (in MBs) for PID 23949 (mysqld)
                           Node 0 Node 1 Total
                  --------------- --------------- ---------------
Huge 0.00 0.00 0.00
Heap 0.00 0.00 0.00
Stack 0.18 1045.71 1045.89
Private 1.98 5.67 7.65
---------------- --------------- --------------- ---------------
Total 2.16 1051.38 1053.54

"ON" values:
Per-node process memory usage (in MBs) for PID 24425 (mysqld)
                           Node 0 Node 1 Total
                  --------------- --------------- ---------------
Huge 0.00 0.00 0.00
Heap 0.00 0.00 0.00
Stack 0.17 621.03 621.20
Private 19.04 413.30 432.34
---------------- --------------- --------------- ---------------
Total 19.21 1034.33 1053.54

Tags: doc
tags: added: doc
Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1654

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.