Announcement

Announcement Module
Collapse
No announcement yet.

sysbench

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • sysbench

    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.

    Comment

    Working...
    X