[MDEV-9474] group_concat_max_len not being read from /etc/my.cnf Created: 2016-01-27 Updated: 2016-02-24 Resolved: 2016-02-24 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Admin statements |
| Affects Version/s: | 10.1.9 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Jan Steinman | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
MacOS X 10.10.5 via Homebrew |
||
| Issue Links: |
|
||||||||||||
| Description |
|
It seems to me that group_concat_max_len is not being read from /etc/my.cnf. I have this in /etc/my.cnf, in the [mysqld] section: "group_concat_max_len = 65536". But when the server re-starts, it goes back to the default of 1k (too small!). Copying and pasting that same string into mysql (prepended with SET GLOBAL) does work. Upon stopping and re-starting the server, nothing shows up in the log to indicate that /etc/my.cnf may have not been read all the way through. I looked around the website, but could see no documentation for which system variables are honoured in /etc/my.cnf, and I didn't see any way to set this via mysqld arguments, so I have to wait until someone tells me a web page look weird before going in through mysql to fix it! |
| Comments |
| Comment by Elena Stepanova [ 2016-01-27 ] | |||||||||||||||||||||||||||||||||||
|
The variable in the config file works just fine for me:
The reason is usually one of two: either your config file is not read at all, or the option is later overridden in another section or another config file. Given that you are getting the default value, the first reason is more likely. To check it, first start the server with the explicit --defaults-file=/etc/my.cnf option (it must be the first option on the command line!). If the option now gets set all right, it means your installation is such that it does not read from /etc/my.cnf by default. If the server does not start, it will say why, for example, current user does not have permissions to read the file. If the server starts but the option is still not set, check later sections and include directives in the file, something must be overridding the option. Regarding your question about documentation, this is the page: Most variables work both from the config file and from the command-line, so if it is not mentioned specifically, it should be the case. Same goes for group_concat_max_len. | |||||||||||||||||||||||||||||||||||
| Comment by Elena Stepanova [ 2016-02-24 ] | |||||||||||||||||||||||||||||||||||
|
Please comment to re-open if you have further information on the issue. |