#!/bin/bash

count=5

mysql="./bin/mysql -uroot -S /tmp/my_node1.sock "
mysql2="./bin/mysql -uroot -S /tmp/my_node2.sock "

pre_query="CREATE TABLE IF NOT EXISTS test.xxxx (i int, j varchar(10000))engine=innodb"
echo Executing $query ...
$mysql -e "$pre_query"

for ((i=0; $i<$count; i=$i+1)) do
  echo "Iteration $i.."
  query="INSERT INTO test.xxxx VALUES($i, REPEAT('x',1000))"
  query2="FLUSH TABLES"
  $mysql -e "$query" &
  $mysql2 -e "$query2" &
done