sysbench-tpcc icon indicating copy to clipboard operation
sysbench-tpcc copied to clipboard

Asking for Clarification About the Delivery Transaction Implementation

Open VOID001 opened this issue 4 years ago • 0 comments

In the delivery transaction, percona sysbench uses "SELECT FOR UPDATE" in

        rs = con:query(([[SELECT no_o_id
                                     FROM new_orders%d 
                                    WHERE no_d_id = %d 
                                      AND no_w_id = %d 
                                      ORDER BY no_o_id ASC LIMIT 1 FOR UPDATE]])
                                   :format(table_num, d_id, w_id))

But from the TPC-C spec I don't find out any place that requires this statement to perform locking read on the record. Could you please give an explanation about it ? Since the performance will be better if we use non locking read

VOID001 avatar Jul 14 '21 09:07 VOID001