What is the concept of redo log in mysql
- 王林forward
- 2023-05-26 18:52:251076browse
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#
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!
Statement：
This article is reproduced at:yisu.com. If there is any infringement, please contact admin@php.cn delete
Previous article：How to use regular expressions in MySQLNext article：How to use regular expressions in MySQL