MySQL
MySQL - 翻译 - 5.1 Reference Manual参考手册 - 5.1.3 Server System Variables服务器系统变量 - max_heap_table_sizemax_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
默认值
16777216Range
范围
16384-4294967295
This variable sets the maximum size to whichMEMORY tables are allowed to grow. Thevalue of the variable is used to calculateMEMORY table MAX_ROWSvalues. Setting this variable has no effect on any existingMEMORY table, unless the table isre-created with a statement such asCREATE TABLE or altered withALTER TABLE orTRUNCATETABLE. A server restart also sets the maximum sizeof existing MEMORY tables to the globalmax_heap_table_size value.
该变量设置MEMORY(HEAP)表可以增长到的最大空间大小。该变量用来计算MEMORY表的MAX_ROWS值。在已有的MEMORY表上设置该变量没有效果，除非用CREATETABLE重新创建表或使用ALTER TABLE修改或TRUNCATETABLE。重新启动服务器也将设置已存在的MEMORY表的最大尺寸为全局max_heap_table_size值。
Note
注意
On 64-bit platforms, the maximum value for this variable is1844674407370954752.
在64位平台上，该变量的最大值是1844674407370954752.
MySQL Enterprise.Subscribers to the MySQL Enterprise Monitor receiverecommendations for the optimum setting formax_heap_table_size. Formore information, seehttp://www.mysql.com/products/enterprise/advisors.html.
MySQL企业版，定购MySQL企业版监视器将收到max_heap_table_size的优化值的推荐值。更多信息参见http://www.mysql.com/products/enterprise/advisors.html.
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#server-system-variables
http://www.mysql.com/
mysql
http://dev.mysql.com/downloads/
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.Dateand Time Functions日期和时间函数 - FROM_UNIXTIME将UNIX时间戳格式化为日期,http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime
12SQL Statement Syntax - SQL语句语法 - 12.8 MySQL Compound-Statement Syntax -MySQL复合语句语法 - 12.8.6 Flow Control Constructs流程控制结构 -12.8.6.2. CASEStatement - 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
页:
[1]