MySQL indexes include normal indexes, unique indexes, full-text indexes, single-column indexes, multi-column indexes, and spatial indexes. In terms of functional logic, there are 4 kinds...
MVCC multi-version concurrency control, as the name suggests, is a mechanism used to implement concurrency control, and in databases, concurrency control is often for transactions,...
Concurrency Control for MULTI-version Concurrency Control (MVCC). Most of MySQL's transactional storage engines (InnoDB,Falcon, etc.) do not implement simple row-level locking. In order to improve...
Consistent nonlocking read refers to the fact that InnoDB storage engine reads the data of rows in the current execution time database through multi versioning....
Explain SQL; Several scenarios of index failure; SQL optimization several scenarios: mass insert; order by; group by; Limit the page; Insert operations; Nested query; Or...
Recently I read high Performance mysql. Although I haven't finished reading it yet, I think it's really well written. Mysql > create index (); mysql...
For MySQL8.0.28 installation tutorial, I have spent a day in the official MySQL documentation. Here is dedicated to beginners who want to start MySQL8.0. Take...
① What is an index on earth? (2) the implementation of the underlying index; What is the cluster index? Secondary indexes; ④ Left-most prefix principle;...
Non-repeatable read: When transaction A reads the same data multiple times, transaction B updates and commits the data. As A result, when transaction A reads...
Today I introduce a graduation project topic selection system based on JavaWeb. This system is based on JSP/SERVLET development, using JDBC connection operation database, database...
In this article, I summarize some of the most common MySQL exceptions thrown during the development process and how to resolve them, including high version...
What does the Binary Log do? If accidentally deleted data how to undertake recovery? If you want to do read/write separation, how do you synchronize...
1. Storage Engine Overview Unlike most databases, MySQL has a storage engine concept. You can select the optimal storage engine for different storage requirements. A...
This article focuses on some knowledge of MySQL indexes. Will be from the MySQL index foundation, index optimization practice and database index behind the data...
DATETIME and TIMESTAMP are common date/time data types in MySQL. Among them, DATETIME and TIMESTAMP are similar in appearance, but different in essence.