Database

MySQL

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

Gist

• 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.^[1]
• 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.