Did you know?
Did you know MVCC or MCC (Multi-version concurrency control) method helps to keep database in waiting. This happens at the time, when read and write request is sent at the same time. Read more
- Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.
- Isolation is the property that provides guarantees in the concurrent accesses to data. Isolation is implemented by means of a concurrency control protocol.
- The simplest way is to make all readers wait until the writer is done, which is known as a read-write lock.
- Locks are known to create contention especially between long read transactions and update transactions.