Skip to content

Instantly share code, notes, and snippets.

@c4pt0r
Created May 26, 2019 21:46
Show Gist options
  • Save c4pt0r/ca9ecdecc45de5d60d334aa80d031243 to your computer and use it in GitHub Desktop.
Save c4pt0r/ca9ecdecc45de5d60d334aa80d031243 to your computer and use it in GitHub Desktop.
tpcc configuration for TiDB
db=mysql
driver=com.mysql.jdbc.Driver
conn=jdbc:mysql://0.0.0.0:6000/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=false&callableStmtCacheSize=1000&prepStmtCacheSize=1000&sessionVariables=tidb_batch_commit=1
user=root
password=
warehouses=1000
loadWorkers=32
terminals=500
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=5
//Number of total transactions per minute
limitTxnsPerMin=0
//Set to true to run in 4.x compatible mode. Set to false to use the
//entire configured database evenly.
terminalWarehouseFixed=true
//The following five values must add up to 100
//The default percentages of 45, 43, 4, 4 & 4 match the TPC-C spec
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment