InnoDB is a general-purpose storage engine that balances high reliability and high performance. It is a transactional storage engine and is fully ACID compliant, as would be expected from any relational database. The durability guarantee provided by InnoDB is made possible by the redo logs.
This article will provide an overview of the redo log subsystem or log subsystem of InnoDB. We will look at the following details:
- The global log system object, which provides access to important data structures and information.
- The mini-transaction (mtr), using which all redo log records are created.
- The global in-memory log buffer (or just log buffer), into which the redo logs are written to from the mini transaction buffer. This log buffer will be periodically flushed to the log file on disk. …