In high concurrency scenarios, without considering other middleware, the database will have the following scenarios: Read: There are no problems and no concurrency control is...
As we all know, there is a very important and effective optimization in database query optimization, which is index optimization. In many cases, if the...
1: index failure scenario 1.1: index calculation 1.2: inconsistent with leftmost prefix rule 1.3: Improper use of like, etc.2: Why index failure (single index)
After the server receives the request from the client, it also needs to go through query caching, lexical parsing and pre-processing, and query optimization. This...
The transaction and isolation levels in MySQL have been covered in detail in previous articles, and MVCC is designed to efficiently avoid the problems (dirty...
Taking a query as an example, let's take a look at how MySQL handles a query. MySQL is a typical C/S architecture (client/server architecture) where...
MySQL high Availability Architecture: Master/slave Backup To prevent database crashes, we need to implement a high availability architecture for the database
In the last article, Songo shared two rules for using indexes: Don't use functions on indexes. Use overwrite indexes to avoid back tables. Of course,...
The EXPLAIN keyword can be used to obtain information about the execution plan of SQL statements. In MySQL 8.0, EXPLAIN supports most SQL statements, such...
This article mainly shares a practical requirement encountered in the work is how to solve step by step. How does this requirement convert multiple rows...
With the progress of society and the development of science and technology, more and more people pursue novel and unique, practical living and working environment....