Oltpbenchmark:修订间差异
跳到导航
跳到搜索
此页面具有访问限制。如果您看见此消息,则说明您没有权限访问此页面。
(→外部連結) |
(→測試) |
||
第60行: | 第60行: | ||
grep 'Rate limited' | grep 'Rate limited' | ||
done) | awk '{sum += $(NF - 1); print $(NF - 1)} END {print sum / NR}' | done) | awk '{sum += $(NF - 1); print $(NF - 1)} END {print sum / NR}' | ||
</syntaxhighlight> | |||
== 其他 == | |||
如果測試[[CockroachDB]]時,會因為CockroachDB不支援<code>CONSTRAINT</code>指到沒有index的欄位,會需要修改[[PostgreSQL]]產生表格時的設定,並且重新編輯: | |||
<syntaxhighlight lang="bash"> | |||
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 | |||
</syntaxhighlight> | </syntaxhighlight> | ||
2018年12月31日 (一) 04:55的版本
oltpbenchmark是一套Java写的数据库效能测试程式。
安装
先下载:
sudo apt install -y ant default-jdk openjdk-8-jdk git locales
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
# Just need data:
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}'
其他
如果测试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