
InnoDB
Concepts
A mini-transaction is an atomic
set of page reads or writes,
with write-ahead redo log.
A transaction writes undo log
before modifying indexes.
The read view of a transaction
may access the undo logs of
newer transactions to retrieve
old versions.
Purge may remove old undo logs
and delete-marked records
once no read view needs them.
Some terms that an Advanced
DBA should be familiar with
评论