Skip to content

Instantly share code, notes, and snippets.

@huynhbaoan

huynhbaoan/calc cpu

Last active September 16, 2024 20:43
Show Gist options
  • Save huynhbaoan/d41bdb07359165fcc0ad91a9e65b0242 to your computer and use it in GitHub Desktop.
Save huynhbaoan/d41bdb07359165fcc0ad91a9e65b0242 to your computer and use it in GitHub Desktop.
Download ZIP
Awk
Raw
calc cpu
grep -E '2024/(07|08|09)' $1 | awk -F, '
BEGIN {
sum_cpu_avg = 0;
sum_cpu_max = 0;
max_cpu_avg = 0;
max_cpu_max = 0;
count = 0;
}
{
sum_cpu_avg += $2;
sum_cpu_max += $3;
if ($2 > max_cpu_avg) max_cpu_avg = $2;
if ($3 > max_cpu_max) max_cpu_max = $3;
count++;
}
END {
# Print averages
printf "Average CPUUtilization Average: %.6f\n", sum_cpu_avg / count;
printf "Average CPUUtilization Maximum: %.6f\n", sum_cpu_max / count;
# Print maximums
printf "\nHighest CPUUtilization Average: %.6f\n", max_cpu_avg;
printf "Highest CPUUtilization Maximum: %.6f\n", max_cpu_max;
}'
Raw
calc sum then avg, plus max
grep -E '2024/(07|08|09)' yourfile.csv | awk -F, '
BEGIN {
sum_networkout_avg = 0;
sum_networkin_max = 0;
sum_networkin_avg = 0;
sum_networkout_max = 0;
max_networkout_avg = 0;
max_networkin_max = 0;
max_networkin_avg = 0;
max_networkout_max = 0;
count = 0;
}
{
sum_networkout_avg += $2;
sum_networkin_max += $3;
sum_networkin_avg += $4;
sum_networkout_max += $5;
if ($2 > max_networkout_avg) max_networkout_avg = $2;
if ($3 > max_networkin_max) max_networkin_max = $3;
if ($4 > max_networkin_avg) max_networkin_avg = $4;
if ($5 > max_networkout_max) max_networkout_max = $5;
count++;
}
END {
conversion_to_gbps = (8 / 1000000000); # Convert bytes to bits, then to Gbps
# Print averages in Gbps
printf "Average NetworkOut Average (Gbps): %.6f\n", (sum_networkout_avg / count) * conversion_to_gbps;
printf "Average NetworkIn Maximum (Gbps): %.6f\n", (sum_networkin_max / count) * conversion_to_gbps;
printf "Average NetworkIn Average (Gbps): %.6f\n", (sum_networkin_avg / count) * conversion_to_gbps;
printf "Average NetworkOut Maximum (Gbps): %.6f\n", (sum_networkout_max / count) * conversion_to_gbps;
# Print maximums in Gbps
printf "\nHighest NetworkOut Average (Gbps): %.6f\n", max_networkout_avg * conversion_to_gbps;
printf "Highest NetworkIn Maximum (Gbps): %.6f\n", max_networkin_max * conversion_to_gbps;
printf "Highest NetworkIn Average (Gbps): %.6f\n", max_networkin_avg * conversion_to_gbps;
printf "Highest NetworkOut Maximum (Gbps): %.6f\n", max_networkout_max * conversion_to_gbps;
}'
Raw
calculate sum then avg by column
grep -E '2024/(07|08|09)' yourfile.csv | awk -F, '
BEGIN {
sum_networkout_avg = 0;
sum_networkin_max = 0;
sum_networkin_avg = 0;
sum_networkout_max = 0;
count = 0;
}
{
sum_networkout_avg += $2;
sum_networkin_max += $3;
sum_networkin_avg += $4;
sum_networkout_max += $5;
count++;
}
END {
print "Average NetworkOut Average: " sum_networkout_avg / count;
print "Average NetworkIn Maximum: " sum_networkin_max / count;
print "Average NetworkIn Average: " sum_networkin_avg / count;
print "Average NetworkOut Maximum: " sum_networkout_max / count;
}'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment