benchbase
benchbase copied to clipboard
cmu-db
Multi-DBMS SQL Benchmarking Framework via JDBC
The current way the CloseAuctions procedure is issued is with custom code in the executeWork method, instead of scheduled by the worker. This means that if the transaction fails on...
CockroachDB adds a hidden column called `crdb_internal_*` when a hash-sharded primary key is used, that should not be directly used via the catalog. https://www.cockroachlabs.com/docs/stable/hash-sharded-indexes#create-a-table-with-a-hash-sharded-primary-key
When running chbenchmark (on 12e3acc56): java -jar benchbase.jar -b chbenchmark -c config/postgres/chbenchmark_config.xml -create true -load true - -execute true I get a lot of error messages generated: chbenchmark: [WARN ]...
Is the unit used correct for "tp (req/s) scaled" ? Time (seconds),Throughput (requests/second),Average Latency (millisecond),Minimum Latency (millisecond),25th Percentile Latency (millisecond),Median Latency (millisecond),75th Percentile Latency (millisecond),90th Percentile Latency (millisecond),95th Percentile Latency...
Disabled via #330 for now, but we should dig into this and see why it's taking so much longer than other engines. e.g., perhaps it's missing an index, has some...
Should make rerunning things like the following quicker when only configs and not code have changed: ```sh BENCHBASE_PROFILE=mysql ./docker/build-run-benchmark-with-docker.sh tpcc ```
I've noticed that TPC-H schema contains many extra indexes (for quite some tables). Here is an example: line item table has at least 6 extra indexes: https://github.com/cmu-db/benchbase/blob/main/src/main/resources/benchmarks/tpch/ddl-postgres.sql#L125-L130 Where are these...
I tried --dialects-export option for tpcc and tpch with postgres, but it seems not work. Nothing is output on the console and no SQL file is created.
sqlite doesn't support - explicit "lock table" - sleep operations in its SQL syntax. The former may possible with a `BEGIN EXCLUSIVE TRANSACTION; {stmt}; COMMIT TRANSACTION;` style operation, however the...