forked from mtusi2026/mtusi2026lab3
Compare API and PostgreSQL CPU budgets and connection pool limits. Collect repeatable measurements and generate report aggregates and graphs.
71 lines
2.8 KiB
Bash
Executable File
71 lines
2.8 KiB
Bash
Executable File
#!/bin/sh
|
|
# One persistent docker exec per service; stdout contains only numeric diagnostics.
|
|
set -eu
|
|
role=$1
|
|
stop=$2
|
|
watch_pid=''
|
|
cleanup() {
|
|
if [ -n "$watch_pid" ]; then
|
|
kill "$watch_pid" 2>/dev/null || true
|
|
wait "$watch_pid" 2>/dev/null || true
|
|
fi
|
|
}
|
|
trap cleanup EXIT
|
|
trap 'exit 0' TERM INT
|
|
printf '{"kind":"observer","version":3,"time_ms":%s000}\n' "$(date +%s)"
|
|
if [ "$role" = postgres ]; then
|
|
PGAPPNAME=scaling-observer psql -X -qAt -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$POSTGRES_DB" > "${stop}.pg.jsonl" <<'SQL' &
|
|
SELECT json_build_object(
|
|
'kind', 'postgres', 'time_ms', (extract(epoch FROM clock_timestamp())*1000)::bigint,
|
|
'activity', (SELECT coalesce(json_agg(a), '[]'::json) FROM (
|
|
SELECT state, wait_event_type, wait_event, count(*) AS count,
|
|
max(extract(epoch FROM clock_timestamp()-query_start)) FILTER (WHERE state = 'active') AS max_active_seconds
|
|
FROM pg_stat_activity WHERE datname=current_database() AND backend_type='client backend'
|
|
AND application_name <> 'scaling-observer'
|
|
GROUP BY state,wait_event_type,wait_event
|
|
) a),
|
|
'db', (SELECT row_to_json(d) FROM (
|
|
SELECT xact_commit,xact_rollback,blks_read,blks_hit,temp_files,temp_bytes,deadlocks,stats_reset
|
|
FROM pg_stat_database WHERE datname=current_database()
|
|
) d)
|
|
)::jsonb
|
|
\watch 2
|
|
SQL
|
|
watch_pid=$!
|
|
fi
|
|
while [ ! -f "$stop" ]; do
|
|
stamp="$(date +%s)000"
|
|
awk -v stamp="$stamp" '
|
|
BEGIN {printf "{\"kind\":\"cgroup\",\"time_ms\":%s", stamp}
|
|
FILENAME ~ /cpu.stat$/ {printf ",\"cpu_%s\":%s", $1, $2}
|
|
FILENAME ~ /memory.events$/ {printf ",\"memory_%s\":%s", $1, $2}
|
|
FILENAME ~ /memory.current$/ {printf ",\"memory_bytes\":%s", $1}
|
|
END {print "}"}
|
|
' /sys/fs/cgroup/cpu.stat /sys/fs/cgroup/memory.events /sys/fs/cgroup/memory.current
|
|
if [ "$role" = postgres ]; then
|
|
awk -v stamp="$stamp" '
|
|
BEGIN {printf "{\"kind\":\"host\",\"time_ms\":%s", stamp}
|
|
FILENAME ~ /pressure\// {
|
|
name=FILENAME; sub(/^.*\//,"",name)
|
|
for (i=2;i<=NF;i++) {
|
|
split($i,value,"=")
|
|
if (value[1] == "total") printf ",\"%s_%s_total_usec\":%s",name,$1,value[2]
|
|
}
|
|
}
|
|
FILENAME ~ /meminfo$/ && ($1 == "MemAvailable:" || $1 == "SwapFree:" || $1 == "SwapTotal:") {
|
|
name=$1; sub(/:$/,"",name); printf ",\"%s_kib\":%s",name,$2
|
|
}
|
|
END {print "}"}
|
|
' /proc/pressure/cpu /proc/pressure/memory /proc/pressure/io /proc/meminfo
|
|
fi
|
|
if [ "$role" = nginx ]; then
|
|
awk -v stamp="$stamp" '
|
|
BEGIN {printf "{\"kind\":\"upstream\",\"time_ms\":%s,\"servers\":[", stamp; sep=""}
|
|
/^server .*:8080 / {printf "%s\"%s\"", sep, $2; sep=","}
|
|
END {print "]}"}
|
|
' /etc/nginx/ready-upstreams.conf
|
|
fi
|
|
sleep 2
|
|
done
|
|
rm -f "$stop"
|