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 is prepared statement in mysql?
How do you say mysql?
what is the difference between between and in operators in mysql?
what is database black box testing? : Mysql dba
How do I edit a stored procedure in mysql?
How can you find out the version of the installed mysql?
How do you shutdown a mysql database?
In mysql, what is the default storage engine?
Can foreign key have duplicate values?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
In which language mysql has been written?
Is mysql owned by oracle?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How database are managed?
what is mysql optimization in brief?