date i=0 /data0/cr_autotest/bin/mysql -uroot --port=15001 --protocol=tcp < ./table.sql date while [ $i -lt 816118 ] do i=`expr $i + 1` #echo "$i" /data0/cr_autotest/bin/mysql -uroot --port=15001 --protocol=tcp --database=test -e "insert into paggolog (priority, category, thread, message, layout, timestamp, paggologtype, secondstimestamp, mti, transactionflag) values ('HIGH','TESTING','Monty Taylor','Fwd: tablespace', 'paggolog', now(), 1, 'second', 'TEX', 'F')" > trash done date /data0/cr_autotest/bin/mysql -uroot --port=15001 --protocol=tcp --database=test -e "ALTER TABLE paggolog TABLESPACE ts1 STORAGE DISK ENGINE NDB;" date /data0/cr_autotest/bin/mysql -uroot --port=15001 --protocol=tcp --database=test -e "delete from paggolog where id <= 90000 limit 50000;"