Under the MVCC mechanism, Redo Log and Bin Log are mainly useful at transaction commit time and their roles and trigger timing are as follows:

Logging behavior during transaction execution

When executing:

UPDATE users SET age = 26 WHERE id = 1;

MySQL’s transaction execution order (combined with MVCC + logging) is as follows:

Man’s physical body is the past and his consciousness is the present and future.