#!/bin/bash

skipdisablekeys=0
sleeptime=0.1

mysql -e 'DROP DATABASE IF EXISTS testdb;CREATE DATABASE testdb;'
mysql testdb -e 'CREATE TABLE testtable ( id int, a int,PRIMARY KEY (id)) ENGINE=InnoDB;'
mysql testdb -e 'INSERT INTO testtable VALUES (1,2),(2,3),(3,4);'
if [[ "$skipdisablekeys" == "0" ]]; then
  echo "Testing with disabled keys"
  mysqldump testdb testtable > dump.sql
else
  echo "Testing without disabled keys"
  mysqldump --skip-disable-keys testdb testtable > dump.sql
fi

systemctl restart mariadb
mysql -V

while :
do
  mysql -e 'DROP DATABASE IF EXISTS testdb;CREATE DATABASE testdb;'
  mysql testdb < dump.sql
  
  COUNTER=0
  while :
  do
    sleep $sleeptime
    rows=`mysql --skip-column-names -e "SELECT n_rows > 0 FROM mysql.innodb_table_stats WHERE database_name='testdb' AND table_name='testtable'"`
    let COUNTER=COUNTER+1
    if [[ "$rows" == "1" ]]; then
      echo Duration: `echo $COUNTER*$sleeptime | bc` seconds
      break
    fi
  done
  echo `date` - `mysql testdb -e 'SHOW TABLE STATUS LIKE "testtable"\G' | grep Rows`
  sleep 10
done