mysql HEAP MEMORY tables 提高行数支持的方法 zz

mysql MEMORY tables 如果目前支持的行数到上限还不够用 可以把 my.cnf 配置里面
sK/Mn n`J4Y/NK0max_heap_table_size = 256M
1u b2U1P.`_GM0改大
%Z?h;BOfc~0木铎校园 BBS 社区zM-B
S Iw4W0e3}x
设置 MAX_ROWS
#s})K'k+_#J0~0在跑着 可以 ALTER TABLE tbl_name MAX_ROWS=
4\3U5pmF!f un0MAX_ROWS 依赖于 max_heap_table_size 设置
0k VePL8NY`(Y0木铎校园 BBS 社区xzzS'?3W(BjO
相关帮助：
h(in)a:X0max_heap_table_size
hn:X:[ P(n0This variable sets the maximum size to which MEMORY tables are allowed to grow.木铎校园 BBS 社区4B!I'e~5xd
The value of the variable is used to calculate MEMORY table MAX_ROWS values.
*xJn/u!O#w~1e{0Setting this variable has no effect on any existing MEMORY table,木铎校园 BBS 社区*fEb*@:r1^0Fnb
unless the table is re-created with a statement such as CREATE TABLE or木铎校园 BBS 社区@ O5C7]d1| a7W
altered with ALTER TABLE or TRUNCATE TABLE.木铎校园 BBS 社区AdZ#Zh9_)a
木铎校园 BBS 社区[(I(F W E~3i0S2E
The MEMORY (HEAP) Storage Engine木铎校园 BBS 社区h {%_~V
MEMORY tables are never converted to disk tables. To ensure that you
@H7GC n(HU]4s#E0don't accidentally do anything foolish, you can set the max_heap_table_size
"q X/t{rystem variable to impose a maximum size on MEMORY tables. For individual tables,
:H4\_(~H8]ksL0you can also specify a MAX_ROWS table option in the CREATE TABLE statement.