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 |
How do I get a list of table names in mysql?
How can we get the number of rows affected by query?
How do I completely remove mysql from windows?
Why mongodb is faster than mysql?
If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?
How to update info already in a table and delete a row(s) from a table.
What is bdb (berkeleydb)?
What is view? How can you create and drop view in mysql?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What is row level locking in access?
Explain the difference between FLOAT, DOUBLE and REAL.
ru compare the 2 null values?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)