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, if a table has one column defined as TIMESTAMP?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
Which is best pdo or mysqli?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How to set the time zone for MySQL to particular country time?
Why we use mysql database?
How is mysql database stored?
what is the difference between gui testing and database testing? : Mysql dba
What is max connection in mysql?
In how many ways we can retrieve data in the result set of mysql using php?
How can an index be declared in mysql?
Why mysql is used with php?
What is datadir?
State the differences between mongodb and mysql.
Do I need to pay for mysql?