#!/usr/bin/env bash
shopt -s expand_aliases
source /etc/profile.d/columnstoreAlias.sh
FILE=/var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves_em
LOGFILE=/tmp/test_loop.log

FILESIZE=$(ls -nl $FILE | awk '{print $5}')

cat /dev/null > $LOGFILE
  echo "initial:$FILESIZE" >> $LOGFILE
  echo "initial:$FILESIZE"

COUNTER=1
while [ $COUNTER -le 500 ]; do

  mcsStart &> /dev/null
  sleep 1
  mysql -e "select count(*) from wt.wt5;"

  mcsShutdown &> /dev/null

#compare EM
FILESIZE=$(ls -nl $FILE | awk '{print $5}')
echo "$COUNTER:$FILESIZE" >> $LOGFILE
echo "$COUNTER:$FILESIZE"

  echo "Completed loop $COUNTER."
  sleep 1
  let COUNTER=COUNTER+1

done
echo "View results in $LOGFILE."