This article mainly focuses on the use, detailed introduction of how to parse a SQL statement and SQL rewriting and other advanced operations, SQL parsing...
We know that 'data pages' form a' bidirectional linked list 'through pointer connection, imagine, if there is no index, only rely on this' bidirectional linked...
This paper mainly analyzes the coupon function related table, using the form of database table and function comparison. Mall project full set of learning tutorials...
The SQL statement executed in the test environment was put into the production database. As a result, the production core database table was deleted. Next,...
This article combines 18 hand-drawn legends, 21 SQL classic cases, nearly 10000 words, will be summed up Mysql index optimization experience, you can decide whether...
Lua is a small scripting language. A team of researchers at the Pontifical Catholic University of Rio de Janeiro in Brazil By Roberto Ierusalimschy, Waldemar...
Two case studies demonstrate the power of the MySQL performance analysis tool Explain. Details the meaning of the most important type field (connection type) in...
This paper mainly aims at small and medium-sized applications or websites, focusing on the optimization of SQL statements in daily program development. The so-called "big...
Client services are not unique to mysql, most web-based client/server tools have them. Each client connection has a thread in the server process, and queries...
MySQL's InnoDB storage engine is known to support transactions, with row locks by default. Thanks to these features, databases support high concurrency. What if InnoDB...
This article will briefly introduce the lock in MySQL database, lock level, read and write lock, etc., there are about lock competition, lock problems, and...
Sum (), count(), avg(), Max (), and so on are aggregate functions, which operate on multiple statements. 1) Group by, must have "aggregate function" to...
MySQL has introduced multi-library parallel master/slave replication since 5.6, but the parallelism is only Schema based, that is, library based. If the user has multiple...
This article mainly summarizes the work of some common operations and unreasonable operations, in the slow query optimization to collect some useful information and information,...
Physical backup: Back up the complete database directory and data files. In this mode, a large number of I/O operations are performed, but no logical...
Database read-write separation is a development stage that many companies cannot get around, from single database, to master/standby mode, and then to read-write separation, separate...
The isolation level of the database is always mentioned in every interview or technical sharing related to the database. Do you really understand the characteristics...