benchmarksql是一款使用Java開發的測試工具.
安裝使用相對比較簡單,下載解壓到安裝目錄
```
cd /home/pg12/software/benchmarksql-4.1.1/run

```
配置引數,修改配置檔案props.pg
```
#############################################
[pg12@localhost run]$ cat props.pg 
//資料庫連線資訊
driver=org.postgresql.Driver
conn=jdbc:postgresql://192.168.26.28:5440/benchmarkdb
user=pg12
password=pg12
//多少倉
warehouses=100
//併發數
terminals=20
//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

//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

```
建立資料表&索引(100倉的資料)
```
#############################################
./runSQL.sh  props.pg sqlTableCreates
./runLoader.sh props.pg  numwarehouses 32
./runSQL.sh  props.pg sqlIndexCreates

```
執行測試
```
./runBenchmark.sh props.pg

#1
...
2019-08-27 16:30:33,025  INFO - Term-00, Measured tpmC (NewOrders) = 7527.02                              
2019-08-27 16:30:33,025  INFO - Term-00, Measured tpmTOTAL = 16752.67
2019-08-27 16:30:33,025  INFO - Term-00, Session Start     = 2019-08-27 16:20:32
2019-08-27 16:30:33,025  INFO - Term-00, Session End       = 2019-08-27 16:30:33
2019-08-27 16:30:33,025  INFO - Term-00, Transaction Count = 167552

#2
...
2019-08-27 17:30:27,264  INFO - Term-00, Measured tpmC (NewOrders) = 5879.05
2019-08-27 17:30:27,264  INFO - Term-00, Measured tpmTOTAL = 13086.97                                    
2019-08-27 17:30:27,264  INFO - Term-00, Session Start     = 2019-08-27 17:20:20
2019-08-27 17:30:27,265  INFO - Term-00, Session End       = 2019-08-27 17:30:27
2019-08-27 17:30:27,265  INFO - Term-00, Transaction Count = 132408

```

**參考資料**
N/A

PostgreSQL DBA(87) - benchmarksql簡介

相關文章