#!/bin/bash

records=1000

MYSQL_1="mysql --no-defaults -uroot --port=16000 --protocol=tcp test"
MYSQL_2="mysql --no-defaults -uroot --port=16001 --protocol=tcp test"

echo "dropping table t1"
$MYSQL_1 -e 'DROP TABLE t1'

sleep 5

echo "creating table t1"
$MYSQL_1 -e 'CREATE TABLE t1(i INT,j INT)ENGINE=INNODB'

echo "inserting $records records."
for ((i=1; i <= $records; i++)) do
$MYSQL_1 -e "INSERT INTO t1 VALUEs($i, 1)"
done

sleep 5

echo "updating records."
for ((i=1; i <= $records; i++)) do
  $MYSQL_2 -e "INSERT INTO t1 VALUES($i+$records, 1)"
  $MYSQL_1 -e "UPDATE t1 SET i=($i+$records) WHERE j=1"
done