festival.edmaven.com:80

Linux b747.shapiroconsult.com 3.10.0-1160.119.1.vz7.224.4 #1 SMP Mon Sep 30 15:36:27 MSK 2024 x86_64
Apache
173.231.212.80

File Name : mysqld.service

# 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.2.44 database server
Documentation=man:mysqld(8)
Documentation=https://mariadb.com/kb/en/library/systemd/
After=network.target

[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 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=`cd /usr/bin/..; /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
# Note: we set --basedir to prevent probes that might trigger SELinux alarms,
# per bug https://bugzilla.redhat.com/show_bug.cgi?id=547485
ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --basedir=/usr $_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 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
# 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

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

# crash-script equalivent
# FailureAction=

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	0755	2026-08-06 03:51:19
..	dir	-	root/root	0755	2024-07-03 03:51:30
basic.target.wants	dir	-	root/root	0755	2016-09-20 04:41:35
default.target.wants	dir	-	root/root	0755	2016-09-20 04:41:35
exim4-base.timer.d	dir	-	root/root	0755	2022-06-29 11:48:10
getty.target.wants	dir	-	root/root	0755	2026-04-08 01:27:02
local-fs.target.wants	dir	-	root/root	0755	2016-10-20 04:38:45
logrotate.timer.d	dir	-	root/root	0755	2022-06-29 11:48:10
man-db.timer.d	dir	-	root/root	0755	2022-06-29 11:48:10
mariadb.service.d	dir	-	root/root	0755	2018-06-21 07:52:10
multi-user.target.wants	dir	-	root/root	0755	2026-03-23 09:04:39
mysql.service.d	dir	-	root/root	0755	2018-05-08 07:18:43
named.service.d	dir	-	root/root	0755	2016-10-20 05:03:27
nscd.service.d	dir	-	root/root	0755	2020-06-03 03:52:53
redis-sentinel.service.d	dir	-	root/root	0755	2023-06-12 08:16:28
redis.service.d	dir	-	root/root	0755	2023-06-12 08:16:28
remote-fs.target.wants	dir	-	root/root	0755	2023-04-12 03:51:15
sockets.target.wants	dir	-	root/root	0755	2016-11-29 05:17:25
sysinit.target.wants	dir	-	root/root	0755	2018-06-21 07:52:10
system-update.target.wants	dir	-	root/root	0755	2016-09-20 04:41:24
apache_php_fpm.service	text/plain	444 B	root/root	0644	2020-02-27 04:55:30
cpanalyticsd.service	text/plain	617 B	root/root	0644	2019-11-07 05:08:52
cpanel.service	text/plain	716 B	root/root	0644	2022-03-31 03:53:16
cpanel_php_fpm.service	text/plain	625 B	root/root	0644	2021-03-09 04:52:37
cpanellogd.service	text/plain	273 B	root/root	0644	2020-06-03 03:52:52
cpanelquotaonboot.service	text/plain	324 B	root/root	0644	2022-03-31 03:53:16
cpcleartaskqueue.service	text/plain	462 B	root/root	0644	2021-05-05 12:51:32
cpdavd.service	text/plain	415 B	root/root	0644	2021-03-09 04:52:37
cpgreylistd.service	text/plain	595 B	root/root	0644	2021-05-15 03:52:56
cphulkd.service	text/plain	495 B	root/root	0644	2020-06-09 04:25:02
cpipv6.service	text/plain	548 B	root/root	0644	2017-11-27 09:10:08
dnsadmin.service	text/plain	416 B	root/root	0644	2021-03-09 04:52:37
dovecot.service	text/plain	362 B	root/root	0644	2026-08-03 04:03:17
exim.service	text/plain	427 B	root/root	0644	2026-07-24 08:35:13
fastmail.service	text/plain	316 B	root/root	0644	2018-05-08 07:17:40
imh-sys-snap.service	text/plain	335 B	root/root	0644	2024-07-09 09:52:24
ipaliases.service	text/plain	654 B	root/root	0644	2019-11-13 04:53:53
mailman.service	text/plain	315 B	root/root	0644	2025-09-29 05:17:47
mysql.service	text/plain	5.38 KB	root/root	0644	2022-05-18 12:40:59
mysqld.service	text/plain	5.38 KB	root/root	0644	2022-05-18 12:40:59
nginx.service	text/plain	481 B	root/root	0644	2026-06-09 02:14:58
p0f.service	text/plain	398 B	root/root	0644	2022-06-17 06:06:30
pure-authd.service	text/plain	282 B	root/root	0644	2024-10-30 12:41:43
pure-ftpd.service	text/plain	312 B	root/root	0644	2024-10-30 12:41:43
queueprocd.service	text/plain	376 B	root/root	0644	2021-03-09 04:52:37
ror	text/x-shellscript	415 B	root/root	0755	2026-08-06 03:52:13
smtpmailgidonly.service	text/plain	420 B	root/root	0644	2018-05-08 07:16:19
spamd.service	text/plain	379 B	root/root	0444	2022-07-27 05:07:06
tailwatchd.service	text/plain	491 B	root/root	0644	2021-03-09 04:52:37