Explain multi-version concurrency control in MySQL?

Answers were Sorted based on User's Feedback



Explain multi-version concurrency control in MySQL?..

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

Explain multi-version concurrency control in MySQL?..

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

Post New Answer

More MySQL Interview Questions

What are the three types of queries?

0 Answers  


How do I start and stop mysql on windows?

0 Answers  


How do I run mysql without installing?

0 Answers  


How is myisam table stored?

0 Answers  


How can you plan the logshipping before processing?

0 Answers   ACC,


How can you change the password of a mysql user?

0 Answers  


What is pdo connection?

0 Answers  


What is the query to display top 20 rows?

0 Answers  


Explain about the architecture of MYSQL?

0 Answers  


How do I restore a mysql database dump file in linux?

0 Answers  


What does it mean to be case sensitive?

0 Answers  


Does adding an index lock a table?

0 Answers  


Categories