Oltpbenchmark

oltpbenchmark是一套Java写的数据库效能测试程式。

安装

先下载：

sudo apt install -y ant default-jdk openjdk-8-jdk git locales tzdata
cd ~
git clone https://github.com/oltpbenchmark/oltpbench.git

编译：

cd ~/oltpbench
ant clean
ant

设定

cd ~/oltpbench
cp config/tpcc_config_postgres.xml config/tpcc.xml
vim config/tpcc.xml
# Change "DBUrl", "username", and "password".

测试

先建立表格并且产生测试资料：

cd ~/oltpbench
./oltpbenchmark -b tpcc -c config/tpcc.xml --create=true
./oltpbenchmark -b tpcc -c config/tpcc.xml --load=true

实际测试：

# Test it:
cd ~/oltpbench
./oltpbenchmark -b tpcc -c config/tpcc.xml --execute=true

# Filter rate data only:
cd ~/oltpbench
./oltpbenchmark -b tpcc -c config/tpcc.xml --execute=true | grep 'Rate limited'

# Do benchmark 100 times:
cd ~/oltpbench
for i in {1..100}; do
  ./oltpbenchmark -b tpcc -c config/tpcc.xml --execute=true 2>&1 | grep 'Rate limited'
done

# Get average result:
cd ~/oltpbench
(for i in {1..100}; do
  ./oltpbenchmark -b tpcc -c config/tpcc.xml --execute=true 2>&1 | grep 'Rate limited'
done) | awk '{sum += $(NF - 1); print $(NF - 1)} END {print sum / NR}'

其他

如果以PostgreSQL的界面测试CockroachDB时，会因为CockroachDB不支援CONSTRAINT指到没有index的字段，会需要修改PostgreSQL产生表格时的设定，并且重新编译：

cd ~/oltpbench
vim src/com/oltpbenchmark/benchmarks/tpcc/ddls/tpcc-postgres-ddl.sql
# Remove all "ALTER TABLE ... ADD CONSTRAINT ..." entries near the end of the file.

# Then rebuild oltpbenchmark:
cd ~/oltpbench
ant clean
ant

另外CockroachDB只支援SERIALIZE模式，所以tpcc.xml内也修改成TRANSACTION_SERIALIZABLE。

外部链接

• 官方网站
• How to use oltpbenchmark