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
Is mysql port 3306 tcp or udp?
What is clob datatype?
Is mysql good for big data?
What are the 3 main types of search queries?
What does mysql flush privileges do?
How to connect html form to mysql database using php?
How can you add and remove any column of a table?
How do I update a variable in mysql?
How to convert dates to character strings?
Is mysql a programming language?
What is mysql port?
How do you create a new database in mysql?
Why myisam is faster than innodb?
What are string data types?
What is bigint in mysql?