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

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

check_cpu_usage() {
log “=== CPU使用情况检查 ===”

# 系统负载
loadavg=$(uptime | awk ‘{print $10 $11 $12}’)
log “系统负载: $loadavg”

# CPU使用率
cpu_usage=$(top -bn1 | grep “Cpu(s)” | sed “s/.*, *\([0-9.]*\)%* id.*/\1/” | awk ‘{print 100 – $1}’)
log “CPU使用率: ${cpu_usage}%”

# 进程CPU使用
log “进程CPU使用排行:”
ps aux –sort=-%cpu | head -10 | tee -a $LOG_FILE

# gaussdb进程CPU使用
log “gaussdb进程CPU使用:”
pid=$(pgrep gaussdb)
if [ -n “$pid” ]; then
pidstat -p $pid 1 3 | tee -a $LOG_FILE
else
log “gaussdb进程未找到”
fi
}

check_database_activity() {
log “=== 数据库活动检查 ===”

# 活跃连接数
active_connections=$(gsql -h 192.168.1.10 -d fgedudb -U fgedu -t -c ”
SELECT count(*) FROM pg_stat_activity WHERE state = ‘active’;
” | tr -d ‘ ‘)
log “活跃连接数: $active_connections”

# 慢SQL
log “慢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;
“)”
}

main() {
log “开始CPU监控检查…”
check_cpu_usage
check_database_activity
log “CPU监控检查完成”
}

main