search

Percona-Lab / sysbench-tpcc

Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL
Apache License 2.0
292 stars 104 forks source link

Implement option --splittable=yes|no #45

Closed hgxl64 closed 2 years ago

hgxl64 commented 2 years ago

If this option is enabled sysbench-tpcc will start transactions with START TRANSACTION READ ONLY resp. START TRANSACTION READ WRITE instead of using a BEGIN statement.

This allows to use a filtering proxy (i.e. MaxScale) to separate read-only transactions and route them to a replica.