Watch the progress of a MySQL optimize, as the percentage size of the new temp file vs. the original

optimize_watcher.sh

#!/bin/bash
# 
# Watch the progress of a MySQL optimize, as the percentage size of the new
# temp file vs. the original. Run in the MySQL data directory (wherever the
# .ibd files are).
#
# created: Aug 12, 2015
# updated: Apr 25, 2019
#
USAGE="$0: Usage is: $0 table-being-optimized"
TEMPTABLE=`ls -1 \#sql-*.ibd`

if [ -z "$1" ]
then
  echo $USAGE
  exit 32
fi

TABLESIZE=`ls -l ${1}.ibd | awk '{ print $5; }'`

while [ -f $TEMPTABLE ] 
do  
  s=`ls -l $TEMPTABLE | awk '{ print $5; }'`
  # echo "scale=4;$s/$TABLESIZE" | bc
  # following awk replaces above since bc isn't always available
  awk -v NEWSIZE=$s -v OLDSIZE=$TABLESIZE 'BEGIN { printf ("%0.2f\n", ((NEWSIZE / OLDSIZE) * 100)); }'
  sleep 180
done

echo "Done!"
ls -l ${1}.ibd