Understanding MySQL log redo, undo, binlog 1. Problems solved by MySQL log files 2. redo log 2.1. Composition of redo log 2.2. Redo log flushing strategy 2.3. What problems does MySQL’s redo log solve? 3. undo log 3.1. Function of undo log 3.2. Types of undo log 3.3. Life cycle of undo log 3.4. Several […]
Tag: redo
Oracle (7) Online Redo Log Files
Table of Contents 1. Introduction to Oracle Online Redo Log Files and related content 1. Introduction to Online Redo Log Files 2. Features of Online Redo Log Files 3. Online Redo Log Files file group 4. Multiplexed files 5. How online redo log files work 6. When will LGWR be written and redone? 7. LS […]
MySQL Performance Optimization Guide: In-depth analysis of the mechanism of flushing redo logs to disk
Article directory MySQL Redo Log Performance Optimization Guide The impact of redo logs on database performance Mechanism for flushing redo logs to disk Practical use 1. Confirm MySQL redo log configuration 2. Force redo log refresh 3. Check whether the redo log has been flushed to disk Performance Optimization Guide 1. Place redo log files […]
MySQL’s three major logs undolog, redolog and binlog
In MySQL, many functions also need to be implemented based on logs, such as transaction rollback, data persistence, data recovery, data migration, and MVCC mechanism. Among them, undolog and redolog are both logs in the InnoDB engine, and they are both in the Buffer Pool, while binlog is in the Server layer and is located […]
Kingbase V8R3 streaming replication switch recovery redo standby machine
Streaming replication switch recovery Cluster database node A main library – node1 B standby database – node2 C standby library – node3 Streaming replication database ● Confirm that the database process has been started Check whether the database process of each node is normal ps -ef | grep kingbase ● Confirm that the main and […]
Binlog and Redo log in MySQL
Why is there redo log Generally, when MySQL updates data, there are two situations: appending data or locating an existing piece of data for modification. However, disk random read and write speeds are very slow and cannot meet high IO operation scenarios. In order to improve writing efficiency, generally we can write the data to […]
undo log and redo log
Main reference blogs: https://blog.csdn.net/yu757371316/article/details/81081669 In a database system, there are both files that store data and files that store logs. The log also has a cached Log buffer in the memory and a disk file log file. This article mainly describes the file that stores the log. There are two types of log files in […]
mysql technical documentation–and redo log (redo log) Pao Ding analysis-super exploration! ! !
Adan: When I first started writing this article, I wasn’t quite sure how to go through these two systems in detail. In the process of reviewing the information. I found that Alibaba’s Chef Ding explained the InnoDB series in detail and wrote a lot of underlying knowledge, so based on these two articles, I came […]
How to implement UNDO in SQL SERVER Are REDO and PostgreSQL closely related?
Let me introduce the group at the beginning. If you are interested in PolarDB, MongoDB, MySQL, PostgreSQL, SQL Server, Redis, Oracle, Oceanbase, etc. If you have any questions or need, you can join the group. There are big names and CTOs in the major database industry in the group, who can solve your problems. The […]
MySQL log system: binlog, redo log and undo log
Logs are an important part of the MySQL database. Operations such as data persistence, master-slave replication, and data rollback all rely on the log system. This article will introduce three types of logs in MySQL: archive log binlog, redo log redo log and rollback log undo log. binlog archive log What is binlog Binary log […]