#!/bin/bash
 
DER_NAME="$(hostname -s)"
TEXTFILE_DIR="/prometheus"
VERBINDUNGEN="verbindungen"
V_STATUS="/var/tmp/status"
JETZT="$(date +'%H-%M')"

#==============================================================================#

GERAET="$(/root/bin/dev_-_var_lib_mysql.sh)"
if [ ! -e "${GERAET}" ] ; then
        #GERAET="vda"
        GERAET="dm-0"                           # /dev/mapper/vgmysql-lvolmysql
        #GERAET="vdb"                           # ZFS-Pool: mysql_datadir
fi

#==============================================================================#
 
mkdir -p ${TEXTFILE_DIR}/
mkdir -p ${V_STATUS}/
 
(
MESSZEITPUNKT="$(date +'%s')"
echo "Messzeitpunkt ${MESSZEITPUNKT}"
echo "Der_Name ${DER_NAME}"
 
#------------------------------------------------------------------------------#
# DEV

AUSGABE="$(iostat -md ${GERAET} | egrep -v '^$' | tail -n2)"

SPALTEN="$(echo "${AUSGABE}" | tail -n1 | wc -w)"
for i in $(seq 2 ${SPALTEN})
do
	echo "${GERAET}_$(echo "${AUSGABE}" | awk -v spalte="${i}" '{print $spalte}' | tr -s '\n' ' ' | sed 's|[/]|_je_|g;s/[,]/./g;s/[ ]*$//')"
done

#------------------------------------------------------------------------------#
# ZFS
 
DIE_ZPOOLS="$(zpool list 2>/dev/null | grep -Ev '^NAME' | awk '{print $1}')"
ZAHL_ZPOOLS="$(echo "${DIE_ZPOOLS}" | wc -l)"
if [ 0 -lt "${ZAHL_ZPOOLS}" ] ; then
	for DER_ZPOOL in ${DIE_ZPOOLS}
	do
		zpool iostat -p ${DER_ZPOOL} | grep -E '^mysql_datadir' | while read POOL CAPACITY_ALLOC CAPACITY_FREE OPERATIONS_READ OPERATIONS_WRITE BANDWIDTH_READ BANDWIDTH_WRITE
		do
			echo "${DER_ZPOOL}_Capacity_Alloc ${CAPACITY_ALLOC}"
			echo "${DER_ZPOOL}_Capacity_Free ${CAPACITY_FREE}"
			echo "${DER_ZPOOL}_Operations_Read ${OPERATIONS_READ}"
			echo "${DER_ZPOOL}_Operations_Write ${OPERATIONS_WRITE}"
			echo "${DER_ZPOOL}_Bandwidth_Read ${BANDWIDTH_READ}"
			echo "${DER_ZPOOL}_Bandwidth_Write ${BANDWIDTH_WRITE}"
		done
	done
fi
 
#------------------------------------------------------------------------------#
 
MYSQL="mysql -S /var/run/mysqld/mysqld.sock"
 
# DB-Version
echo "SHOW VARIABLES LIKE 'version';" | ${MYSQL} -Ns 2>/dev/null
echo "SHOW VARIABLES LIKE 'version_comment';" | ${MYSQL} -Ns 2>/dev/null
 
# Max. Anzahl an erlaubten Verbindungen
echo "SHOW VARIABLES WHERE VARIABLE_NAME IN ('max_connections');" | ${MYSQL} -Ns 2>/dev/null
 
# Status der Verbindungen
echo "
SHOW STATUS
        WHERE variable_name IN (
                'Aborted_connects',
                'Connections',
                'Max_used_connections',
                'Max_used_connections_time',
                'Performance_schema_session_connect_attrs_longest_seen',
                'Threads_connected'
        );
" | ${MYSQL} -Ns 2>/dev/null | sed 's/[[:space:]][[:space:]]*/ /'
) | while read ZEILE
do
        echo "${ZEILE}"
        echo
done | tee ${V_STATUS}/status_${JETZT} > ${TEXTFILE_DIR}/${VERBINDUNGEN}.prom.$$
mv ${TEXTFILE_DIR}/${VERBINDUNGEN}.prom.$$ ${TEXTFILE_DIR}/${VERBINDUNGEN}.prom
 
#==============================================================================#