Exploring the Principle of Multi-version Concurrency Control in MySQL

Introduction: In this course, we will not only guide you to understand the basic concepts of MySQL database such as isolation levels, dirty reads, non-repeatable reads, and phantom reads; It will also combine sql to simulate concurrent transactions, helping everyone understand the isolation between transactions in the database under different isolation levels. Through in-depth analysis and the review of frequently encountered test questions, we aim to help everyone gain a deeper understanding and recognition of the principle of multi-version concurrent control in MySQL databases.

Chapter 1 Course Introduction

In this chapter, we will briefly introduce the learning objectives, learning routes, and help everyone clarify the key points and difficulties of learning.

1-1 Course Overview

Chapter 2 [Unraveling the Mystery] Analysis of MySQL Transaction Principles

In this chapter, we will introduce the types of isolation levels, how to set them, the effects of reading and writing data between different transactions, and the impact of setting different isolation levels on concurrent transactions in combination with business scenarios.

2-1 Chapter Introduction

2-2 MySql Transaction Isolation Levels

2-3 How to view and set the isolation level

2-4 How should I choose the isolation level

2-5 Isolation Levels and Concurrent Transactions (Part 1

2-6 Isolation Levels and Concurrent Transactions (Part 2)

2-7 Isolation Levels and Concurrent Transactions (Part 2)

2-8 mysql Logs

2-9 Hidden Fields (Part 1

2-10 Hidden Fields (Part 2

2-11 Current read snapshot read

2-12 Read views

2-13 Data Visibility Algorithm

2-14 Summary of This Chapter

Chapter 3 Experience Summary

In this chapter, we will summarize the usage and Settings of transactions, as well as common application methods in work, and share practical experiences such as the usage skills of indexes and the differences of joint queries in work with everyone.

3-1 Chapter Introduction

3-2 Transaction Usage Experience

3-3 Index Experience Summary

3-4 Summary of MySQL Interview Questions  (Part 1

3-5 Summary of MySQL Interview Questions (Part 2

3-6 Chapter Summary of This Chapter

3-7 Course Summary and Discussion Reflections