【MySQL 5.7 Reference Manual】15.4.5 System Tablespace(系统表空间)
来源:互联网 发布:浴霸哪个牌子好 知乎 编辑:程序博客网 时间:2024/06/05 03:09
15.4.5 System Tablespace(系统表空间)
The InnoDB system tablespace contains the InnoDB data dictionary (metadata for InnoDB-related objects) and is the storage area for the doublewrite buffer, the change buffer, and undo logs. The system tablespace also contains table and index data for any user-created tables that are created in the system tablespace. The system tablespace is considered a shared tablespace since it is shared by multiple tables.
InnoDB系统表空间包含了InnoDB数据字典(InnoDB相关对象的元数据)并且还是双写缓冲、变更缓冲和undo日志的存储区域。系统表空间也包含了系统表空间中任意用户表的表数据和索引数据。如果系统表空间被多个表所共享,那么它会被当作一个共享表空间。
The system tablespace is represented by one or more data files. By default, one system data file, named ibdata1, is created in the MySQL data directory. The size and number of system data files is controlled by the innodb_data_file_pathstartup option.
系统表空间表现为一个或多个数据文件。默认情况下,一个名为iddata1的系统数据文件被创建在MySQL数据目录中。数据文件的大小通过innodb_data_file_pathstartup选项来控制。
For related information, see Section 15.6.1, “InnoDB Startup Configuration”, and Section 15.7.1, “Resizing the InnoDB System Tablespace”.
更多相关信息,请参考15.6.1,“InnoDB启动配置”,和15.7.1,“重新调整InnoDB系统表空间的大小”。
0 0
- 【MySQL 5.7 Reference Manual】15.4.5 System Tablespace(系统表空间)
- 【MySQL 5.7 Reference Manual】15.4.11 Undo Tablespace(Undo表空间)
- 【MySQL 5.7 Reference Manual】15.4.12 Temporary Tablespace(临时表空间)
- 14.4.5 System Tablespace 系统表空间
- 【MySQL 5.7 Reference Manual】15.4.9 File-Per-Table Tablespaces(独立表空间)
- 【MySQL 5.7 Reference Manual】15.4.10 General Tablespaces(通用表空间)
- 什么是表空间(tablespace)和系统表空间(System tablespace)的区别?
- 【MySQL 5.7 Reference Manual】15.4 InnoDB Architecture(InnoDB架构)
- MySQL - 翻译 - 5.1 Reference Manual参考手册 - 5.1.3 Server System Variables服务器系统变量 - max_heap_table_size
- Mysql官方参考文档(MySQL 5.7 Reference Manual )
- 【MySQL 5.7 Reference Manual】15.4.12.1 InnoDB Temporary Table Undo Logs(InnoDB临时表Undo日志)
- 【MySQL 5.7 Reference Manual】15.4.1 Buffer Pool(缓冲池)
- 【MySQL 5.7 Reference Manual】15.4.2 Change Buffer(变更缓冲)
- 【MySQL 5.7 Reference Manual】15.4.3 Adaptive Hash Index(自适应哈希索引)
- 【MySQL 5.7 Reference Manual】15.4.4 Redo Log Buffer(Redo日志缓冲)
- 【MySQL 5.7 Reference Manual】15.4.6 InnoDB Data Dictionary(InnoDB数据字典)
- 【MySQL 5.7 Reference Manual】15.4.7 Doublewrite Buffer(双写缓冲)
- 【MySQL 5.7 Reference Manual】15.4.8 Undo Logs(Undo日志)
- 【JAVA 10.25】
- Binary Tree Level Order Traversal
- DOM特性
- pyqt远程批量执行Linux命令程序
- java 消息机制 ActiveMQ入门实例
- 【MySQL 5.7 Reference Manual】15.4.5 System Tablespace(系统表空间)
- Windows下cmd进入MySql的命令界面
- 【MySQL 5.7 Reference Manual】15.4.6 InnoDB Data Dictionary(InnoDB数据字典)
- MyEclipse开发Hibernate入门实例
- 用C++画表格
- 递归法之最长回文子序列(java)
- 【MySQL 5.7 Reference Manual】15.4.7 Doublewrite Buffer(双写缓冲)
- 基于opencv源程序的滑动条实现阈值变换
- day11 多线程