Differences between binary and redo logs in MySQL database

First: The binary log logs all mysql-related log records, including InnoDB MyISAM heap, and other engine logs. The redo log for the InnoDB engine only records the transaction log associated with it.

Second: The content of the record is different, whether you set the binary log file format to statement or row, or mixed, its record is about a thing specific operation content. While the redo log file of the InnoDB storage Engine records the changes in the House of each page (pages).

In addition, the time to write is different, and the binary log file is recorded before the thing is committed, and the process of doing it, regardless of whether a redo log entry is written to the redo log.

Differences between binary and redo logs in MySQL database