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: undo
git undo operation all
Concept Workspace: that is, the code modified by your current branch, before git add xx! Excludes git add xx and git commit xxx. Staging area: git add xxx has been added, but git commit xxx has not been done. Local branch: git commit -m xxx has been submitted to the local branch. Chapter 1: Description […]
Part10-1 Managing Undo Data
1. What isundo Every Oracle database must have a method of maintaining information that is used to roll back, or undo, changes to the database. Such information consists of records of the actions of transactions, primarily before they are committed. Oracle refers to these records collectively as undo. Main uses of Undo information: lRoll back […]
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 […]
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 […]
An undocumented container escape method
An undisclosed container escape method Author: Nitro@360GearTeam Background Recently, an unpublished container escape method was discovered. When a container shares the host PID namespace and runs with uid 0 (the user namespace is not enabled and no additional capabilities are added), the of certain processes can be exploited. /proc/[pid]/root symbolic link implements container escape. Analysis […]
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 […]
QT: Use redo and undo to realize undo shortcut keys
Goal: Add undo and undo shortcut keys in the interface Substance: The essence of undo is to use the stack. Pushes a redo and undo each time. The current operation is recorded in redo, and the last operation is recorded in undo. When the withdrawal is performed, the redo and undo pushed last time are […]
MySQL’s three major log logs: undo log, redo log, binlog
Directory A SQL execution process Why do you need undo log? How is the undo log flushed (persisted to disk)? Why do you need Buffer Pool? What does the Buffer Pool cache? What is the Undo page for? To query a record, do we only need to buffer one record? Why is redo log needed? […]