Click on the top of the "flathead brother's technical blog", choose "concern public number" technical articles first time delivery! As a Java developer, it's common...
MySQL actually uses different storage engines are also very different, the following friends can understand. Note: The above mentioned b-tree index does not indicate b-tree...
Daily server development, in the process of table relations slightly complex applications, or do query performance optimization, the use of ORM tool library processing associated...
Most of Mysql's transactional storage engines are not simple row-level locking. Mysql is not the only database that supports MVVC. Orcale, PostgreSql and others implement...
It's all success or all failure. MySQL implements atomicity by logging undo_log. Undo_log is a rollback log. The undo_log is written to disk before the...
A non-relational database is not strictly a database, but rather a collection of structured storage methods for data, either document or key-value equivalence. The most...
Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". This paper will analyze the advantages and disadvantages...
Click on the top of the "flathead brother's technical blog", choose "concern public number" technical articles first time delivery! We covered redo logging, which you...
In order to solve the problem that the database performance is reduced due to the large amount of data, the original independent database is divided...
When it comes to multi-data sources, what problems are generally solved? The master/slave mode or business is complex and different sub-libraries need to be connected...
In the last article, I published the process of setting up the MySQL master-slave replication cluster, but it seems that my friends are not interested...
Undo Log is to achieve atomicity of transactions. In MySQL database InnoDB storage engine, Undo Log is also used to achieve multi-version concurrency control (referred...
The development language used by the company is PHP Laravel framework, operation through PHP Artisan Migrate, the database is abnormal, then execute this SQL statement,...
In daily work, there are always things like hand shaking, writing wrong conditions, writing wrong table names, and mistakenly deleting database tables and data. However,...
Synchronous replication is a process in which the binlog has been sent to the slave database through the dump thread after the master database commits...
If you look at the position of Java engineer advertised by Alibaba Cloud, you will find that "students who have passed the alibaba code specification...