SM0 She11

Full Path (server): /usr/lib/systemd/system

📄 -.slice [E] [D]
📄 amavisd.service [E] [D]
📄 arp-ethers.service [E] [D]
📄 atd.service [E] [D]
📄 auditd.service [E] [D]
📄 autovt@.service [E] [D]
📄 basic.target [E] [D]
📁 basic.target.wants Open [D]
📄 blk-availability.service [E] [D]
📄 bluetooth.target [E] [D]
📄 brandbot.path [E] [D]
📄 brandbot.service [E] [D]
📄 chrony-dnssrv@.service [E] [D]
📄 chrony-dnssrv@.timer [E] [D]
📄 chrony-wait.service [E] [D]
📄 chronyd.service [E] [D]
📄 clamav-clamonacc.service [E] [D]
📄 clamav-freshclam.service [E] [D]
📄 clamd-scan.service [E] [D]
📄 clamd.service [E] [D]
📄 clamonacc.service [E] [D]
📄 cloud-config.service [E] [D]
📄 cloud-config.target [E] [D]
📄 cloud-final.service [E] [D]
📄 cloud-init-local.service [E] [D]
📄 cloud-init.service [E] [D]
📄 cloud-init.target [E] [D]
📄 console-getty.service [E] [D]
📄 console-shell.service [E] [D]
📄 container-getty@.service [E] [D]
📄 cpupower.service [E] [D]
📄 crond.service [E] [D]
📄 cryptsetup-pre.target [E] [D]
📄 cryptsetup.target [E] [D]
📄 csf.service [E] [D]
📄 ctrl-alt-del.target [E] [D]
📄 cwp-phpfpm.service [E] [D]
📄 cwpsrv-phpfpm.service [E] [D]
📄 cwpsrv.service [E] [D]
📄 dbus-org.freedesktop.hostname1.service [E] [D]
📄 dbus-org.freedesktop.import1.service [E] [D]
📄 dbus-org.freedesktop.locale1.service [E] [D]
📄 dbus-org.freedesktop.login1.service [E] [D]
📄 dbus-org.freedesktop.machine1.service [E] [D]
📄 dbus-org.freedesktop.timedate1.service [E] [D]
📄 dbus.service [E] [D]
📄 dbus.socket [E] [D]
📁 dbus.target.wants Open [D]
📄 debug-shell.service [E] [D]
📄 default.target [E] [D]
📁 default.target.wants Open [D]
📄 defunct.dat [E] [D]
📄 defunct.service [E] [D]
📄 dev-hugepages.mount [E] [D]
📄 dev-mqueue.mount [E] [D]
📄 dovecot.service [E] [D]
📄 dovecot.socket [E] [D]
📄 dracut-cmdline.service [E] [D]
📄 dracut-initqueue.service [E] [D]
📄 dracut-mount.service [E] [D]
📄 dracut-pre-mount.service [E] [D]
📄 dracut-pre-pivot.service [E] [D]
📄 dracut-pre-trigger.service [E] [D]
📄 dracut-pre-udev.service [E] [D]
📄 dracut-shutdown.service [E] [D]
📄 emergency.service [E] [D]
📄 emergency.target [E] [D]
📄 final.target [E] [D]
📄 fstrim.service [E] [D]
📄 fstrim.timer [E] [D]
📄 garb.service [E] [D]
📄 getty-pre.target [E] [D]
📄 getty.target [E] [D]
📄 getty@.service [E] [D]
📄 graphical.target [E] [D]
📁 graphical.target.wants Open [D]
📄 halt-local.service [E] [D]
📄 halt.target [E] [D]
📄 hibernate.target [E] [D]
📄 httpd.service [E] [D]
📄 hybrid-sleep.target [E] [D]
📄 initrd-cleanup.service [E] [D]
📄 initrd-fs.target [E] [D]
📄 initrd-parse-etc.service [E] [D]
📄 initrd-root-fs.target [E] [D]
📄 initrd-switch-root.service [E] [D]
📄 initrd-switch-root.target [E] [D]
📄 initrd-udevadm-cleanup-db.service [E] [D]
📄 initrd.target [E] [D]
📁 initrd.target.wants Open [D]
📄 irqbalance.service [E] [D]
📄 kdump.service [E] [D]
📄 kexec.target [E] [D]
📄 kmod-static-nodes.service [E] [D]
📄 lfd.service [E] [D]
📄 local-fs-pre.target [E] [D]
📄 local-fs.target [E] [D]
📁 local-fs.target.wants Open [D]
📄 machine.slice [E] [D]
📄 machines.target [E] [D]
📄 mariadb.service [E] [D]
📄 mariadb@.service [E] [D]
📁 mariadb@bootstrap.service.d Open [D]
📄 messagebus.service [E] [D]
📄 microcode.service [E] [D]
📄 multi-user.target [E] [D]
📁 multi-user.target.wants Open [D]
📄 named-setup-rndc.service [E] [D]
📄 named.service [E] [D]
📄 network-online.target [E] [D]
📄 network-pre.target [E] [D]
📄 network.target [E] [D]
📄 nfs-rquotad.service [E] [D]
📁 nginx.service.d Open [D]
📄 nss-lookup.target [E] [D]
📄 nss-user-lookup.target [E] [D]
📄 paths.target [E] [D]
📄 php-fpm56.service [E] [D]
📄 polkit.service [E] [D]
📄 portreserve.service [E] [D]
📄 postfix.service [E] [D]
📄 poweroff.target [E] [D]
📁 poweroff.target.wants Open [D]
📄 printer.target [E] [D]
📄 proc-sys-fs-binfmt_misc.automount [E] [D]
📄 proc-sys-fs-binfmt_misc.mount [E] [D]
📄 pure-ftpd.service [E] [D]
📄 qemu-guest-agent.service [E] [D]
📄 quotaon.service [E] [D]
📄 rc-local.service [E] [D]
📄 rdisc.service [E] [D]
📄 reboot.target [E] [D]
📁 reboot.target.wants Open [D]
📄 remote-cryptsetup.target [E] [D]
📄 remote-fs-pre.target [E] [D]
📄 remote-fs.target [E] [D]
📄 rescue.service [E] [D]
📄 rescue.target [E] [D]
📁 rescue.target.wants Open [D]
📄 rhel-autorelabel-mark.service [E] [D]
📄 rhel-autorelabel.service [E] [D]
📄 rhel-configure.service [E] [D]
📄 rhel-dmesg.service [E] [D]
📄 rhel-domainname.service [E] [D]
📄 rhel-import-state.service [E] [D]
📄 rhel-loadmodules.service [E] [D]
📄 rhel-readonly.service [E] [D]
📄 rpc-rquotad.service [E] [D]
📄 rpcbind.service [E] [D]
📄 rpcbind.socket [E] [D]
📄 rpcbind.target [E] [D]
📄 rsyncd.service [E] [D]
📄 rsyncd.socket [E] [D]
📄 rsyncd@.service [E] [D]
📄 rsyslog.service [E] [D]
📄 runlevel0.target [E] [D]
📄 runlevel1.target [E] [D]
📁 runlevel1.target.wants Open [D]
📄 runlevel2.target [E] [D]
📁 runlevel2.target.wants Open [D]
📄 runlevel3.target [E] [D]
📁 runlevel3.target.wants Open [D]
📄 runlevel4.target [E] [D]
📁 runlevel4.target.wants Open [D]
📄 runlevel5.target [E] [D]
📁 runlevel5.target.wants Open [D]
📄 runlevel6.target [E] [D]
📄 saslauthd.service [E] [D]
📄 selinux-policy-migrate-local-changes@.service [E] [D]
📄 serial-getty@.service [E] [D]
📄 shutdown.target [E] [D]
📁 shutdown.target.wants Open [D]
📄 sigpwr.target [E] [D]
📄 sleep.target [E] [D]
📄 slices.target [E] [D]
📄 smartcard.target [E] [D]
📄 snmpd.service [E] [D]
📄 snmptrapd.service [E] [D]
📄 sockets.target [E] [D]
📁 sockets.target.wants Open [D]
📄 sound.target [E] [D]
📄 spamassassin.service [E] [D]
📄 sshd-keygen.service [E] [D]
📄 sshd.service [E] [D]
📄 sshd.socket [E] [D]
📄 sshd@.service [E] [D]
📄 suspend.target [E] [D]
📄 svnserve.service [E] [D]
📄 swap.target [E] [D]
📄 sys-fs-fuse-connections.mount [E] [D]
📄 sys-kernel-config.mount [E] [D]
📄 sys-kernel-debug.mount [E] [D]
📄 sysinit.target [E] [D]
📁 sysinit.target.wants Open [D]
📄 syslog.socket [E] [D]
📁 syslog.target.wants Open [D]
📄 sysstat.service [E] [D]
📄 system-update.target [E] [D]
📄 system.slice [E] [D]
📄 systemd-ask-password-console.path [E] [D]
📄 systemd-ask-password-console.service [E] [D]
📄 systemd-ask-password-wall.path [E] [D]
📄 systemd-ask-password-wall.service [E] [D]
📄 systemd-backlight@.service [E] [D]
📄 systemd-binfmt.service [E] [D]
📄 systemd-bootchart.service [E] [D]
📄 systemd-firstboot.service [E] [D]
📄 systemd-fsck-root.service [E] [D]
📄 systemd-fsck@.service [E] [D]
📄 systemd-halt.service [E] [D]
📄 systemd-hibernate-resume@.service [E] [D]
📄 systemd-hibernate.service [E] [D]
📄 systemd-hostnamed.service [E] [D]
📄 systemd-hwdb-update.service [E] [D]
📄 systemd-hybrid-sleep.service [E] [D]
📄 systemd-importd.service [E] [D]
📄 systemd-initctl.service [E] [D]
📄 systemd-initctl.socket [E] [D]
📄 systemd-journal-catalog-update.service [E] [D]
📄 systemd-journal-flush.service [E] [D]
📄 systemd-journald.service [E] [D]
📄 systemd-journald.socket [E] [D]
📄 systemd-kexec.service [E] [D]
📄 systemd-localed.service [E] [D]
📄 systemd-logind.service [E] [D]
📄 systemd-machine-id-commit.service [E] [D]
📄 systemd-machined.service [E] [D]
📄 systemd-modules-load.service [E] [D]
📄 systemd-nspawn@.service [E] [D]
📄 systemd-poweroff.service [E] [D]
📄 systemd-quotacheck.service [E] [D]
📄 systemd-random-seed.service [E] [D]
📄 systemd-readahead-collect.service [E] [D]
📄 systemd-readahead-done.service [E] [D]
📄 systemd-readahead-done.timer [E] [D]
📄 systemd-readahead-drop.service [E] [D]
📄 systemd-readahead-replay.service [E] [D]
📄 systemd-reboot.service [E] [D]
📄 systemd-remount-fs.service [E] [D]
📄 systemd-rfkill@.service [E] [D]
📄 systemd-shutdownd.service [E] [D]
📄 systemd-shutdownd.socket [E] [D]
📄 systemd-suspend.service [E] [D]
📄 systemd-sysctl.service [E] [D]
📄 systemd-timedated.service [E] [D]
📄 systemd-tmpfiles-clean.service [E] [D]
📄 systemd-tmpfiles-clean.timer [E] [D]
📄 systemd-tmpfiles-setup-dev.service [E] [D]
📄 systemd-tmpfiles-setup.service [E] [D]
📄 systemd-udev-settle.service [E] [D]
📄 systemd-udev-trigger.service [E] [D]
📄 systemd-udevd-control.socket [E] [D]
📄 systemd-udevd-kernel.socket [E] [D]
📄 systemd-udevd.service [E] [D]
📄 systemd-update-done.service [E] [D]
📄 systemd-update-utmp-runlevel.service [E] [D]
📄 systemd-update-utmp.service [E] [D]
📄 systemd-user-sessions.service [E] [D]
📄 systemd-vconsole-setup.service [E] [D]
📄 tcsd.service [E] [D]
📄 teamd@.service [E] [D]
📄 time-sync.target [E] [D]
📄 timers.target [E] [D]
📁 timers.target.wants Open [D]
📄 tmp.mount [E] [D]
📄 tuned.service [E] [D]
📄 umount.target [E] [D]
📄 user.slice [E] [D]
📄 wpa_supplicant.service [E] [D]

