Explain multi-version concurrency control in MySQL?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amith
Each row has two additional columns associated with it -
creation time and deletion time, but instead of storing
timestamps, MySQL stores version numbers
Is This Answer Correct ? | 0 Yes | 0 No |
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What is a heap table?
What are the critical issues you have resolved in your company
How to find out the second largest element from mysql table
can you tell the order of sql select statement? : Mysql dba
How do I copy a table in mysql workbench?
What is mysqladmin flush hosts?
What are the non-standard sql commands supported by 'mysql'?
How do you create a primary key?
What are numeric data types?
What is difference between pdo and mysqli?
How to dump a table from a database.