MySQL redolog, binlog, undolog

I may have simply heard of such a few concepts before, but I didn’t study them in detail. Just today saw 45 talk, a little summary ~

Redolog and binlog

• Redo log is unique to the InnnoDB engine; Binlog is an implementation of MySQL on the server layer and is available to all engines.
• Redo logs are physical logs of what changes were made on which data pages. A binlog is a logical log that records the original logic of the statement, such as the specific SQL statement executed.
• Log files ib_logfile0 ib_logfile1 in MySQL data are written to 0, 1, and then 0. The binlog is appended. When a file is written to a certain size, it switches to the next one without overwriting the previous log.