With the development of the company's business, the commodity inventory has become an independent system from the commodity center, which undertakes the main station commodity...
1. Server layer of MySQL basic architecture: it mainly includes connector, query cache, analyzer, optimizer, executor, etc., as well as the general binlog module.
First, before talking about this issue, I would like to briefly explain my understanding of MySql architecture and the execution process of SQL statements. This...
There are many kinds of database engines, such as relational database, graph database, mesh database, hierarchical database, in-memory data and so on, many of which...
Single-table optimization optimizes the left prefix: keeps the order consistent with the composite index definition. Place range queries containing in at the end of where...
1. Overview The reason why the previous chapter introduces so many knowledge points and examples of locks, in fact, the ultimate purpose is to troubleshoot...
Process state analysis Explain shows how mysql uses indexes to process SELECT statements and join tables. Parameter Meaning IdPROCESS Id. ProcessId unique identifier of the...
The source of all technical implementations is product requirements, and a single requirement change in a product can magnify large-scale changes at the top of...
Problems solved by master/slave replication Data distribution: Data is distributed to different geographical locations by replication Load balancing: read/write separation and read load to multiple...
Innodb storage engine sorting is divided into two categories, index sorting and file sorting, index sorting efficiency is definitely better than file sorting, so please...
This paper introduces the principle of B+Tree index, clustering index, auxiliary index, joint index and so on have a clear understanding, and then introduces the...
This section discusses the optimizations that can be made to handle the WHERE clause. These examples use SELECT statements, but the same optimization applies to...
Structured Query Language - Structured Query Language. A language designed specifically to manipulate relational databases. Data Definition Language (DDL) - Operates databases and tables. Data...
Database logical backup is the backup software in accordance with the initial design of the logical relationship, the logical structure of the database object as...