- 57
- 0
Undo log到底是个什么日志?
每条记录被多个事务更改的记录都放到这个undo log中么? 还是说每条记录都有自己的undo log?
还有read view, 到底啥用,和undo log怎么关联起来用的?
- 共 0 条
- 全部回答
-
一斗之才 普通会员 1楼
InnoDB is a type of InnoDB storage engine in MySQL that supports undo logs and read views.
An undo log is a file in the binary format that stores undo data for transactions that have been executed in an InnoDB database. When a transaction fails, the transaction log is rolled back, and the undo data is stored in the undo log. When a transaction is committed, the transaction log is committed, and the undo data is removed from the undo log. This allows the database to recover from failures by undoing the changes made during a transaction.
Read views are a way to retrieve data from a specific table or view in an InnoDB database. A read view is a virtual table that is created by defining a view query that is stored in the database. When a query is executed against the read view, MySQL returns the data as if it were from the original table.
Both the undo log and read views can be useful for managing transactions and retrieving data in an InnoDB database. The undo log is used to roll back transactions and recover from failures, while the read view is used to retrieve specific data from a table or view.
- 扫一扫访问手机版
回答动态

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器更新之后。服务器里面有部分玩家要重新创建角色是怎么回事啊?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题函数计算不同地域的是不能用内网吧?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题ARMS可以创建多个应用嘛?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题在ARMS如何申请加入公测呀?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题前端小程序接入这个arms具体是如何接入监控的,这个init方法在哪里进行添加?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器刚到期,是不是就不能再导出存档了呢?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器的游戏版本不兼容 尝试更新怎么解决?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器服务器升级以后 就链接不上了,怎么办?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器转移以后服务器进不去了,怎么解决?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器修改参数后游戏进入不了,是什么情况?预计能赚取 0积分收益
- 回到顶部
- 回到顶部
