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 command is used to delete the data from the table without deleting the table structure?
What is dbms in mysql?
What is the difference between mysql and sql?
What is sql in mysql?
How to shut down the server with 'mysqladmin'?
What does mysql flush tables do?
Can we store files in mysql?
What is a delimiter in mysql?
How to create trigger in mysql phpmyadmin?
How will show all records containing the name "sonia" and the phone number '9876543210'
What is the difference between truncate and delete in mysql?
What are date and time intervals?
How do you flush privileges?
What are the different mysql database engines?
How do I run mysql?