sysbench-tpcc

sysbench-tpcc copied to clipboard

Execution crashes for PostgreSQL with SQL syntax error

4

Syntactically wrong SQL is fired against PostgreSQL after few hours of execution. here is the extract from the log ... [ 20060s ] thds: 4 tps: 11.00 qps: 360.60 (r/w/o:...

jobinau

Perhaps I missed something in the code but it looks like this benchmark doesn't implement the "think time" for each transaction as outlined in section 5.2.5.4 of the TPC-C spec...

rkruze

Hi Team, Please can you provide sample LUA script for DML operation on postgres like simple queries as below :- select count(*) from table; insert into table_name values(100,200,..); update table_name...

pinakesh

I find that the length of `h_data` field in the history table is 24. ``` mysql> desc history1; +----------+--------------+------+------+---------+-------+ | Field | Type | Null | Key | Default |...

siddontang

for postgresql (performance improve), should use prepared statement, exp: ``` prepare p1(int) as select * from tbl where id=$1; execute p1(:id); ... ```

digoal

load does not terminate on error

1

FATAL: mysql_drv_query() returned error 1799 (Creating index 'fkey_order_line_21' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.) for query 'CREATE INDEX fkey_order_line_21 ON order_line1 (ol_supply_w_id,ol_i_id)' FATAL: `sysbench.cmdline.call_command' function...

vadimtk

tpcc.lua script is not terminating when it hit `Unknown storage engine` error. It also open blank sessions in mysql server ``` [vagrant@pgsql ~]$ /usr/share/sysbench/tpcc.lua --mysql-user=root --mysql-db=test --time=30 --threads=64 --report-interval=1 --tables=2...

rameshvs02

segmentation fault (core dumped) ubuntu

1

Hi, I am running sysbench tpc-c 1.0.20 on PostgreSQL 14. During the "prepare" I get the following error: segmentation fault (core dumped) ubuntu On "Ubuntu 20.04.3 LTS" and "Ubuntu 18.04.6...

alexeevo

Need to access Sysbench Grafana files for TPC-C for "order-demo" that Peter showed in the GrafanaCon: Business Dashboards with Grafana and MySQL.

kriskrishna

I noticed that this package was dropped from here: https://repo.percona.com/apt/dists/jammy/main/binary-amd64/ Any chance that you guys will continue building it?

mraygalaxy