ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: usr / lib / systemd / system

# 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/mariadb.service",
# containing
#	.include /usr/lib/systemd/system/mariadb.service
#	...make your changes here...
# or create a file "/etc/systemd/system/mariadb.service.d/foo.conf",
# which doesn't need to include ".include" 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/kb/en/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.5.29 database server
Documentation=man:mariadbd(8)
Documentation=https://mariadb.com/kb/en/library/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

# PrivateDevices=true implies NoNewPrivileges=true and
# SUID auth_pam_tool suddenly doesn't do setuid anymore
PrivateDevices=false

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

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

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

# Execute pre and post scripts as root, otherwise it does it as User=
PermissionsStartOnly=true

# Perform automatic wsrep recovery. When server is started without wsrep,
# galera_recovery simply returns an empty string. In any case, however,
# the script is not expected to return with a non-zero status.
# It is always safe to unset _WSREP_START_POSITION environment variable.
# Do not panic if galera_recovery script is not available. (MDEV-10538)
ExecStartPre=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION"
ExecStartPre=/bin/sh -c "[ ! -e /usr/bin/galera_recovery ] && VAR= || \
 VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] \
 && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1"

# Needed to create system tables etc.
# ExecStartPre=/usr/bin/mysql_install_db -u mysql

# 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="MYSQLD_OPTS=...".
# This isn't a replacement for my.cnf.
# _WSREP_NEW_CLUSTER is for the exclusive use of the script galera_new_cluster
ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION

# Unset _WSREP_START_POSITION environment variable.
ExecStartPost=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION"

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-abort
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/kb/en/library/systemd/#configuring-the-systemd-service-timeout
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="TZ=UTC"

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

# 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=

