LOG_DIR=”/opengauss/log/health_check”
mkdir -p $LOG_DIR
LOG_FILE=”$LOG_DIR/health_check_$(date ‘+%Y%m%d’).log”

log() {
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] $1” | tee -a $LOG_FILE
}

check_system() {
log “=== 系统检查 ===”
log “系统负载: $(uptime | awk ‘{print $10 $11 $12}’)”
cpu_usage=$(top -bn1 | grep “Cpu(s)” | sed “s/.*, *\([0-9.]*\)%* id.*/\1/” | awk ‘{print 100 – $1}’)
log “CPU使用率: ${cpu_usage}%”
mem_usage=$(free -m | awk ‘/Mem:/ {print $3/$2 * 100.0}’)
log “内存使用率: ${mem_usage}%”
disk_usage=$(df -h | grep -v tmpfs | grep -v devtmpfs)
log “磁盘使用情况:\n$disk_usage”
network_status=$(netstat -tuln | grep 5432)
log “网络状态:\n$network_status”
}更多视频教程www.fgedu.net.cn

check_database() {
log “=== 数据库检查 ===”
db_status=$(gs_ctl status -D /opengauss/fgdata | grep “server is running”)
log “数据库状态: $db_status”

connections=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c “SELECT count(*) FROM pg_stat_activity;
“)
log “数据库连接数: $connections”

tablespaces=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c ”
SELECT
spcname AS tablespace,
pg_size_pretty(pg_tablespace_size(spcname::regnamespace)) AS size,
round((pg_tablespace_size(spcname::regnamespace) / (1024^3)::numeric), 2) AS size_gb
FROM pg_tablespace
WHERE spcname NOT LIKE ‘pg_%’;
“)
log “表空间使用情况:\n$tablespaces”

wal_status=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c “SELECT pg_wal_lsn_diff(pg_current_wal_lsn(), ‘0/0’) / (1024^2)::numeric AS wal_size_mb;
“)
log “WAL日志大小: ${wal_status} MB”
}

check_performance() {
log “=== 性能检查 ===”

slow_sql=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c ”
SELECT pid, usename, now() – query_start AS duration, query
FROM pg_stat_activity WHERE state = ‘active’ AND now() – query_start > interval ‘1 second’
ORDER BY duration DESC LIMIT 5;”)
log “慢SQL:\n$slow_sql”

lock_wait=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c ”
SELECT pid, usename, relation::regclass, mode, granted
FROM pg_locks WHERE NOT granted;”)
log “锁等待:\n$lock_wait”

long_transaction=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c ”
SELECT pid, usename, now() – xact_start AS duration
FROM pg_stat_activity WHERE xact_start IS NOT NULL AND now() – xact_start > interval ‘5 minutes’;”)更多学习教程公众号风哥教程itpux_com
log “长事务:\n$long_transaction”
}

check_security() {
log “=== 安全检查 ===”

user_permissions=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c ”
SELECT usename, usesuper, usecreatedb, usecatupd, passwd FROM pg_user;
“)
log “用户权限:\n$user_permissions”

audit_log=$(ls -la /opengauss/fgdata/pg_log/audit* 2>/dev/null || echo “无审计日志”)
log “审计日志:\n$audit_log”
}

generate_report() {
log “=== 健康检查报告 ===”
log “检查时间: $(date ‘+%Y-%m-%d %H:%M:%S’)”
log “检查结果: 完成”
log “详细信息请查看日志文件: $LOG_FILE”
}

main() {
log “开始健康检查…”
check_system
check_database
check_performance
check_security
generate_report
log “健康检查完成”
}from DB视频:www.itpux.com

main

3.2 健康检查配置

配置健康检查的执行计划：

$(df -h | grep -v tmpfs | grep -v devtmpfs)

$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c "SELECT spcname AS tablespace, pg_size_pretty(pg_tablespace_size(spcname::regnamespace)) AS size FROM pg_tablespace WHERE spcname NOT LIKE 'pg_%'; 
")

$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c "SELECT pid, usename, now() - query_start AS duration, query FROM pg_stat_activity WHERE state = 'active' AND now() - query_start > interval '1 second' ORDER BY duration DESC LIMIT 5; 
")

$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c "SELECT pid, usename, relation::regclass, mode, granted FROM pg_locks WHERE NOT granted; 
")

$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c "SELECT pid, usename, now() - xact_start AS duration FROM pg_stat_activity WHERE xact_start IS NOT NULL AND now() - xact_start > interval '5 minutes'; 
")