After collating MySQL notes, I made the above diagram. However, after reading Lin Xiaobin's column, I am not going to get into these details directly...
Data values for storing precision values of the DECIMAL and NUMERIC types (** fixed-point types **). Use these types when maintaining precision is important, such...
The common optimization methods of MySQL are divided into the following aspects: SQL optimization, design optimization, hardware optimization, etc., each of which contains a number...
Transaction isolation is one of the foundations of database processing. Isolation is the I in ACID; The isolation level is a setting that fine-tunes the...
Preface Following the SQL statement execution process principle, we began to contact the storage engine, but also have understood the role of the storage engine,...
The SQL standard defines four classes of isolation levels, including specific rules that define which changes are visible and which are not, both inside and...
There are four isolation levels in Mysql: Read Uncommit, Read Commit, Repeatable Read (default), and serializable read. The mysql isolation boundary has two scopes, the...
If all transactions in the database are executed sequentially, this approach can ensure that transactions are executed without exceptions and errors, but the problem is...
Hello, everyone. I'm warm-hearted big belly, Piggy. In the previous article, we explained how COMPACT is stored, and we will continue to learn about the...
As mentioned earlier, the InnoDB storage engine supports an adaptive hash index. The InnoDB storage engine automatically generates hash indexes for tables based on their...
This article will answer the above two questions, analyze the isolation level of transactions and the related locking mechanism. Isolation mainly refers to the isolation...
This article introduces the types of locks used by InnoDB, including global locks and table-level locks provided by mysql. InnoDB Locking is translated from the...