【MySQL 5.7 Reference Manual】15.4.11 Undo Tablespace(Undo表空间)
来源:互联网 发布:百胜厨 知乎 编辑:程序博客网 时间:2024/05/22 01:30
15.4.11 Undo Tablespace(Undo表空间)
An undo tablespace comprises one or more files that contain undo logs. Undo logs exist within undo log segments, which are contained within rollback segments. By default, rollback segments are physically part of the system tablespace. However, rollback segments can reside in separate undo tablespaces. An undo tablespace is created when the undo log is separated from the system tablespace using the innodb_undo_tablespaces and innodb_undo_directory configuration options.
一个undo表空间由一个或多个包含undo logs文件组成。Undo日志存在于undo日志段中,而undo日志段被包含在回滚段中。在默认情况下,回滚段物理上是系统表空间的一部分。然而,回滚段可以驻留在单独的undo表空间中。当使用innodb_undo_tablespaces和innodb_undo_directory配置项将undo日志从系统表空间中独立出来时,会创建一个undo表空间。
For more information, see Section 15.7.7, “Storing InnoDB Undo Logs in Separate Tablespaces”.
更多信息,请参考15.7.7,“在单独的表空间中存储InnoDB Undo日志”。
0 0
- 【MySQL 5.7 Reference Manual】15.4.11 Undo Tablespace(Undo表空间)
- 【MySQL 5.7 Reference Manual】15.4.8 Undo Logs(Undo日志)
- 【MySQL 5.7 Reference Manual】15.4.12.1 InnoDB Temporary Table Undo Logs(InnoDB临时表Undo日志)
- 【MySQL 5.7 Reference Manual】15.4.5 System Tablespace(系统表空间)
- 【MySQL 5.7 Reference Manual】15.4.12 Temporary Tablespace(临时表空间)
- UNDO Tablespace
- undo tablespace
- UNDO TABLESPACE
- 删除undo表空间时,表空间被占用:ORA-30042: Cannot offline the undo tablespace
- 如何处理undo tablespace 表空间太大的问题
- undo表空间不足,ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2'
- undo表空间不足,ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2'
- 查看undo tablespace空间的大小
- 【MySQL 5.7 Reference Manual】15.4.9 File-Per-Table Tablespaces(独立表空间)
- 【MySQL 5.7 Reference Manual】15.4.10 General Tablespaces(通用表空间)
- UNDO表空间与Undo的认识
- 重置UNDO 表空间.
- 监控Undo表空间
- 独立看门狗
- Angluar2报错记录(持续更新...)
- MySql存储过程
- 数据结构-队列(Queue)
- FragmentManager与FragmentTransaction
- 【MySQL 5.7 Reference Manual】15.4.11 Undo Tablespace(Undo表空间)
- opencv实现滑动条控制图片的对比度和亮度变换
- Stm32 - Printf重定向(不)使用微库(Keil MDK)
- Codeforces 421D
- 【MySQL 5.7 Reference Manual】15.4.12 Temporary Tablespace(临时表空间)
- textarea标签输出内容时不能顶格(左对齐)输出
- 2016年的回顾
- Windows系统,得知端口杀掉进程
- 【MySQL 5.7 Reference Manual】15.4.12.1 InnoDB Temporary Table Undo Logs(InnoDB临时表Undo日志)