You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
148 lines
3.4 KiB
148 lines
3.4 KiB
#!/bin/bash
|
|
# info: update MySQL rrd
|
|
# options: PERIOD
|
|
#
|
|
# example: v-update-sys-rrd-mysql
|
|
#
|
|
# This function is for updating mysql rrd database and graphic.
|
|
|
|
#----------------------------------------------------------#
|
|
# Variables & Functions #
|
|
#----------------------------------------------------------#
|
|
|
|
# Argument definition
|
|
period=${1-daily}
|
|
|
|
# Includes
|
|
# shellcheck source=/etc/hestiacp/hestia.conf
|
|
source /etc/hestiacp/hestia.conf
|
|
# shellcheck source=/usr/local/hestia/func/main.sh
|
|
source $HESTIA/func/main.sh
|
|
# shellcheck source=/usr/local/hestia/func/db.sh
|
|
source $HESTIA/func/db.sh
|
|
# load config file
|
|
source_conf "$HESTIA/conf/hestia.conf"
|
|
|
|
#----------------------------------------------------------#
|
|
# Action #
|
|
#----------------------------------------------------------#
|
|
|
|
# Switching on time period
|
|
case $period in
|
|
daily)
|
|
start='-1d'
|
|
end='now'
|
|
grid='MINUTE:30:HOUR:1:HOUR:4:0:%H:%M'
|
|
;;
|
|
weekly)
|
|
start='-7d'
|
|
end='now'
|
|
grid='HOUR:8:DAY:1:DAY:1:0:%a %d'
|
|
;;
|
|
monthly)
|
|
start='-1m'
|
|
end='now'
|
|
grid='WEEK:1:WEEK:1:WEEK:1:0:%b %d'
|
|
;;
|
|
yearly)
|
|
start='-1y'
|
|
end='now'
|
|
grid='MONTH:1:YEAR:1:MONTH:2:2419200:%b'
|
|
;;
|
|
*) exit "$E_RRD" ;;
|
|
esac
|
|
|
|
# Checking directory
|
|
if [ ! -d "$RRD/db" ]; then
|
|
mkdir $RRD/db
|
|
fi
|
|
|
|
# Parsing db hosts
|
|
conf="$HESTIA/conf/mysql.conf"
|
|
hosts=$(grep HOST "$conf" | awk '{print $1}' | cut -f 2 -d \')
|
|
check_row=$(echo "$hosts" | wc -l)
|
|
if [ 0 -eq "$check_row" ]; then
|
|
exit
|
|
fi
|
|
|
|
# Parsing excludes
|
|
for exclude in $(echo ${RRD_MYSQL_EXCLUDE//,/ }); do
|
|
hosts=$(echo "$hosts" | grep -vw "$exclude")
|
|
done
|
|
|
|
for host in $hosts; do
|
|
# Checking database
|
|
if [ ! -e "$RRD/db/mysql_$host.rrd" ]; then
|
|
# Adding database
|
|
rrdtool create $RRD/db/mysql_$host.rrd --step $RRD_STEP \
|
|
DS:A:COUNTER:600:U:U \
|
|
DS:S:COUNTER:600:U:U \
|
|
RRA:AVERAGE:0.5:1:600 \
|
|
RRA:AVERAGE:0.5:6:700 \
|
|
RRA:AVERAGE:0.5:24:775 \
|
|
RRA:AVERAGE:0.5:288:797 \
|
|
RRA:MAX:0.5:1:600 \
|
|
RRA:MAX:0.5:6:700 \
|
|
RRA:MAX:0.5:24:775 \
|
|
RRA:MAX:0.5:288:797
|
|
fi
|
|
|
|
if [ "$period" = 'daily' ]; then
|
|
mysql_connect "$host"
|
|
query='SHOW GLOBAL STATUS'
|
|
status=$(mysql_query "$query" 2> /dev/null)
|
|
if [ $? -ne 0 ]; then
|
|
active=0
|
|
slow=0
|
|
else
|
|
active=$(echo "$status" | grep 'Queries' | cut -f 2)
|
|
slow=$(echo "$status" | grep 'Slow_queries' | cut -f 2)
|
|
fi
|
|
|
|
# Updating rrd
|
|
rrdtool update $RRD/db/mysql_$host.rrd N:$active:$slow
|
|
fi
|
|
|
|
# Updating daily graph
|
|
rrdtool graph $RRD/db/$period-mysql_$host.png \
|
|
--imgformat PNG \
|
|
--height="150" \
|
|
--width="670" \
|
|
--start "$start" \
|
|
--end "$end" \
|
|
--vertical-label "Queries" \
|
|
--x-grid "$grid" \
|
|
-c "BACK#ffffff" \
|
|
-c "SHADEA#ffffff" \
|
|
-c "SHADEB#ffffff" \
|
|
-c "FONT#555555" \
|
|
-c "CANVAS#302c2d" \
|
|
-c "GRID#666666" \
|
|
-c "MGRID#AAAAAA" \
|
|
-c "FRAME#302c2d" \
|
|
-c "ARROW#FFFFFF" \
|
|
DEF:a=$RRD/db/mysql_$host.rrd:A:AVERAGE \
|
|
DEF:s=$RRD/db/mysql_$host.rrd:S:AVERAGE \
|
|
COMMENT:'\r' \
|
|
LINE1:a#fefda0:"Queries" \
|
|
GPRINT:a:'LAST: Current\:''%8.0lf' \
|
|
GPRINT:a:'MIN: Min\:''%8.0lf' \
|
|
GPRINT:a:'MAX: Max\:''%8.0lf\j' \
|
|
AREA:s#f57900:"Slow " \
|
|
GPRINT:s:'LAST:Current\:''%8.0lf' \
|
|
GPRINT:s:'MIN:Min\:''%8.0lf' \
|
|
GPRINT:s:'MAX:Max\:''%8.0lf\j' &> /dev/null
|
|
result=$?
|
|
|
|
if [ "$result" -ne 0 ]; then
|
|
exit "$E_RRD"
|
|
fi
|
|
|
|
done
|
|
|
|
#----------------------------------------------------------#
|
|
# Hestia #
|
|
#----------------------------------------------------------#
|
|
|
|
exit
|