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

How to set the percent number of read and write when testing tpcc #15

Closed mk-luo closed 5 years ago

mk-luo commented 5 years ago

In the scenario of mixed read and write , how can I control the percents of read or write (For example 30% write and 70% read) in tpcc testing ?

vadimtk commented 5 years ago

tpcc is very defined workload, you can't control how many reads or write to perform.

littlexsparkee commented 4 years ago

@vadimtk I know TPCC is not set up for that, but is it inadvisable to make modifications to that effect? If one were to modify the tpcc_common.lua to take an extra command line argument and then modify the 6 transaction shares in tpcc.lua, would it break the functionality? I was hoping to model a shift in these allocations as the run progresses. Thanks.

vadimtk commented 4 years ago

@vadimtk I know TPCC is not set up for that, but is it inadvisable to make modifications to that effect? If one were to modify the tpcc_common.lua to take an extra command line argument and then modify the 6 transaction shares in tpcc.lua, would it break the functionality? I was hoping to model a shift in these allocations as the run progresses. Thanks.

I am fine with some modifications, I do not have ideological connections to tpcc standard.