2.4.5 MySQL InnoDB重做与回滚介绍

MySQL InnoDB Redo 与 Undo

redo log重做日志介绍

redo log重做日志的由来

如何写 redo log重做日志的呢

log buffer 往 log file里写 redo log的触发机制

redo log 的特点

undo log 介绍

重做日志文件查看

mysql root@localhost:(none)> show variables like '%undo%'
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| innodb_max_undo_log_size | 1073741824 |
| innodb_undo_directory    | ./         |
| innodb_undo_log_truncate | OFF        |
| innodb_undo_logs         | 128        |
| innodb_undo_tablespaces  | 0          |
+--------------------------+------------+