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

How triggers can be used in mysql?

565


How do you select a table?

487


What is logs in mysql?

492


Is mysql a framework?

494


Is number a datatype in mysql?

490






what is the difference between gui testing and database testing? : Mysql dba

527


Is mysql a odbc?

475


How do I make an action query?

485


In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

2592


How to calculate the difference between two time values?

459


Is mysql free for commercial use?

476


Is mysqli deprecated?

502


How do I edit a stored procedure in mysql?

500


What is blob in mysql?

501


Can we store images in mysql database?

484