Mysql introduction: mysql is one of the most popular relational database software, because of its small size, fast, open source free, easy to use, low...
Innodb storage engine Index Innodb storage engine has the following three indexes B+ tree index Full-text index hash index Hash index in The Innobd storage...
SQL select statement complete execution order? 1. The FROM clause assembles data from different sources; 2. The WHERE clause filters rows based on the specified...
Download and install the visual operation database software: Navicat (3) Configure the connection between Navicat and MySQL, connect to MySQL--, MySQL--, enter the user name...
Installation Environment: Centos 7.xmysql 8.0.23 download the MySQL database Installation Preparations for the MySQL database Installation Step 4 Set the startup after the system is...
Relational database itself is relatively easy to become the system bottleneck, single storage capacity, connection number, processing capacity are limited. When the amount of data...
After the analysis of update statement execution, we know that InnoDB storage engine contains buffer pool buffer pool, redo log buffer buffer buffer data, undo,...
Today, database operations are becoming a performance bottleneck for the entire application, especially for Web applications. Database performance is not just something for DBAs to...
The corresponding relation table between column values and record rows established in a certain order according to one or several columns in the table is...
Explain how to write efficient SQL statements. This article will Explain what an execution plan is and how to write efficient SQL statements. The execution...
In the interview, when exchanging questions about mysql indexes, I found that some people could tell the difference between B+ tree and B tree, balance...
Mysql is a common DB choice for background development students, with fast speed, easy to use, of course, more important is open source, the follow-up...
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...
This article uses Docker to achieve mysql master/slave synchronization/read-write separation, of course, you can also open two virtual machines to build, the method is the...
Start with one map and make up the rest. Single-process multi-threaded architecture Now the mainstream architecture has been single-process multi-threaded, and another big guy Oracle...
Transaction 1 executes before transaction 2. READ COMMITTED The isolation level resolves dirty reads, but it does not seem to resolve dirty reads under the...
Avoid introducing functions and calculations in WHERE statements such as SQL: Select count(*) from t where unix_timestamp(sync_dt) >= 1539101010 Except that using functions causes indexes...
Optimize is a way to respond more quickly to requests while ensuring that the system is correct. Moreover, some performance problems, such as slow queries,...
JDBC (Java DataBase Connectivity) is a Java API for executing SQL statements. It provides unified access to multiple relational databases. It consists of a set...