【MySQL 5.7 Reference Manual】15.4.12 Temporary Tablespace(临时表空间)
来源:互联网 发布:大数据全套视频教程 编辑:程序博客网 时间:2024/06/14 21:20
15.4.12 Temporary Tablespace(临时表空间)
15.4.12.1 InnoDB Temporary Table Undo Logs(InnoDB临时表空间Undo日志)
The temporary tablespace, introduced in MySQL 5.7.1, is a tablespace for non-compressed InnoDB temporary tables and related objects. The configuration option, innodb_temp_data_file_path, defines a relative path for the temporary tablespace data file. If innodb_temp_data_file_path is not defined, a single auto-extending 12MB data file named ibtmp1 is created in the data directory. The temporary tablespace is recreated on each server start and receives a dynamically generated space ID, which helps avoid conflicts with existing space IDs. The temporary tablespace cannot reside on a raw device. Startup is refused if the temporary tablespace cannot be created.
临时表空间,在MySQL 5.7.1中被引入,该表空间用于存放非压缩状态的InnoDB临时表和相关对象。配置项innodb_temp_data_file_path定义了临时表空间数据文件的相关路径。如果innodb_temp_data_file_path未定义,一个单独自动扩展大小为12MB名为ibtmp1的数据文件会被创建在数据目录中。任何一个服务启动时临时表空间都会被重建并接收一个动态生成的空间ID,这样可以帮助避免与已存在的空间ID冲突。临时表空间不可以驻留在一个原始设备上。如果临时表空间无法创建,那么启动将被拒绝。
The temporary tablespace is removed on normal shutdown or on an aborted initialization. The temporary tablespace is not removed when a crash occurs. In this case, the database administrator may remove the temporary tablespace manually or restart the server with the same configuration, which removes and recreates the temporary tablespace.
在服务正常关闭或初始化失败时表空间会被删除。当崩溃发生时临时表空间不会被删除。在这种情况下,数据库管理员可以手动删除临时表空间或用相同的配置重启服务,这样就会删除并重建临时表空间。
0 0
- 【MySQL 5.7 Reference Manual】15.4.12 Temporary Tablespace(临时表空间)
- 【MySQL 5.7 Reference Manual】15.4.5 System Tablespace(系统表空间)
- 【MySQL 5.7 Reference Manual】15.4.11 Undo Tablespace(Undo表空间)
- 临时表空间(Temporary Tablespace)相关
- 【MySQL 5.7 Reference Manual】15.4.12.1 InnoDB Temporary Table Undo Logs(InnoDB临时表Undo日志)
- Oracle (temporary tablespace)临时表空间说明
- Oracle表空间 - 临时表空间Temporary Tablespace
- Oracle10g新特性:临时表空间组(temporary tablespace group)
- Oracle10g新特性:临时表空间组(temporary tablespace group)
- 【MySQL 5.7 Reference Manual】15.4.9 File-Per-Table Tablespaces(独立表空间)
- 【MySQL 5.7 Reference Manual】15.4.10 General Tablespaces(通用表空间)
- 删除ORACLE的临时表空间报错:ORA-12906: cannot drop default temporary tablespace
- 【MySQL 5.7 Reference Manual】15.4 InnoDB Architecture(InnoDB架构)
- mysql (create temporary table table_name )临时表创建
- Mysql官方参考文档(MySQL 5.7 Reference Manual )
- mysql存储过程----临时表 temporary
- 【MySQL 5.7 Reference Manual】15.4.1 Buffer Pool(缓冲池)
- 【MySQL 5.7 Reference Manual】15.4.2 Change Buffer(变更缓冲)
- 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日志)
- Context与ActivityManagerService
- 数据结构-哈夫曼(Huffman)
- 四道Java基础题 你能对几道?
- 【MySQL 5.7 Reference Manual】15.4.13 Redo Log(Redo日志)