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 is msql?
How do I start mysql in linux?
What are views in mysql?
How we can get distinct columns values in mysql?
What is int mysql?
Why mysql is open source?
What is the maximum connection pool size?
Is mysql free download?
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?
What is difference between inner vs self vs cross?
How can you make a database as your current database?
What is the difference between database and table?
How do I connect to a mysql database?
Why do gaps in sequences occur?
How many rows can be inserted in mysql at a time?