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

mysql MEMORY tables 如果目前支持的行数到上限还不够用 可以把 my.cnf 配置里面木铎校园 BBS 社区kBY*da%C:Dq m;^
max_heap_table_size = 256M
;aLmI(Hp(M[i/_q{0改大
VLDL8d9M _vm:\#X0
4u#f"?\'xHwh F.[0设置 MAX_ROWS木铎校园 BBS 社区+](VX0rT
在跑着 可以 ALTER TABLE tbl_name MAX_ROWS=
^&C?1Kd"S c~0MAX_ROWS 依赖于 max_heap_table_size 设置
i.twE%\(y%R4d`0木铎校园 BBS 社区(cs P5w!g CIW\:R
相关帮助：
B7kfR v0max_heap_table_size
xn,H2uobw%T0This variable sets the maximum size to which MEMORY tables are allowed to grow.木铎校园 BBS 社区i}LefJ%ov9~
The value of the variable is used to calculate MEMORY table MAX_ROWS values.木铎校园 BBS 社区`5sQ3S%?.ZR@|
Setting this variable has no effect on any existing MEMORY table,
Fz*YG?2q1O b0unless the table is re-created with a statement such as CREATE TABLE or木铎校园 BBS 社区em-_j:be(W!nk
altered with ALTER TABLE or TRUNCATE TABLE.木铎校园 BBS 社区H5{)W'_%aH(?#r1e
木铎校园 BBS 社区^dm(RXM
The MEMORY (HEAP) Storage Engine
*xS?M/{h'dm(Xht9Z0MEMORY tables are never converted to disk tables. To ensure that you木铎校园 BBS 社区&p\1A;i+}
j?7C(]5x
don't accidentally do anything foolish, you can set the max_heap_table_size
.{g5nC AbV;fP0system variable to impose a maximum size on MEMORY tables. For individual tables,
w r-[ Et|:G0you can also specify a MAX_ROWS table option in the CREATE TABLE statement.