账号密码登录
微信安全登录
微信扫描二维码登录

登录后绑定QQ、微信即可实现信息互通

手机验证码登录
找回密码返回
邮箱找回 手机找回
注册账号返回
其他登录方式
分享
  • 收藏
    X
    Mysql innodb的undo log和read view
    57
    0

    Undo log到底是个什么日志?
    每条记录被多个事务更改的记录都放到这个undo log中么? 还是说每条记录都有自己的undo log?

    还有read view, 到底啥用,和undo log怎么关联起来用的?

    0
    打赏
    收藏
    点击回答
        全部回答
    • 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.

    更多回答
    扫一扫访问手机版
    • 回到顶部
    • 回到顶部