ansible-roles/mysql/files/save_mysql_processlist.sh
Jérémy Lecour 71ed4c4c8c
All checks were successful
Ansible Lint |Total|New|Outstanding|Fixed|Trend |:-:|:-:|:-:|:-:|:-: |2639|10|2629|7|:-1: Reference build: <a href="https://jenkins.evolix.org/job/gitea/job/ansible-roles/job/unstable/395//ansiblelint">Evolix » ansible-roles » unstable #395</a>
gitea/ansible-roles/pipeline/head This commit looks good
shell syntax
2023-11-20 19:03:50 +01:00

26 lines
387 B
Bash

#!/bin/sh
set -e
processlist() {
mysqladmin --verbose --vertical processlist
}
DIR="/var/log/mysql-processlist"
TS=$(date +%Y%m%d%H%M%S)
FILE="${DIR}/${TS}"
if [ ! -d "${DIR}" ]; then
mkdir -p "${DIR}"
chown root:adm "${DIR}"
chmod 750 "${DIR}"
fi
processlist > "${FILE}"
chmod 640 "${FILE}"
chown root:adm "${FILE}"
find "${DIR}" -type f -mtime +1 -delete
exit 0