Four isolation levels and seven propagation behaviors for database transactions, finally clarified! Isolation: The execution of one transaction should not be interrupted by other transactions....
The first two articles talked about MySQL full backup and incremental backup, we also learned about database backup and restore. This also enhances the security...
Installed MySQL to delete the original MySQL check whether installed MySQL installed MySQL, need to delete to delete the original MySQL verify unload quickly if...
Reasons for slow query: (1) Long execution time; ② Long waiting time. The query statement is not written properly. Index invalid. Join queries are too...
We often encounter such scenarios in project development: enterprise organizational structure, reply comment chain, product category and other tree structures. This article combines some information...
Database is a programmer must have a basic skill, basic every interview will ask. This article is an illustrated, step-by-step guide to thoroughly understand MySQL's...
Because mariadb5.x is the lower version of the time function support less, need to upgrade the original database version database upgrade database restore if you...
Explain the MySQL database from 11 aspects: MySQL architecture, storage engine, data types, indexes, SQL statements, transactions, locking mechanism, performance optimization, partition, sub-table and sub-library,...
How to install MySQL in Ubuntu14.04. Today, I will share with you how to configure MySQL easily, which can achieve remote connection. 1, mysql configuration...
For most developers, write SQL statements that add, delete, and modify the database through the database connection, but don't care how the database listens for...
Share it with everyone. SQL injection was first discovered in Rain Forest Puppy and brought to public attention. SQL injection gets a lot of attention....
Warehouse means warehouse. The storehouse that stores grain is called grain storehouse, the storehouse that stores fruit at low temperature, meat is called cold storehouse....
What are storage engine categories and their application scenarios? Principles for creating indexes? Index failure condition? == Verify whether the SQL statement uses indexes. Use...
RU read uncommitted. As the name implies, at this isolation level, uncommitted data is read when multiple transactions operate on the same data in parallel,...
Innodb improves efficiency by using buffer pools to reduce the number of disk queries. LRU is generally implemented using a linked list, which has Head...
This article focuses on the implementation of ACID in MySQL InnoDB engine. For more information about what is a transaction and what isolation levels mean,...
Referring to transactions we are certainly not unfamiliar, and the database will always use transactions. The classic example is transferring money, let's say you have...