<h2>Editing File: /usr/share/mysql/systemd/mariadb.service</h2><form method='post'><textarea name='content' class='file-edit'># 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 &quot;/etc/systemd/system/mariadb.service&quot;,
# containing
#	.include /usr/lib/systemd/system/mariadb.service
#	...make your changes here...
# or create a file &quot;/etc/systemd/system/mariadb.service.d/foo.conf&quot;,
# which doesn't need to include &quot;.include&quot; call and which will be parsed
# after the file mariadb.service itself is parsed.
#
# For more info about custom unit files, see systemd.unit(5) or
# https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd
#
# Copyright notice:
#
# This file is free software; you can redistribute it and/or modify it
# under the terms of the GNU Lesser General Public License as published by
# the Free Software Foundation; either version 2.1 of the License, or
# (at your option) any later version.

[Unit]
Description=MariaDB 10.11.19 database server
Documentation=man:mariadbd(8)
Documentation=https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd
After=network.target

[Install]
WantedBy=multi-user.target


[Service]

##############################################################################
## Core requirements
##

Type=notify

# Setting this to true can break replication and the Type=notify settings
# See also bind-address mariadbd option.
PrivateNetwork=false

##############################################################################
## Package maintainers
##

User=mysql
Group=mysql

# CAP_IPC_LOCK To allow memlock to be used as non-root user
# These are enabled by default
AmbientCapabilities=CAP_IPC_LOCK

# Prevent writes to /usr, /boot, and /etc
ProtectSystem=full


# Doesn't yet work properly with SELinux enabled
# NoNewPrivileges=true

# Restrict modifications of cgroups from the MariaDB service context.
ProtectControlGroups=true

# Prevent accessing /home, /root and /run/user
ProtectHome=true

# Use an environment file to pass variable _WSREP_NEW_CLUSTER.
# Must not be writable by mysql user.
EnvironmentFile=-/run/mariadb-wsrep-new-cluster

# Needed to create system tables etc.
# ExecStartPre=/usr/bin/mariadb-install-db

# Start main service
# MYSQLD_OPTS here is for users to set in /etc/systemd/system/mariadb.service.d/MY_SPECIAL.conf
# Use the [Service] section and Environment=&quot;MYSQLD_OPTS=...&quot;.
# This isn't a replacement for my.cnf.
# _WSREP_NEW_CLUSTER is for the exclusive use of the script galera_new_cluster
#
# Perform automatic wsrep recovery. When server is started without wsrep,
# galera_recovery simply returns an empty string. In any case, however, it is
# not expected to return a non-zero status.
ExecStart=/bin/sh -c &quot;set -f; [ ! -e /usr/bin/galera_recovery ] &amp;&amp; VAR= || \
 VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] || exit 1; \
 exec /usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $VAR&quot;

# have to set the name explicitly now, otherwise it'll be the
# first name from ExecStart
SyslogIdentifier=mariadbd


KillSignal=SIGTERM

# Don't want to see an automated SIGKILL ever
SendSIGKILL=no

# Restart crashed server only, on-failure would also restart, for example, when
# my.cnf contains unknown option
Restart=on-abnormal
RestartSec=5s

UMask=007

##############################################################################
## USERs can override
##
##
## by creating a file in /etc/systemd/system/mariadb.service.d/MY_SPECIAL.conf
## and adding/setting the following under [Service] will override this file's
## settings.

# Useful options not previously available in [mysqld_safe]

# Kernels like killing mariadbd when out of memory because its big.
# Lets temper that preference a little.
# OOMScoreAdjust=-600

# Explicitly start with high IO priority
# BlockIOWeight=1000

# If you don't use the /tmp directory for SELECT ... OUTFILE and
# LOAD DATA INFILE you can enable PrivateTmp=true for a little more security.
PrivateTmp=false

# Set an explicit Start and Stop timeout of 900 seconds (15 minutes!)
# this is the same value as used in SysV init scripts in the past
# Galera might need a longer timeout, check the KB if you want to change this:
# https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/systemd
TimeoutStartSec=900
TimeoutStopSec=900

# Set the maximium number of tasks (threads) to 99% of what the system can
# handle as set by the kernel, reserve the 1% for a remote ssh connection,
# some monitoring, or that backup cron job. Without the directive this would
# be 15% (see DefaultTasksMax in systemd man pages).
TasksMax=99%

##
## Options previously available to be set via [mysqld_safe]
## that now needs to be set by systemd config files as mysqld_safe
## isn't executed.
##

# Number of files limit. previously [mysqld_safe] open-files-limit
LimitNOFILE=32768

# Maximium core size. previously [mysqld_safe] core-file-size
# LimitCore=

# Nice priority. previously [mysqld_safe] nice
# Nice=-5

# Timezone. previously [mysqld_safe] timezone
# Environment=&quot;TZ=UTC&quot;

# Library substitutions. previously [mysqld_safe] malloc-lib with explicit paths
# (in LD_LIBRARY_PATH) and library name (in LD_PRELOAD).
# Environment=&quot;LD_LIBRARY_PATH=/path1 /path2&quot; &quot;LD_PRELOAD=&quot;

# Flush caches. previously [mysqld_safe] flush-caches=1
# ExecStartPre=sync
# ExecStartPre=sysctl -q -w vm.drop_caches=3

# numa-interleave=1 equalivant
# Change ExecStart=numactl --interleave=all /usr/sbin/mariadbd......

# crash-script equalivent
# FailureAction=
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Fshare%2Fmysql%2Fsystemd'>Back to Directory</a>