# 编写监控脚本

cat > /tdsql/app/scripts/monitor.sh << 'EOF'

#!/bin/bash

# monitor.sh

# from:www.itpux.com.qq113257174.wx:itpux-com

# web: http://www.fgedu.net.cn

# 定义变量

LOG_FILE=”/tdsql/logs/monitor.log”
MYSQL_USER=”root”
MYSQL_PASS=”Fgedu123!”
ALERT_EMAIL=”admin@fgedu.net.cn”

# 记录日志
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 开始执行监控任务” >> $LOG_FILE

# 检查数据库连接
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 检查数据库连接” >> $LOG_FILE
mysql -u $MYSQL_USER -p$MYSQL_PASS -e “SELECT 1;” > /dev/null 2>&1
if [ $? -ne 0 ]; then
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 数据库连接失败” >> $LOG_FILE
echo “数据库连接失败，请检查数据库状态” | mail -s “TDSQL监控告警” $ALERT_EMAIL
else
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 数据库连接正常” >> $LOG_FILE
fi

# 检查慢查询
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 检查慢查询” >> $LOG_FILE
SLOW_QUERIES=$(mysql -u $MYSQL_USER -p$MYSQL_PASS -e “SHOW GLOBAL STATUS LIKE ‘Slow_queries’;” | awk ‘NR==2 {print $2}’)
if [ $SLOW_QUERIES -gt 100 ]; then
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 慢查询数量过多: $SLOW_QUERIES” >> $LOG_FILE
echo “慢查询数量过多: $SLOW_QUERIES，请检查慢查询日志” | mail -s “TDSQL监控告警” $ALERT_EMAIL
else
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 慢查询数量正常: $SLOW_QUERIES” >> $LOG_FILE
fi

# 检查连接数
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 检查连接数” >> $LOG_FILE
CONNECTIONS=$(mysql -u $MYSQL_USER -p$MYSQL_PASS -e “SHOW GLOBAL STATUS LIKE ‘Threads_connected’;” | awk ‘NR==2 {print $2}’)
MAX_CONNECTIONS=$(mysql -u $MYSQL_USER -p$MYSQL_PASS -e “SHOW VARIABLES LIKE ‘max_connections’;” | awk ‘NR==2 {print $2}’)
CONNECTIONS_PERCENT=$((CONNECTIONS * 100 / MAX_CONNECTIONS))
if [ $CONNECTIONS_PERCENT -gt 80 ]; then
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 连接数过高: $CONNECTIONS/$MAX_CONNECTIONS ($CONNECTIONS_PERCENT%)” >> $LOG_FILE
echo “连接数过高: $CONNECTIONS/$MAX_CONNECTIONS ($CONNECTIONS_PERCENT%)，请检查连接情况” | mail -s “TDSQL监控告警” $ALERT_EMAIL
else
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 连接数正常: $CONNECTIONS/$MAX_CONNECTIONS ($CONNECTIONS_PERCENT%)” >> $LOG_FILE
fi

# 记录完成日志
echo “[$(date +’%Y-%m-%d %H:%M:%S’)] 监控任务执行完成” >> $LOG_FILE
echo “—————————————-” >> $LOG_FILE
EOF