Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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.


Comment on Re^4: Perl/PostgreSQL niche
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://489551]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (11)
As of 2014-07-11 14:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (227 votes), past polls