BenchMarksql 6.0

1 背景知识

BenchMarksql 6.0 是一个使用 TPC-C 测试方案的测试工具。

BenchMarksql 是使用 JAVA 语言实现的,底层使用 JDBC 驱动对数据库进行压力测试。此工具使用模拟客户端模拟:查询、多线程组、多用户和应用线程等操作。

BenchMarksql 6.0 设计架构允许驱动数千个TPC-C 仓库,同时还不会让调度系统稳健运行。

Schedulder
Maintains queue of TData
and sends entries that are 
due to the SUT.
Schedulder...
Delivery
BG request
Delivery...
TData with
dialog result
TData with...
TData with
dialog result
TData with...
Monkey Queue
Processed FIFO queue
of TData with resuls 
from SUT,collects response
time statistics and generates
input for next trasaction
Monkey Queue...
Monkey
Thread
Monkey...
Monkey
Thread
Monkey...
TData with
dialog input
TData with...
System Under Test
Processes FIFO queue 
of TData sent from Scheduler
or Delivery queue
System Under Test...
SUT
Thread
SUT...
SUT
Thread
SUT...
SUT
Thread
SUT...
Database
Database
Delivery BG Scheduler
Maintains queue of
Delivery Backgroud 
Requests and sends
them back to the SUT
for processing when 
possibe
Delivery BG Scheduler...
Delivery
BG request
Delivery...
Text is not SVG - cannot display

对于上图的详细说明,了解 BenchmarkSQL Timed Driver 的内部原理和内部机制。

2 BenchMarksql 6.0 实战

BenchMarksql 6.0 安装与部署
BenchMarksql 6.0 配置文件
PostgreSQL BenchMarksql 6.0 性能测试
PostgreSQL BenchMarksql 6.0 & Prometheus 性能测试
PostgreSQL BenchMarksql 6.0 & collectd 基准测试

3 参考链接

GitHub - pgsql-io/benchmarksql: A TPC-C like test tool