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 : ls -al /usr/lib/systemd/system/rh-mariadb102-mariadb.service -rw-r--r-- 1 root root 3103 Oct 25 01:50 /usr/lib/systemd/system/rh-mariadb102-mariadb.service in this file header, it says to do # head /usr/lib/systemd/system/rh-mariadb102-mariadb.service # It's not recommended to modify this file in-place, because it will be # overwritten during package upgrades. If you want to customize, the # best way is to create a file "/etc/systemd/system/rh-mariadb102-mariadb.service", # containing # .include /usr/lib/systemd/system/rh-mariadb102-mariadb.service # ...make your changes here... so, Ive made cat /etc/systemd/system/rh-mariadb102-mariadb.service # It's not recommended to modify this file in-place, because it will be # overwritten during package upgrades. If you want to customize, the # best way is to create a file "/etc/systemd/system/rh-mariadb102-mariadb.service", # containing # .include /usr/lib/systemd/system/rh-mariadb102-mariadb.service # ...make your changes here... .include /usr/lib/systemd/system/rh-mariadb102-mariadb.service LimitNOFILE=infinity LimitMEMLOCK=infinity ls -al /etc/systemd/system/rh-mariadb102-mariadb.service -rw-r--r-- 1 root root 455 Jan 4 14:42 /etc/systemd/system/rh-mariadb102-mariadb.service BUT, I don't think it gets picked up ?? I have put the two lines BEFORE I read your email, I'll now try with your options is this sufficient reload to activate changes ? systemctl --system daemon-reload