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 msql?

723


How do I start mysql in linux?

644


What are views in mysql?

685


How we can get distinct columns values in mysql?

785


What is int mysql?

694


Why mysql is open source?

661


What is the maximum connection pool size?

711


Is mysql free download?

633


I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1675


What is difference between inner vs self vs cross?

684


How can you make a database as your current database?

685


What is the difference between database and table?

739


How do I connect to a mysql database?

659


Why do gaps in sequences occur?

726


How many rows can be inserted in mysql at a time?

718