adspace


Explain multi-version concurrency control in MySQL?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105


How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247


What is current version of mysql?

1084