The index! It's a top priority. Interview is a must, of course, usually development for SQL optimization is also very important and when the practice...
Most detailed ever: a detailed explanation of the MySql database transaction isolation feature. Say transaction, you should be familiar with, when using MySql database, usually...
How to design a database with high concurrency? Java Advanced Interview question: Why separate databases and tables? Which sub-database sub-table middleware have you used? Different...
The locking range for primary key indexes and non-primary key unique indexes has been described. What is the range of normal indexes and normal fields?
1. Install the third-party MYSQL database module (MYSQL) 2. Connect to the mysql database through the mysql module. 3. Run the mysql statement NPM I...
MVCC is a variant of row-level locking, but it avoids locking in many cases and therefore costs less. Implementation mechanisms vary, but most implement non-blocking...
I recently read a book called "MySQL Technology Insider --InnoDB Storage Engine". I want to take notes for future review. This article focuses on B+...
InnoDB organizes data by primary key clustering by default, which makes primary key lookup more efficient. For frequently accessed data, InnoDB also creates hash indexes...
Trigger: Use scenario of trigger and corresponding version: This is my 26th day of participating in The August Update Challenge. For details, see: August Update...
A self-join is a special type of table join, which means that the interconnected tables are physically the same table, but logically multiple tables. Self-join...
1 Introduction to THE Json type MySQL 5.7 provides the Json type, which is designed by MySQL by combining structured and unstructured storage. In some...
IS, IX, MDL, record locks, gap locks, next-key locks, intent insert locks, auto-inc locks. Let's go through the interview practice to understand. Me, little Y....
Background: There is a call statistics log storage and statistics requirements, requiring storage in mysql; The peak storage data can reach tens of millions per...
As a data storage component, MySQL's main operation is to add, delete, change and check data, among which the query operation is the most important....
Introduction With the increasing number of system users, the importance of MySQL index is self-evident. For back-end engineers, only after they understand the index and...
Dirty read, magic read, unrepeatable read, current read, snapshot read, these terms often make people dizzy. Because the main line of ordinary people's brain is...
Hello everyone, as a developer, in the operation of relational database, often encounter index failure, resulting in slow query speed, query time is too long....