Override mysqld.service / mariadb.service systemd default settings
Posted by valqk on
If you need to override default systemd mariadb.service / mysqld.service settings, so they stay in act and persistent between updates of the systemd you just have to make:
#> systemctl edit mariadb.service
place in file whatever sections/options you want to change and they will get set in place of the default ones.
For example:
[Service]
ProtectHome = false
BlockIOWeight=1000
Environment="MYSQLD_OPTS=--tmpdir=/var/tmp"
LimitNOFILE=320000
#> systemctll deamon-reexec
#> systemctl restart mariadb
#> systemctl edit mariadb.service
place in file whatever sections/options you want to change and they will get set in place of the default ones.
For example:
[Service]
ProtectHome = false
BlockIOWeight=1000
Environment="MYSQLD_OPTS=--tmpdir=/var/tmp"
LimitNOFILE=320000
#> systemctll deamon-reexec
#> systemctl restart mariadb