Editing: mariadb@.service

# Multi instance version of mariadb. For if you run multiple versions at once.
# Also used for mariadb@bootstrap to tell you to use galera_new_cluster.
#
# create config file /etc/my.cnf.d/my{instancename}.cnf
#
# start as systemctl start mariadb@{instancename}.server

# 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.
#
# Thanks to:
# Daniel Black
# Erkan Yanar
# David Strauss
# and probably others
# Inspired from https://gitweb.gentoo.org/repo/gentoo.git/tree/dev-db/mysql-init-scripts/files/mysqld_at.service

[Unit]
Description=MariaDB 10.1.47 database server (multi-instance %I)
Documentation=man:mysqld(8)
Documentation=https://mariadb.com/kb/en/library/systemd/
After=network.target
After=syslog.target

ConditionPathExists=/etc/my.cnf.d/my%I.cnf

[Install]
WantedBy=multi-user.target
Alias=mysql.service
Alias=mysqld.service

[Service]

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

Type=notify

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

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

User=mysql
Group=mysql

# To allow memlock to be used as non-root user if set in configuration
CapabilityBoundingSet=CAP_IPC_LOCK

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

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

PrivateDevices=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%I environment variable.
# Do not panic if galera_recovery script is not available. (MDEV-10538)
ExecStartPre=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION%I"

