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
Write a query to find duplicate rows in table?
How to validate email addresses in mysql?
what is database white box testing? : Mysql dba
What are the difference between now and current_date in mysql?
What is the default port for MySQL Server?
Is mysql a server or database?
How we get sum of column.
How many queries can mysql handle?
Why do we use preparedstatement?
What tools available for managing mysql server?
How do I create a schema in mysql?
How do stored procedures work?
How do I add a column to a table in mysql?
How to dump a table from a database.
Why mysql is open source?