#!/bin/bash
# bw.sh "prod:N arch:M": run N/M mysqldump streams for 30 s, measure rx on enp118s0 and payload bytes
IF=enp118s0; DUR=30
declare -A BASE=([prod]=300000000 [arch]=100000000)   # item_price_data, a different id range per stream
spec="$1"; tmp=$(mktemp -d)
rx0=$(cat /sys/class/net/$IF/statistics/rx_bytes)
k=0
for part in $spec; do src=${part%%:*}; n=${part##*:}
  for i in $(seq 1 $n); do k=$((k+1)); lo=$(( BASE[$src] + i*3000000 )); hi=$((lo+2999999))
    docker exec repricer-db sh -c "timeout $DUR mysqldump --defaults-extra-file=/secrets/$src.cnf --single-transaction --quick --no-create-info --skip-triggers --no-tablespaces --set-gtid-purged=OFF --column-statistics=0 --compression-algorithms=zstd,zlib --where 'id between $lo and $hi' repricer item_price_data 2>/dev/null | wc -c" > $tmp/$src.$i &
  done; done
wait
rx1=$(cat /sys/class/net/$IF/statistics/rx_bytes)
wire=$(( (rx1-rx0) ))
pay=$(cat $tmp/* | awk '{s+=$1} END{print s}')
printf "%-16s link: %6.1f Mbit/s (%5.1f MB/s)   payload: %5.1f MB/s\n" "$spec" $(echo "$wire*8/$DUR/1000000" | bc -l) $(echo "$wire/$DUR/1048576" | bc -l) $(echo "$pay/$DUR/1048576" | bc -l)
for f in $tmp/*; do printf "  %s=%.1f" $(basename $f) $(echo "$(cat $f)/$DUR/1048576" | bc -l); done; echo
rm -rf $tmp
