Explain multi-version concurrency control in MySQL?
Answers were Sorted based on User's Feedback
Answer / cp
Multiversion concurrency control (abbreviated MCC or MVCC),
in the database field of computer science, is a concurrency
control method commonly used by database management systems
to provide concurrent access to the database.
MVCC provides each user connected to the database with a
"snapshot" of the database for that person to work with. Any
changes made will not be seen by other users of the database
until the transaction has been committed.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / amith
Each row has two additional columns associated with it -
creation time and deletion time, but instead of storing
timestamps, MySQL stores version numbers
Is This Answer Correct ? | 0 Yes | 0 No |
What are the three types of queries?
How do I start and stop mysql on windows?
How do I run mysql without installing?
How is myisam table stored?
How can you plan the logshipping before processing?
How can you change the password of a mysql user?
What is pdo connection?
What is the query to display top 20 rows?
Explain about the architecture of MYSQL?
How do I restore a mysql database dump file in linux?
What does it mean to be case sensitive?
Does adding an index lock a table?