Home > Database > Mysql Tutorial > What is the concept of redo log in mysql

What is the concept of redo log in mysql

王林
Release: 2023-05-26 18:52:25
forward
1185 people have browsed it

1. Redo log is a log unique to the MySQLEngine layer and InnoDB storage engine. Also called redo log.

2. Redo log is a physical log. It can be understood as a queue with a fixed space size that will be copied cyclically.

Example

root@test:/var/lib/mysql# pwd
/var/lib/mysql
root@test:/var/lib/mysql# ls -lstr ib_logfile*
49152 -rw-r----- 1 mysql mysql 50331648 Dec 28 15:45 ib_logfile1
49152 -rw-r----- 1 mysql mysql 50331648 Jan  3 12:53 ib_logfile0
root@test:/var/lib/mysql# du -sh ib_logfile*
48M ib_logfile0
48M ib_logfile1
root@test:/var/lib/mysql#
Copy after login

The above is the detailed content of What is the concept of redo log in mysql. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template