读Effective Mysql:optimizing SQL Statements 札记之max_heap_table_size
日期：2014-05-16 浏览次数：20885 次
读Effective Mysql:optimizing SQL Statements 笔记之max_heap_table_size
The total size of a MEMORY storage engine table can be determined by the SHOW TABLE STATUS command and the INFORMATION_SCHEMA.TABLES table.
For additional reference, a MEMORY storage engine table used a fixed width value for any character columns. In the receding example,the VARCHAR(1000) column is effectively a CHAR(1000) column when defined in a MEMORY table.Given this constraint, a MEMORY table cannot contain any TEXT or BLOB fields. This is also important for the tmp_table_size variable.
推荐一本书“Web Analytics 2.0”
The total size of a MEMORY storage engine table can be determined by the SHOW TABLE STATUS command and the INFORMATION_SCHEMA.TABLES table.
For additional reference, a MEMORY storage engine table used a fixed width value for any character columns. In the receding example,the VARCHAR(1000) column is effectively a CHAR(1000) column when defined in a MEMORY table.Given this constraint, a MEMORY table cannot contain any TEXT or BLOB fields. This is also important for the tmp_table_size variable.
推荐一本书“Web Analytics 2.0”
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
