sysbench

MySQL & MariaDB Other MySQL® Questions
1

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.

Thanks! )

-Noah

2

There is no practical way to disable MVCC inside of InnoDB. You can do it with SERIALIZABLE transaction isolation level, but then you get zero concurrency.