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 |
What is the maximum length of a table name, a database name, or a field name in MySQL?
How to dump a table from a database.
What is the purpose of using timestamp data type?
What is mysql and mysqli?
What is the default port for mysql and how it can change?
What ascii 31?
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 Answers E2 Solutions, Tesco,
How do I get a list of table names in mysql?
What is 1nf 2nf 3nf?
What are ddl statements in mysql?
How to load a csv file into a table
How do I flush privileges in mysql?