Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- freebsd:freebsd_-_monitoring [2023-02-18 14:40:46] – manfred
+++ freebsd:freebsd_-_monitoring [2026-01-16 11:42:00] (aktuell) – manfred
@@ Zeile 32: / Zeile 32: @@
         * **[[https://grafana.com/dashboards/4260|Node Exporter FreeBSD (Grafana dashboard ID 4260)]]**
           * //[[https://gist.github.com/hbokh/d07fbbf8c2411efd1b4e0064d4b2ed93|Prometheus 2.1.0 and a FreeBSD node_exporter - Grafana dashboard ID 4260]]//
+===== Prometheus =====
+<file bash /root/bin/dev_-_var_lib_mysql.sh>
+#!/bin/bash
+# > df -T /var/lib/mysql
+# Filesystem                    Type  1K-blocks       Used  Available Use% Mounted on
+# /dev/mapper/vgmysql-lvolmysql ext4 4226435512 2283978596 1749651528  57% /var/lib/mysql
+# > df -T /var/lib/mysql
+# Filesystem     Type 1K-blocks     Used Available Use% Mounted on
+# mysql_datadir  zfs  142989952 22156976 120832976  16% /var/lib/mysql
+VAR_LIB_MYSQL="$(df -T /var/lib/mysql | grep -Ev '^Filesystem' | awk '{print $1,$2}')"
+#echo "VAR_LIB_MYSQL=${VAR_LIB_MYSQL}"
+DEV_NAME="$(echo "${VAR_LIB_MYSQL}" | awk '{print $1}')"
+FS_NAME="$(echo "${VAR_LIB_MYSQL}" | awk '{print $2}')"
+if [ zfs = "${FS_NAME}" ] ; then
+        #zpool status ${DEV_NAME} | sed -ne '/config:/,/errors:/p' | grep -Ev 'config:|NAME[[:space:]]+STATE|errors:|^[[:space:]]*$' | tail -n1 | awk '{print $1}'
+        #zpool iostat -v ${DEV_NAME} | sed -ne '/-------------/,/-------------/p' | grep -Fv -- '-------------' | grep -Fv ${DEV_NAME} | awk '{print $1}'
+        ZPOOL_IOSTAT="$(zpool iostat -v ${DEV_NAME} | sed -ne '/-------------/,/-------------/p' | grep -Fv -- '-------------' | grep -Fv ${DEV_NAME})"
+        DAS_DEV="$(echo "${ZPOOL_IOSTAT}" | awk '{print $1}')"
+else
+        DAS_DEV="$(readlink -f ${DEV_NAME})"
+fi
+if [ -e "${DAS_DEV}" ] ; then
+        #ls -lha ${DAS_DEV}
+	echo ${DAS_DEV}
+else
+        #ls -lha /dev/${DAS_DEV}
+	echo /dev/${DAS_DEV}
+fi
+</file>
+<file bash /root/bin/Connections-Exporter.sh>
+#!/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
+#==============================================================================#
+</file>
+<file bash /etc/cron.d/Connections-Exporter>
+MAILTO=''
+* * * * * root /root/bin/Connections-Exporter.sh
+</file>