ExecStartPre=/bin/sh -c "[ ! -e /usr/bin/galera_recovery ] && VAR= || \
 VAR=`cd /usr/bin/..; /usr/bin/galera_recovery --defaults-file=/etc/my.cnf.d/my%I.cnf`; [ $? -eq 0 ] \
 && systemctl set-environment _WSREP_START_POSITION%I=$VAR || exit 1"

# Alternate: (remove ConditionPathExists above)
# use [mysqld.INSTANCENAME] as sections in my.cnf
#
#ExecStartPre=/bin/sh -c "[ ! -e /usr/bin/galera_recovery ] && VAR= || \
# VAR=`cd /usr/bin/..; /usr/bin/galera_recovery --defaults-group-suffix=%I`; [ $? -eq 0 ] \
# && systemctl set-environment _WSREP_START_POSITION%I=$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

# Note: Place $MYSQLD_OPTS at the very end for its options to take precedence.

ExecStart=/usr/sbin/mysqld --defaults-file=/etc/my.cnf.d/my%I.cnf \
  $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION%I $MYSQLD_OPTS
# Alternate: (remove ConditionPathExists above)
# use [mysqld.INSTANCENAME] as sections in my.cnf
#
# ExecStart=/usr/sbin/mysqld --defaults-group-suffix=%I \
# $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION%I $MYSQLD_OPTS

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

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 below [Service] will override this file's
## settings.

# Useful options not previously available in [mysqld_safe]

# Kernels like killing mysqld 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
# if you need a longer timeout, check the KB:
# https://mariadb.com/kb/en/library/systemd/#configuring-the-systemd-service-timeout
TimeoutStartSec=900
TimeoutStopSec=900

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

# 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/mysqld......

# crash-script equalivent
# FailureAction=