http://qs321.pair.com?node_id=489587


in reply to Re^5: Perl/PostgreSQL niche
in thread Perl/PostgreSQL niche

MVCC Multi-Version Concurrency Control is just a fancy name to signify transactions at "Repeatable Read" and "Serializable" isolation levels. I didn't care to mention all the manual to you. Just the basic facts.

InnoDB has MVCC without that name. It provides full and reliable ACID compliant transactions. That's enough for me. If the fancy name is not in the manual, who cares?

Replies are listed 'Best First'.
Re^7: Perl/PostgreSQL niche
by perrin (Chancellor) on Sep 06, 2005 at 20:32 UTC
    InnoDB is often referred to as having MVCC, so I don't think there's any reason to avoid the name. In addition to making those isolation levels possible, it allows readers to get a consistent state without waiting for writers, increasing the scalability of the system.