Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "the summary of knowledge points of MySQL MVCC". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1). Multi-Version Concurrency Control multi-version concurrency control. MVCC is a method of concurrency control, which generally realizes concurrent access to the database in the database management system.

2)。 Under the MVCC protocol, each read operation will see a consistent snapshot, and can achieve non-blocking read. MVCC allows multiple versions of data, which can be a timestamp or a globally incremented transaction ID, where different transactions see different data at the same point in time.

3) .MVCC solves the problem that reads and writes do not block each other. Each update produces a new version, and if you read it, you can read the historical version.

4) .MVCC implements concurrency control by saving multiple versions of data. When a piece of data needs to be updated, the storage system that implements MVCC will not immediately overwrite the original data with new data, but create a new version of the record.

5) .MVCC is realized by saving snapshots of data at a certain point in time. The MVCC implementation of different storage engines is different, typically including optimistic lock concurrency control and pessimistic lock concurrency control, while optimistic lock implementation uses MVCC.

6) .MVCC saves a snapshot of data at a point in time. This means that transactions can see a consistent view of the data, no matter how long they need to run. This also means that different transactions may see different data for the same table at the same point in time.

This is the end of the summary of the knowledge points of MySQL MVCC. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.