57 lines
2.7 KiB
Bash
Executable File
57 lines
2.7 KiB
Bash
Executable File
#!/bin/bash
|
|
#
|
|
#-------------------MYRHOME/concurrency------------------------------------------------------------------------------
|
|
#
|
|
# Usage: DMLTest.sh dbName dmlCommand testMode numIter
|
|
# buildName = build of MyRocks to be tested
|
|
# dbName = name of database to be tested in
|
|
# dmlCommand = update, delete, or ldi
|
|
# testMode = commit = commit at the of SQL script
|
|
# rollback = rollback at the end of SQL script
|
|
# commiteach = commit after each DML statement
|
|
# rollback = rollback after each statement
|
|
# default = default behavior controlled by the autocommit variable.
|
|
# numIter = number of test iterations
|
|
# Generate a script to of dmlCommands for each of the TPCH tables
|
|
# Execute the scripts in 8 sessions, one for each table
|
|
# Repeat the test for numIter times
|
|
#
|
|
rm -f *.txt
|
|
numIter=1
|
|
errCode=0
|
|
#
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test update commit $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test update commiteach $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test update rollback $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test update rollbackeach $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test update default $numIter
|
|
errCode=`expr $errCode + $?`
|
|
#
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test delete commit $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test delete commiteach $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test delete rollback $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test delete rollbackeach $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test delete default $numIter
|
|
errCode=`expr $errCode + $?`
|
|
#
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test ldi commit $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test ldi commiteach $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test ldi rollback $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test ldi rollbackeach $numIter
|
|
errCode=`expr $errCode + $?`
|
|
$MYRHOME/concurrency/concurrentDML/test/DMLTest.sh mytest test ldi default $numIter
|
|
errCode=`expr $errCode + $?`
|
|
#
|
|
exit $errCode
|
|
|