Transaction isolation means that when multiple threads concurrently access the database, the database will open a separate transaction for each thread, and each transaction will...
Undo Log,Redo Log, and Binlog MySQL isolation levels, consistency view, Undo Log,Redo Log, and binglog MySQL index structure, back table, left-most prefix principle MySQL related...
Slow query enablement and temporary query enablement Set Global slow_query_log=1 The default slow_query_log times out for 10s. Permanently enable slow queries in the my.cnf file...
Generally speaking, MYSQL can be divided into two parts: Server layer and storage engine layer. The Server layer includes connectors, query caches, analyzers, optimizers, actuators,...
Mysql > alter table auto_increment mysql > alter table auto_increment mysql > alter table auto_increment mysql > alter table auto_increment mysql > alter table auto_increment...
This section is very important. Query operations are performed on data table data. Some complex queries, such as INNER JOIN, LEFT JOIN and RIGHT JOIN,...
Mysql > select * from 'Mysql'; There was an insert on Duplicate deadlock problem online before. Based on this deadlock problem, this paper will share...
Innodb-type storage engines write data to disk. InnoDB generates table names, FRM, and idB files in the corresponding Mysql storage directory. InnoDB reads data from...
Through learning MySQL output notes, before learning MySQL system, first have a general understanding of the overall architecture. A, SQL execution process is what? MySQL...
Mysql isolation level this section involves many concepts, many times in various places have seen some statements, for their scenarios and solve the problem is...
This paper, from the introduction of MySQL, architecture, optimization means, and the processing of Golang connection pool and other dimensions, will explain how Gopher uses...
Preface An excellent database, must involve persistence, persistence, there will be data fall disk operation. There is a drop disk operation is bound to have...
Transaction definition transaction: a smallest non-divisible unit of work; A transaction usually corresponds to a complete business, such as a bank account transfer, which is...
Figure 1. SQL statement optimization Enable the slow query function 1) Check the status of all logs: show variables like '%quer%'; 2) Show variables like...
This article has participated in the "Digitalstar Project" and won a creative gift package to challenge the creative incentive money. This article is mainly about...