# 创建性能异常检测脚本
cat > /kingbase/scripts/performance_anomaly_detector.sh << 'EOF'
#!/bin/bash
# performance_anomaly_detector.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`
# 读取基线数据
source /kingbase/performance_data/latest_baseline.txt
# 收集当前性能数据
current_cpu=$(top -b -n 1 | grep ‘Cpu(s)’ | awk ‘{print $2 + $4}’)
current_mem=$(free -m | grep Mem | awk ‘{print $3/$2 * 100}’)
current_io=$(iostat -x 1 1 | grep sda | awk ‘{print $14}’)
current_conn=$(psql -U fgedu -d fgedudb -c “SELECT count(*) FROM pg_stat_activity WHERE state = ‘active'” | grep -v count)
current_tps=$(psql -U fgedu -d fgedudb -c “SELECT sum(xact_commit + xact_rollback) FROM pg_stat_database WHERE datname = ‘fgedudb'” | grep -v sum)
# 检测异常
echo “========== 性能异常检测报告 ==========”
echo “当前时间: $(date ‘+%Y-%m-%d %H:%M:%S’)”
if (( $(echo “$current_cpu > 30” | bc -l) )); then
echo “警告: CPU使用率异常，当前值: $current_cpu%，基线值: 15.78%”
else
echo “正常: CPU使用率，当前值: $current_cpu%，基线值: 15.78%”
fi
if (( $(echo “$current_mem > 70” | bc -l) )); then
echo “警告: 内存使用率异常，当前值: $current_mem%，基线值: 45.58%”
else
echo “正常: 内存使用率，当前值: $current_mem%，基线值: 45.58%”
fi
if (( $(echo “$current_io > 20” | bc -l) )); then
echo “警告: 磁盘I/O使用率异常，当前值: $current_io%，基线值: 8.44%”
else
echo “正常: 磁盘I/O使用率，当前值: $current_io%，基线值: 8.44%”
fi
if (( $current_conn > 50 )); then
echo “警告: 活跃连接数异常，当前值: $current_conn，基线值: 25.4”
else
echo “正常: 活跃连接数，当前值: $current_conn，基线值: 25.4”
fi
if (( $current_tps > 300 )); then
echo “警告: TPS异常，当前值: $current_tps，基线值: 125.6”
else
echo “正常: TPS，当前值: $current_tps，基线值: 125.6”
fi
EOF