# BenchmarkSQL
BenchmarkSQL is a [GPLv2](docs/LICENSE.txt) fair-use TPC-C like testing
tool.
## Overview
BenchmarkSQL is implemented in Java, using JDBC to stress test SQL databases.
The overall architecture is a series of data structures, queues and thread
groups that handle the simulated terminals, users and application threads.
Its architecture allows BenchmarkSQL to drive TPC-C configurations up to many
thousands of warehouses (known as the scaling factor) without overwhelming the
job scheduler of the test driver itself.
Yet it is capable of doing so without sacrificing one of the most important
measurements in a TPC-C, the end-user experienced response time at the terminal.
![TimedDriver](docs/TimedDriver-1.svg)
Please read the [Full Architecture Description](docs/TimedDriver.md)
for a detailed explanation of the above diagram.
## Building
BenchmarkSQL V6 is meant to be built into a [Docker](https://www.docker.com/)
container and controlled via its Flask based WEB UI and/or API. This allows
for easy deployment of the benchmark driver on servers and cloud systems
while controlling it through a browser or scripted.
See the [build instructions](docs/BUILDING.md) for details.
# Configuring and Running a Benchmark
BenchmarkSQL is configured with files in Java properties format.
A detailed description of all parameters in that file can be found
[here](docs/PROPERTIES.md).
[comment]: # (TODO: ##Automation. Point to a tutorial walking through using the (yet to be written) command line interface.)
没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
收起资源包目录
开源数据库测试工具(包含TPC-C测试脚本) (115个子文件)
bmsql.css 723B
Dockerfile 1KB
.gitignore 89B
.gitignore 30B
.gitignore 9B
main.html 4KB
report_extended.html 3KB
report_simple.html 2KB
inc_summary_table.html 2KB
inc_latency_explain.html 929B
img_interface_octets.html 896B
img_disk_octets.html 891B
inc_summary_explain.html 829B
img_disk_ops.html 806B
img_interface_packets.html 787B
inc_nopm_explain.html 562B
img_memory.html 169B
img_cpu.html 120B
img_latency.html 66B
img_nopm.html 61B
AppGeneric.java 45KB
jTPCCMonkey.java 25KB
jTPCC.java 21KB
LoadDataWorker.java 20KB
AppOracleStoredProc.java 17KB
AppPostgreSQLStoredProc.java 14KB
jTPCCSUT.java 12KB
LoadData.java 12KB
jTPCCScheduler.java 10KB
jTPCCRandom.java 10KB
jTPCCResult.java 5KB
jTPCCTData.java 5KB
ExecJDBC.java 5KB
OSCollector.java 4KB
jTPCCTDataList.java 2KB
AppOracleStoredProc.java 1KB
jTPCCConfig.java 1KB
jTPCCApplication.java 732B
LoadJob.java 301B
BUILDING-AWS-EC2.md 11KB
BUILDING-ROCKY8.md 10KB
TimedDriver.md 10KB
TUTORIAL-1.md 9KB
PROPERTIES.md 8KB
CHANGE-LOG.md 6KB
BUILDING.md 5KB
HOW-TO-RUN.md 5KB
DOCKER.md 2KB
README.md 2KB
TPCC.md 1KB
CONTRIBUTING.md 875B
HOW-TO-RUN-Oracle.md 772B
RELEASE.md 744B
index.md 647B
HOW-TO-RUN-Postgres.md 536B
BenchmarkSQL.png 112KB
tut1-bmsql-ui-1.png 99KB
screen-001.png 66KB
sample.firebird.properties 4KB
sample.transact-sql.properties 4KB
sample.mariadb.properties 4KB
sample.oracle.properties 4KB
sample.postgresql.properties 4KB
sample.last.properties 4KB
bmsqlPlot.py 17KB
benchmarksql.py 16KB
mcPrometheus.py 9KB
main.py 8KB
main.py 6KB
bmsqlResult.py 6KB
mcCollectdMqtt.py 5KB
mcCollectdGraphite.py 3KB
generateReport.py 73B
__init__.py 69B
.pydevproject 341B
runSQL.sh 1KB
funcs.sh 1KB
runDatabaseBuild.sh 977B
runDatabaseDestroy.sh 592B
runBenchmark.sh 564B
runLoader.sh 318B
podman-run.sh 228B
podman-build.sh 77B
storedProcedureCreates.sql 29KB
storedProcedureCreates.sql 16KB
checks.sql 5KB
check_details.sql 4KB
tableCreates.sql 3KB
tableCreates.sql 3KB
tableCreates.sql 3KB
tableCreates.sql 3KB
tableCreates.sql 3KB
tableCopies.sql 2KB
foreignKeys.sql 1KB
indexCreates.sql 960B
indexDrops.sql 620B
storedProcedureDrops.sql 537B
storedProcedureCreates.sql 322B
storedProcedureDrops.sql 322B
extraCommandsBeforeLoad.sql 298B
共 115 条
- 1
- 2
SteptoStep_001
- 粉丝: 204
- 资源: 11
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0