On 01/04/18 00:17, Voytek wrote: > On Thu, January 4, 2018 3:17 pm, Bill Shirley wrote: > >> Also, if you running with systemd as init, you need to override >> the limits in the service file: [0:root@elmo SPECS 130]$ cat >> /etc/systemd/system/mariadb.service >> .include /usr/lib/systemd/system/mariadb.service >> >> >> [Service] >> #LimitNOFILE=infinity >> LimitNOFILE=65536 >> LimitMEMLOCK=infinity >> >> >> Your open_files_limit in my.cnf won't do anything until you remove the >> systemd constraints. > > Bill, thanks! > > yes, that's what precisely I'm struggling with, thanks for detailed info!! > > I have it in /usr/lib/systemd/system :
A curse on systemd. I know the problems it was meant to solve, but the cure is worse than the ailment. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958