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

Trackbacks

Trackback specific URI for this entry

This link is not meant to be clicked. It contains the trackback URI for this entry. You can use this URI to send ping- & trackbacks from your own blog to this entry. To copy the link, right click and select "Copy Shortcut" in Internet Explorer or "Copy Link Location" in Mozilla.

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

You can use [geshi lang=lang_name [,ln={y|n}]][/geshi] tags to embed source code snippets.
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA