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
what is the difference between between and in operators in mysql?
What is the return type of mysqli_query?
How can I connect mysql database?
How to return query output in html format?
What are Heap tables?
What is timestamp in mysql?
Which is better mysql or microsoft sql?
What is the use of mysql_fetch_array () function in php?
How do you create a table in mysql workbench?
What is mysql default database?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
In how many ways we can retrieve data in the result set of mysql using php?
Is foreign key indexed mysql?
What is the difference between truncate and delete?