search

swarm64 / s64da-benchmark-toolkit

Swarm64 DA Benchmark Toolkit
https://swarm64.com/
MIT License
30 stars 12 forks source link

TPC-C port from sysbench #76

Closed sdressler closed 2 years ago

sdressler commented 4 years ago

This is a port of sysbench TPC-C to our benchmark toolkit using PL/pgSQL for the transactions. It is a bit rough currently and I am not sure whether the port is accurate. I planned to use this for some sort of HTAP testing which is unrelated to CH-BenCHmark and HTAPBench. Feel free to dig around and make comments.

Preparing the benchmark works as usual like ./prepare_benchmark --benchmark tpcc --dsn postgresql://postgres@localhost/tpcc_test --schema psql_native --scale-factor 10. Running is different currently, you'd need to PYTHONPATH=. ./benchmarks/tpcc/run.py --scale-factor 10 --workers 48.

Like the sysbench variant this is not 100% compliant to the spec. The think time is missing and delivery is not scheduled for deferred execution but executed when the RNG decides to.

sdressler commented 4 years ago

Forgot to mention: share as needed, seems like not everybody is yet on GH.

sdressler commented 4 years ago

Follow-up on the purpose of this: first and foremost this is to share knowledge. Whether it is merged eventually or not, I don't care so much. I will update this branch bit more to add some features which I need for HTAP. Maybe eventually we remove it and put it somewhere else. Happy to get feedback.