MySQL - 翻译 - 5.1 Reference Manual参考手册 - 5.1.3 Server System Variables服务器系统变量 - max_heap_table_size

max_heap_table_size

Option Sets Variable
选项集变量

Yes, max_heap_table_size
是


Variable Name
变量名

max_heap_table_size


Variable Scope
变量可见性

Both
两者

Dynamic Variable
动态变量

Yes
是

Value Set
值集

Type 类型	numeric 数字
Default 默认值	16777216
Range 范围	16384-4294967295

This variable sets the maximum size to which MEMORY tables are allowed to grow. The value of the variable is used to calculate MEMORY table MAX_ROWS values. Setting this variable has no effect on any existing MEMORY table, unless the table is re-created with a statement such as CREATE TABLE or altered with ALTER TABLE or TRUNCATE TABLE. A server restart also sets the maximum size of existing MEMORY tables to the global max_heap_table_size value.

该变量设置MEMORY (HEAP)表可以增长到的最大空间大小。该变量用来计算MEMORY表的MAX_ROWS值。在已有的MEMORY表上设置该变量没有效果，除非用CREATE TABLE重新创建表或使用ALTER TABLE修改或TRUNCATE TABLE。重新启动服务器也将设置已存在的MEMORY表的最大尺寸为全局max_heap_table_size值。

Note
注意

On 64-bit platforms, the maximum value for this variable is 1844674407370954752.

在64位平台上，该变量的最大值是1844674407370954752.

MySQL Enterprise. Subscribers to the MySQL Enterprise Monitor receive recommendations for the optimum setting for max_heap_table_size. For more information, see http://www.mysql.com/products/enterprise/advisors.html.

MySQL企业版，定购MySQL企业版监视器将收到max_heap_table_size的优化值的推荐值。更多信息参见http://www.mysql.com/products/enterprise/advisors.html.

[MySQL - 5.1 Reference Manual参考手册 - 5.1.3 Server System Variables服务器系统变量 - max_heap_table_size - 文档]

http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#server-system-variables

[MySQL - 官方网站]

http://www.mysql.com/

[MySQL - 关键词]

mysql

[MySQL - 相关论坛]

[MySQL - 下载]

http://dev.mysql.com/downloads/

[MySQL - 5.1 Reference Manual参考手册]

MySQL - 5. 数据库管理 - 5.3. mysqld：MySQL服务器 - 5.3.3. 服务器系统变量 - max_allowed_packet, http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#server-system-variables

MySQL - 5.1 Reference Manual参考手册 - 5.1.3 Server System Variables服务器系统变量 - max_heap_table_size - 文档, http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#server-system-variables

9. 语言结构 - 9.2. 数据库、表、索引、列和别名 - 9.2.2. 识别符大小写敏感性, http://dev.mysql.com/doc/refman/5.1/zh/language-structure.html#name-case-sensitivity

11.6.Date and Time Functions日期和时间函数 - FROM_UNIXTIME将UNIX时间戳格式化为日期, http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime

12 SQL Statement Syntax - SQL语句语法 - 12.8 MySQL Compound-Statement Syntax - MySQL复合语句语法 - 12.8.6 Flow Control Constructs流程控制结构 -12.8.6.2. CASE Statement - CASE语句, http://dev.mysql.com/doc/refman/5.1/en/case-statement.html
13. SQL语句语法 - 13.1.数据定义语句 - 13.1.5.CREATE TABLE语法, http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#create-table