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 |
Is mysql a server or database?
Is mariadb faster than mysql?
How to return query output in html format?
How to start mysql server?
What is ACID?
What is table level locking in mysql?
Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?
What is the maximum number of records in mysql table?
How do I check mysql version?
What is triggers?
How do I fix a crashed mysql database?
How do I copy an entire mysql database?
Oracle (3253)
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)