Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^4: Perl/PostgreSQL niche

by dbwiz (Curate)
on Sep 06, 2005 at 15:28 UTC ( #489551=note: print w/replies, xml ) Need Help??

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

But from what I have read, it aims and misses

You haven't read the entire story, I'm afraid.

MySQL programs are required to lock the entire table to perform updates.

That is not correct. Since version 3.23, MySQL has had the capability of locking at record level, using InnoDB tables.

I am administering an application where a MySQL database handles several thousand of concurrent updates, using transactions and referential integrity, without effort, providing a high level of efficiency.

Replies are listed 'Best First'.
Re^5: Perl/PostgreSQL niche
by merlyn (Sage) on Sep 06, 2005 at 15:40 UTC
      MySQL has had MVCC for several years. That's how the InnoDB engine works.

      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?

        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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://489551]
[LanX]: belg4mit: thanks for fixing your CB log!

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2018-06-23 15:07 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (125 votes). Check out past polls.