mysqld_safe does not correctly parse flush_caches and numa_interleave options
Bug #1231110 reported by
Ovais Tariq
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
5.6 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
Setting the below options to any value disables them:
[mysqld_safe]
flush_caches = yes
numa_interleave = yes
OR
[mysqld_safe]
flush_caches = 1
numa_interleave = 1
This is contrary to the variable being mentioned as a "boolean" variable in the documentation and with the range of values shown as "0/1":
http://
Related branches
lp:~sergei.glushchenko/percona-server/5.5-ps-bug1231110
- Alexey Kopytov (community): Approve
-
Diff: 13 lines (+2/-2)1 file modifiedscripts/mysqld_safe.sh (+2/-2)
lp:~sergei.glushchenko/percona-server/5.6-ps-bug1231110
- Alexey Kopytov (community): Approve
-
Diff: 13 lines (+2/-2)1 file modifiedscripts/mysqld_safe.sh (+2/-2)
tags: |
added: low-hanging-fruit removed: doc |
To post a comment you must log in.
It seems the only way to use these options is to pass them like --numa_interleave and --flush_caches (without arguments) to mysqld_safe at the command line.
Verified by code review of mysqld_safe.sh:
... -syslog- tag=*) syslog_tag="$val" ;; -flush- caches) flush_caches=1 ;; -numa-interleav e) numa_interleave=1 ;;
-
--timezone=*) TZ="$val"; export TZ; ;;
-
-
...
and tests on recent PS 5.5 and 5.6.