2.4.5 MySQL InnoDB重做与回滚介绍

MySQL InnoDB Redo 与 Undo

redo log重做日志介绍

321324421

321523671

redo log重做日志的由来

321589109

321761296

如何写 redo log重做日志的呢

327751984

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

327846109

328343890

redo log 的特点

328361218

328510984

undo log 介绍

328688109

328737218

重做日志文件查看

328745109

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          |
+--------------------------+------------+
posted @ 2020-09-13 16:42  元贞  阅读(419)  评论(0编辑  收藏  举报