{"repo":"Percona-Lab/sysbench-tpcc","free":true,"listed":false,"github":"https://github.com/Percona-Lab/sysbench-tpcc","clone":"git clone https://github.com/Percona-Lab/sysbench-tpcc.git","description":"Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL","language":"Lua","stars":331,"topics":["mysql","sysbench","postgresql","benchmark"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"sysbench-tpcc TPCC-like workload for sysbench 1.0.x. Make sure you are using sysbench 1.0.14 or better! This is NOT an implementation of TPCC workload. It is \"TPCC-like\" and uses only queries and schemas from TPCC specification. It does not respect the required \"keying time\", and functions as a closed loop contention benchmark on a fixed data set, rather than an open loop benchmark that scales with the number of warehouses. It also does not respect multiple other TPCC specification requirements. Please do not use sysbench-tpcc to generate TPC-C results for comparing between vendors, or please attach a similar disclaimer as to the TPCC-like nature. prepare data and tables ./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbt --time=300 --threads=64 --report-interval=1 --tables=10 --scale=100 --db-driver=mysql prepare prepare for RocksDB ./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbr --time=3000 --threads=64 --report-interval=1 --tables=10 --scale=100 --use fk=0 --mysql storage engine=rocksdb --mysql table options='COLLATE latin1 bin' --trx level=RC --db-driver=mysql prepare Run benchmark ./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbt --time=300 --threads=64 --report-interval=1 --tables=10 --scale=100 --db-driver=mysql run Cleanup ./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbt --time=300 --threads=64 --report-interval=1 --tables=10 --scale=100 --db-driver=mysql cleanup","default_branch":null,"files":null,"tree":[],"storefront":"/r/Percona-Lab","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Percona-Lab/sysbench-tpcc/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}