As for MySQL, only by more comprehensive understanding of each process of SQL statement execution can WE better design and optimize SQL. When you want...
Use the EXPLAIN keyword to simulate the optimizer's execution of SQL queries to see how MySQL handles your SQL statements. Analyze performance bottlenecks in your...
In the process of data operation, data errors and even database crash may occur. Effective periodic backup can protect the database well. This article mainly...
Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". A union can merge tables from more than...
Sharding's basic idea is to divide a database into multiple parts and put them into different databases (servers), so as to alleviate the performance problems...
This article has participated in the "Digitalstar Project" and won a creative gift package to challenge the creative incentive money. Since the release of the...
This article explains the Mysql primary key problem, from the perspective of why to understand the Mysql primary key related knowledge, and expand to the...
This article will not explain the basic knowledge of index, mainly about the MySQL database b-tree index related principles, some of the knowledge in the...
I don't know why mysql doesn't work... Common in statistical occasions, such as column calculation of the number of posts, statistics of the average score...
Supports SQL syntax common to MySQL, Oracle, DB2, SQL Server, and PostgreSQL databases. Automatic failover based on heartbeat, read/write separation, MySQL master-slave architecture, and Galera...
This article is based on the sharing by Huang Wei, senior database architect of WeBank in PingCAP DevCon 2021. It mainly describes the application practice...
The article "MySQL query Analysis" describes how to use MySQL slow query and explain commands to locate MySQL performance bottlenecks. After locating SQL statements that...
This article has participated in the "Digitalstar Project" and won a creative gift package to challenge the creative incentive money. When do you need to...
This article has participated in the "Digitalstar Project" and won a creative gift package to challenge the creative incentive money. This article mainly tells about...
Index types include B-tree, hash index, R-tree, and full-text index. This section summarizes b-tree and hash index. Before we talk about indexes, we have to...
Introduction In our daily work, we execute a simple query statement: Architecture First, the MySQL architecture can be divided into two parts: Server layer and...