I’d like to ask you guys something about sysbench, particularly about the OLTP complex test.
It seems that the test exercises deadlocks by design. The way the transactions are built seems to favor the occurrence of deadlocks, please correct me if I’m wrong.
So far I have made tests with MySQL and PostgreSQL, since both have MVCC the deadlocks didn’t arise. Is there a way to “disable” MVCC on MySQL? my idea is to evaluate the performance of MVCC versus locking system.