绑定完请刷新页面
取消
刷新

分享好友

×
取消 复制
PostgreSQL DBA(87) - benchmarksql简介
2019-09-06 15:50:23

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

戳我,来吐槽~