[+] ..
[-] psacct.service [edit]
[-] time-set.target [edit]
[-] kexec.target [edit]
[-] systemd-tmpfiles-clean.service [edit]
[-] boot-complete.target [edit]
[-] sys-kernel-tracing.mount [edit]
[-] sssd.service [edit]
[-] mysql.service [edit]
[-] systemd-initctl.socket [edit]
[-] printer.target [edit]
[-] sssd-nss.socket [edit]
[-] nss-user-lookup.target [edit]
[+] halt.target.wants
[-] iprutils.target [edit]
[-] iscsi-starter.service [edit]
[-] ea-php83-php-fpm.service [edit]
[-] initrd-switch-root.service [edit]
[-] first-boot-complete.target [edit]
[-] mcelog.service [edit]
[-] proc-fs-nfsd.mount [edit]
[-] systemd-udev-settle.service [edit]
[+] runlevel5.target.wants
[-] nis-domainname.service [edit]
[-] systemd-rfkill.socket [edit]
[-] imunify-notifier.service [edit]
[-] rpc-statd-notify.service [edit]
[-] dracut-pre-trigger.service [edit]
[-] autovt@.service [edit]
[-] teamd@.service [edit]
[-] runlevel4.target [edit]
[-] systemd-journald@.socket [edit]
[+] -.slice.d
[-] iscsi-shutdown.service [edit]
[-] initrd-root-device.target [edit]
[-] sssd-kcm.socket [edit]
[-] halt.target [edit]
[+] system-update.target.wants
[-] usb-gadget.target [edit]
[-] systemd-udevd-control.socket [edit]
[-] serial-getty@.service [edit]
[-] systemd-binfmt.service [edit]
[-] lvm2-monitor.service [edit]
[-] plymouth-halt.service [edit]
[-] local-fs-pre.target [edit]
[-] systemd-journald.socket [edit]
[-] systemd-udev-trigger.service [edit]
[-] multipathd.service [edit]
[-] named-setup-rndc.service [edit]
[-] hybrid-sleep.target [edit]
[-] dracut-initqueue.service [edit]
[+] sysinit.target.wants
[-] systemd-kexec.service [edit]
[-] dracut-pre-udev.service [edit]
[-] pam_namespace.service [edit]
[-] raid-check.service [edit]
[-] iscsiuio.service [edit]
[-] systemd-journald@.service [edit]
[+] dbus.target.wants
[-] multipathd.socket [edit]
[-] systemd-modules-load.service [edit]
[-] plymouth-reboot.service [edit]
[-] nfs-blkmap.service [edit]
[-] systemd-coredump.socket [edit]
[-] systemd-update-utmp-runlevel.service [edit]
[-] initrd-switch-root.target [edit]
[-] runlevel5.target [edit]
[-] systemd-suspend-then-hibernate.service [edit]
[-] NetworkManager-dispatcher.service [edit]
[-] sshd-keygen.target [edit]
[-] dracut-shutdown-onfailure.service [edit]
[-] plymouth-kexec.service [edit]
[-] runlevel6.target [edit]
[-] systemd-tmpfiles-setup-dev.service [edit]
[-] systemd-journald-varlink@.socket [edit]
[-] firewalld.service [edit]
[-] nvmefc-boot-connections.service [edit]
[-] rtkit-daemon.service [edit]
[-] plymouth-switch-root.service [edit]
[-] systemd-ask-password-console.path [edit]
[-] dbus-org.freedesktop.login1.service [edit]
[-] dracut-pre-mount.service [edit]
[-] nvmf-connect.target [edit]
[-] imunify-antivirus-user.socket [edit]
[-] imunify-antivirus.socket [edit]
[-] sysstat-summary.timer [edit]
[-] systemd-machine-id-commit.service [edit]
[-] mdmon@.service [edit]
[-] iscsi.service [edit]
[-] grub2-systemd-integration.service [edit]
[-] container-getty@.service [edit]
[-] plymouth-switch-root-initramfs.service [edit]
[-] sssd-pam-priv.socket [edit]
[-] gssproxy.service [edit]
[-] mysqld.service [edit]
[-] systemd-pcrphase.service [edit]
[-] ea-php81-php-fpm.service [edit]
[-] syslog.socket [edit]
[+] rescue.target.wants
[-] sys-kernel-config.mount [edit]
[-] mdcheck_start.service [edit]
[-] getty-pre.target [edit]
[-] systemd-halt.service [edit]
[-] auditd.service [edit]
[+] default.target.wants
[-] dnf-system-upgrade-cleanup.service [edit]
[-] sshd.service [edit]
[-] system-update.target [edit]
[-] systemd-hwdb-update.service [edit]
[+] systemd-logind.service.d
[-] systemd-journald.service [edit]
[-] polkit.service [edit]
[-] user@.service [edit]
[-] systemd-suspend.service [edit]
[-] mdadm-grow-continue@.service [edit]
[-] dev-hugepages.mount [edit]
[-] aibolit-resident.socket [edit]
[-] initrd-fs.target [edit]
[-] system-update-cleanup.service [edit]
[-] named.service [edit]
[-] smartcard.target [edit]
[-] fstrim.service [edit]
[-] imunify-notifier.socket [edit]
[-] rpcbind.socket [edit]
[-] mlocate-updatedb.service [edit]
[-] sys-fs-fuse-connections.mount [edit]
[-] plymouth-read-write.service [edit]
[-] lsws.service [edit]
[-] mdcheck_continue.timer [edit]
[-] runlevel3.target [edit]
[-] tmp.mount [edit]
[-] sssd-autofs.service [edit]
[-] nvmf-connect@.service [edit]
[-] loadmodules.service [edit]
[-] systemd-hibernate.service [edit]
[-] sssd-pam.socket [edit]
[-] nfs-utils.service [edit]
[-] network-pre.target [edit]
[-] systemd-tmpfiles-clean.timer [edit]
[-] swap.target [edit]
[-] systemd-fsck-root.service [edit]
[-] systemd-sysctl.service [edit]
[-] sysstat.service [edit]
[-] canberra-system-shutdown-reboot.service [edit]
[-] runlevel2.target [edit]
[-] initrd-root-fs.target [edit]
[-] rescue.service [edit]
[-] dnf-makecache.service [edit]
[-] sshd.socket [edit]
[-] nfs-client.target [edit]
[-] nss-lookup.target [edit]
[-] upower.service [edit]
[-] timers.target [edit]
[-] dracut-mount.service [edit]
[-] systemd-quotacheck.service [edit]
[-] integritysetup.target [edit]
[+] runlevel1.target.wants
[+] reboot.target.wants
[+] mariadb@bootstrap.service.d
[-] systemd-hostnamed.service [edit]
[-] mdmonitor.service [edit]
[-] sound.target [edit]
[-] nfs-mountd.service [edit]
[+] user@0.service.d
[-] plymouth-poweroff.service [edit]
[-] systemd-journald-audit.socket [edit]
[-] multi-user.target [edit]
[-] network.target [edit]
[-] systemd-boot-update.service [edit]
[-] hibernate.target [edit]
[-] lfd.service [edit]
[-] rpcbind.target [edit]
[-] systemd-exit.service [edit]
[-] dracut-cmdline.service [edit]
[-] sigpwr.target [edit]
[-] systemd-sysusers.service [edit]
[-] crond.service [edit]
[-] systemd-firstboot.service [edit]
[-] dm-event.service [edit]
[-] user.slice [edit]
[-] rdisc.service [edit]
[-] systemd-pcrmachine.service [edit]
[-] iprinit.service [edit]
[-] sshd@.service [edit]
[+] initrd-switch-root.target.wants
[-] realmd.service [edit]
[-] nm-priv-helper.service [edit]
[-] libstoragemgmt.service [edit]
[-] sssd-pac.socket [edit]
[-] plymouth-quit.service [edit]
[-] cpupower.service [edit]
[-] veritysetup-pre.target [edit]
[-] mdcheck_continue.service [edit]
[-] imunify-antivirus-sensor.socket [edit]
[-] basic.target [edit]
[-] csf.service [edit]
[-] systemd-growfs-root.service [edit]
[+] sw-engine.service.d
[-] sssd-pam.service [edit]
[-] kdump.service [edit]
[-] graphical.target [edit]
[-] NetworkManager.service [edit]
[-] blk-availability.service [edit]
[-] console-getty.service [edit]
[-] dbus-org.freedesktop.locale1.service [edit]
[+] runlevel2.target.wants
[-] plymouth-quit-wait.service [edit]
[-] systemd-pcrfs-root.service [edit]
[-] rpmdb-rebuild.service [edit]
[-] nvmf-autoconnect.service [edit]
[-] auth-rpcgss-module.service [edit]
[+] runlevel4.target.wants
[+] initrd-root-fs.target.wants
[-] suspend-then-hibernate.target [edit]
[-] systemd-ask-password-plymouth.service [edit]
[-] sockets.target [edit]
[-] chronyd-restricted.service [edit]
[-] systemd-ask-password-wall.path [edit]
[-] suspend.target [edit]
[-] pdns@.service [edit]
[+] initrd-root-device.target.wants
[-] dracut-pre-pivot.service [edit]
[-] var-lib-nfs-rpc_pipefs.mount [edit]
[-] rc-local.service [edit]
[-] debug-shell.service [edit]
[-] nscd.socket [edit]
[-] rescue.target [edit]
[-] kvm_stat.service [edit]
[-] mdmonitor-oneshot.timer [edit]
[-] systemd-udevd.service [edit]
[-] sssd-sudo.socket [edit]
[-] dnf-system-upgrade.service [edit]
[-] imunify-antivirus.service [edit]
[-] default.target [edit]
[-] systemd-coredump@.service [edit]
[-] systemd-vconsole-setup.service [edit]
[-] wp-toolkit-scheduled-tasks.service [edit]
[-] initrd-cleanup.service [edit]
[-] systemd-timedated.service [edit]
[-] sys-kernel-debug.mount [edit]
[-] mdadm-last-resort@.timer [edit]
[-] mlocate-updatedb.timer [edit]
[-] rpc-gssd.service [edit]
[+] poweroff.target.wants
[-] systemd-fsck@.service [edit]
[-] initrd.target [edit]
[-] dnf-makecache.timer [edit]
[-] iprupdate.service [edit]
[-] sssd-ssh.socket [edit]
[-] rpc-statd.service [edit]
[+] graphical.target.wants
[-] systemd-growfs@.service [edit]
[-] systemd-random-seed.service [edit]
[-] imunify-agent-proxy.service [edit]
[-] remote-fs-pre.target [edit]
[-] raid-check.timer [edit]
[-] proc-sys-fs-binfmt_misc.automount [edit]
[-] systemd-reboot.service [edit]
[-] kmod-static-nodes.service [edit]
[-] integritysetup-pre.target [edit]
[-] atd.service [edit]
[-] systemd-ask-password-console.service [edit]
[-] microcode.service [edit]
[-] poweroff.target [edit]
[-] flatpak-system-helper.service [edit]
[-] systemd-ask-password-plymouth.path [edit]
[-] systemd-repart.service [edit]
[-] mdmonitor-oneshot.service [edit]
[-] systemd-hybrid-sleep.service [edit]
[-] remote-veritysetup.target [edit]
[-] initrd-udevadm-cleanup-db.service [edit]
[-] sysinit.target [edit]
[-] runlevel1.target [edit]
[-] tuned.service [edit]
[-] imunify-agent-proxy.socket [edit]
[-] selinux-autorelabel-mark.service [edit]
[-] ea-php84-php-fpm.service [edit]
[-] fstrim.timer [edit]
[-] systemd-udevd-kernel.socket [edit]
[-] remote-fs.target [edit]
[-] system-systemd\x2dcryptsetup.slice [edit]
[-] wp-toolkit-background-tasks.service [edit]
[-] smartd.service [edit]
[-] systemd-logind.service [edit]
[-] systemd-remount-fs.service [edit]
[-] systemd-journal-flush.service [edit]
[-] systemd-tmpfiles-setup.service [edit]
[-] system-update-pre.target [edit]
[-] NetworkManager-wait-online.service [edit]
[-] systemd-backlight@.service [edit]
[-] sssd-nss.service [edit]
[+] syslog.target.wants
[-] iscsid.service [edit]
[-] nfs-server.service [edit]
[-] iscsid.socket [edit]
[-] nvmf-connect-nbft.service [edit]
[-] sysstat-collect.service [edit]
[-] systemd-update-utmp.service [edit]
[-] sssd-pac.service [edit]
[-] aibolit-resident.service [edit]
[-] sssd-autofs.socket [edit]
[-] systemd-sysupdate-reboot.timer [edit]
[-] getty@.service [edit]
[-] veritysetup.target [edit]
[-] fprintd.service [edit]
[-] systemd-volatile-root.service [edit]
[-] dracut-shutdown.service [edit]
[-] rpcbind.service [edit]
[-] systemd-user-sessions.service [edit]
[-] lvm-devices-import.path [edit]
[-] garb.service [edit]
[-] sysstat-collect.timer [edit]
[-] arp-ethers.service [edit]
[-] systemd-update-done.service [edit]
[+] systemd-hostnamed.service.d
[-] slices.target [edit]
[+] systemd-udev-trigger.service.d
[-] lshttpd.service [edit]
[+] runlevel3.target.wants
[-] selinux-autorelabel.target [edit]
[-] time-sync.target [edit]
[-] umount.target [edit]
[+] user-.slice.d
[-] mariadb@.service [edit]
[-] selinux-autorelabel.service [edit]
[-] nfs-idmapd.service [edit]
[-] systemd-pcrfs@.service [edit]
[-] ctrl-alt-del.target [edit]
[+] sockets.target.wants
[-] nfsdcld.service [edit]
[-] systemd-rfkill.service [edit]
[-] dbus.socket [edit]
[+] timers.target.wants
[-] dbus-org.freedesktop.timedate1.service [edit]
[-] sysstat-summary.service [edit]
[-] user-runtime-dir@.service [edit]
[-] emergency.target [edit]
[-] lvm2-lvmpolld.socket [edit]
[-] lvm-devices-import.service [edit]
[-] rpc_pipefs.target [edit]
[-] systemd-hibernate-resume@.service [edit]
[-] dbus-broker.service [edit]
[+] multi-user.target.wants
[-] systemd-pcrphase-sysinit.service [edit]
[-] import-state.service [edit]
[-] dm-event.socket [edit]
[-] cryptsetup.target [edit]
[-] iprdump.service [edit]
[-] systemd-pcrphase-initrd.service [edit]
[-] httpd.service.ls_bak_bak [edit]
[-] pdns.service [edit]
[-] logrotate.service [edit]
[-] network-online.target [edit]
[-] exit.target [edit]
[-] grub-boot-indeterminate.service [edit]
[-] irqbalance.service [edit]
[-] ldconfig.service [edit]
[-] sleep.target [edit]
[+] user@.service.d
[-] cryptsetup-pre.target [edit]
[-] canberra-system-shutdown.service [edit]
[-] man-db-restart-cache-update.service [edit]
[-] shutdown.target [edit]
[-] rsyslog.service [edit]
[-] remote-cryptsetup.target [edit]
[-] geoclue.service [edit]
[-] iscsi-onboot.service [edit]
[-] systemd-sysupdate-reboot.service [edit]
[-] canberra-system-bootup.service [edit]
[-] systemd-sysupdate.timer [edit]
[-] proc-sys-fs-binfmt_misc.mount [edit]
[-] bluetooth.target [edit]
[-] kpatch.service [edit]
[-] bluetooth.service [edit]
[+] kexec.target.wants
[-] lvm2-lvmpolld.service [edit]
[-] systemd-localed.service [edit]
[-] paths.target [edit]
[-] selinux-check-proper-disable.service [edit]
[-] systemd-boot-random-seed.service [edit]
[-] logrotate.timer [edit]
[-] sssd-ssh.service [edit]
[-] dbus-org.freedesktop.hostname1.service [edit]
[-] quotaon.service [edit]
[-] iscsiuio.socket [edit]
[+] remote-fs.target.wants
[-] systemd-sysupdate.service [edit]
[-] systemd-bless-boot.service [edit]
[-] getty.target [edit]
[-] dev-mqueue.mount [edit]
[-] sw-engine.service [edit]
[-] runlevel0.target [edit]
[-] sshd-keygen@.service [edit]
[-] chronyd.service [edit]
[-] initrd-parse-etc.service [edit]
[-] nftables.service [edit]
[-] ea-php82-php-fpm.service [edit]
[-] reboot.target [edit]
[-] systemd-ask-password-wall.service [edit]
[-] iscsi-init.service [edit]
[-] mdcheck_start.timer [edit]
[-] systemd-network-generator.service [edit]
[-] systemd-journal-catalog-update.service [edit]
[-] nscd.service [edit]
[-] systemd-journald-dev-log.socket [edit]
[-] factory-reset.target [edit]
[-] mariadb.service [edit]
[-] blockdev@.target [edit]
[+] initrd.target.wants
[-] systemd-poweroff.service [edit]
[-] htcacheclean.service [edit]
[-] chrony-wait.service [edit]
[-] modprobe@.service [edit]
[-] local-fs.target [edit]
[-] emergency.service [edit]
[-] mdadm-last-resort@.service [edit]
[-] initrd-usr-fs.target [edit]
[-] systemd-sysext.service [edit]
[-] sssd-sudo.service [edit]
[-] systemd-boot-check-no-failures.service [edit]
[-] final.target [edit]
[-] ledmon.service [edit]
[-] systemd-pstore.service [edit]
[+] basic.target.wants
[-] httpd.service [edit]
[-] sssd-kcm.service [edit]
[-] low-memory-monitor.service [edit]
[-] plymouth-start.service [edit]
[-] man-db-cache-update.service [edit]
[-] systemd-initctl.service [edit]