檢視 Oltpbenchmark 的原始碼

{{Lowercase}}
'''oltpbenchmark'''是一套[[Java]]寫的資料庫效能測試程式。

== 環境 ==

這篇所提到的設定主要是在Ubuntu 18.04下的[[Kubernetes]]（[[Docker]]）內的情境。

== 安裝 ==

先安裝並且設定需要的軟體：

<syntaxhighlight lang="bash">
sudo apt install -y ant default-jdk openjdk-8-jdk git locales tzdata
update-alternatives --config java
# Use Java 8
</syntaxhighlight>

取得並且編譯：

<syntaxhighlight lang="bash">
cd ~
git clone https://github.com/oltpbenchmark/oltpbench.git
cd ~/oltpbench
ant clean
ant
</syntaxhighlight>

== 設定 ==

<syntaxhighlight lang="bash">
cd ~/oltpbench
cp config/tpcc_config_postgres.xml config/tpcc.xml
vim config/tpcc.xml
# Change "DBUrl", "username", and "password".
</syntaxhighlight>

== 測試 ==

先建立表格並且產生測試資料：
<syntaxhighlight lang="bash">
cd ~/oltpbench
./oltpbenchmark -b tpcc -c config/tpcc.xml --create=true
./oltpbenchmark -b tpcc -c config/tpcc.xml --load=true
</syntaxhighlight>

實際測試：
<syntaxhighlight lang="bash">
# 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 --line-buffered '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 --line-buffered '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 --line-buffered 'Rate limited'
done) | awk '{sum += $(NF - 1); print $(NF - 1)} END {print sum / NR}'

# Brute-force to run all cases:
echo 2 4 8 16 32 64 128 256 512 768 | xargs -n1 | xargs -n1 -I% bash -c "sed -i -e 's/<terminals>[0-9]*/<terminals>%/' config/tpcc.xml; echo %; (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)} END {print sum / NR}'"
</syntaxhighlight>

== 調整 ==

在<code>tpcc.xml</code>內的<code>terminals</code>參數可以調整，以產生足夠多的client模擬測試。

== 其他 ==

=== CockroachDB ===

{{See also|CockroachDB}}

如果以[[PostgreSQL]]的界面測試[[CockroachDB]]時，會因為CockroachDB不支援<code>CONSTRAINT</code>指到沒有index的欄位，會需要修改PostgreSQL產生表格時的設定，並且重新編譯：

<syntaxhighlight lang="bash">
cd ~/oltpbench
sed -i -e 's/^ALTER TABLE /-- ALTER TABLE/' src/com/oltpbenchmark/benchmarks/tpcc/ddls/tpcc-postgres-ddl.sql

# Then rebuild oltpbenchmark:
cd ~/oltpbench
ant clean
ant
</syntaxhighlight>

另外CockroachDB只支援<code>SERIALIZE</code>模式，所以<code>tpcc.xml</code>內也修改成<code>TRANSACTION_SERIALIZABLE</code>：

<syntaxhighlight lang="bash">
cd ~/oltpbench
sed -i -e 's/TRANSACTION_READ_COMMITTED/TRANSACTION_SERIALIZABLE/' config/tpcc.xml
</syntaxhighlight>

== 外部連結 ==
* {{Official|https://github.com/oltpbenchmark/oltpbench}}
* [https://www.notion.so/gslin/How-to-use-oltpbenchmark-32c1bb0b235041e595274f5af403da6b How to use oltpbenchmark]

[[Category:軟體]]