[systemd-devel] mysql open_files_limit controlled by systemd

[Hajo Locke]

Hello,

Am 29.09.2016 um 11:30 schrieb Tomasz Torcz:
> On Thu, Sep 29, 2016 at 11:20:34AM +0200, Hajo Locke wrote:
>> Hello List,
>>
>> we found out that mysql open_files_limit ist controlled by systemd-service
>> file. We used LimitNOFILE to increase default value.
>> This value is always overwriting the value from my.cnf file.
>> Is there a way to tell systemd to not control a service in this way so
>> control completely goes back to original my.cnf values?
>> At the moment i did not found a promising directive.
>    Set LimitNOFILE=infinity.  Then your MySL may set the limit
> on it own, to the value from my.cnf.
>
>
Unfortunately this is not working. We set value in my.cnf lesser than 
value in mysql.service, but its only the value in mysql.service which rules.
May be an OS specific setting? We use Ubuntu 16.04.
It would be nice to tell systemd to let some services make their own rules.

Thanks,
Hajo