This test was migrated from InfiniDB tests as part of the stability test. This test captures timing for each query and for each concurrent session if used. At Calpont, there was a mechanism to interpret this timing information and store them in another database server and present them using Microsoft Excel. If needed, we can write scripts to interpret the test results.
This test measures the performance of a DBMS by using TPCH group tests. The tests are defined in the sql subdirectory.
Usage:
pfSubmitGroupTest.sh grpNum testDB numConcur numRepeat testType timeoutVal dbmsType
grpNum= group number
testDB= database to be used
numConcur number of concurrent user
numRepeat number of iterations to repeat the test
testType S = stream run. Do not flush cache and run all queries in the group test
M = mixed run. Use query groups 1 to 5 as one group.
All users will pick queries from the group.
Each query will be executed only once.
timeoutVal Timeout value to abort the test. Not yet implemented.
dbmsType DBMS type, M for mySQL. Always use M for now.
Test timing for each group test will be log in ~/pf/test/testResult
1d6524707e