1 安装

• Java

• ant

• benchmarksql

1.1 安装java

# Java
export JAVA_HOME=/home/ubuntu/app/jdk1.8.0_212
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib
export PATH=${JAVA_HOME}/bin:$PATH

1.2 安装ant

1.3 安装benchmarksql

git clone https://github.com/pingcap/benchmarksql
cd benchmarksql
ant
cd run
./runDatabaseBuild.sh props.mysql
./runBenchmark.sh props.mysql

db=mysql
//driver=com.mysql.jdbc.Driver
driver=com.mysql.cj.jdbc.Driver
conn=jdbc:mysql://localhost:3306/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=true user=root
password=123456 warehouses=1 loadWorkers=4 terminals=1
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=10
//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

// Directory name to create for collecting detailed result data.
// Comment this out to suppress.
resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
//osCollectorScript=./misc/os_collector_linux.py
//osCollectorInterval=1
//osCollectorSSHAddr=user@dbhost
//osCollectorDevices=net_eth0 blk_sda

2 使用

2.1 测试库准备

mysql -uroot -p123456
create database tpcc;
exit;

2.2 数据创建

2.3 TPCC测试

2.4 结果分析

参考

1. 如何做 TiDB BenchmarkSQL 测试

2. mirror of benchmarksql on github

3. 使用 BenchmarkSQL 测试 PostgreSQL

4. benchmarksql50-mysql