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

mysql MEMORY tables 如果目前支持的行数到上限还不够用 可以把 my.cnf 配置里面木铎校园 BBS 社区Co-r$wS+m
max_heap_table_size = 256M
{w;Z)T,D0改大木铎校园 BBS 社区E7Z.O8^e$F8pI8O
木铎校园 BBS 社区P"c;Y I/x&J0H
设置 MAX_ROWS
;C7_,IH9Ha0M r0在跑着 可以 ALTER TABLE tbl_name MAX_ROWS=木铎校园 BBS 社区#k3yD'l*eI{^kq9u
MAX_ROWS 依赖于 max_heap_table_size 设置木铎校园 BBS 社区 _ DB(\{
木铎校园 BBS 社区+l$[~&J$T n*a
相关帮助：木铎校园 BBS 社区`v ja Xn+| yni
max_heap_table_size木铎校园 BBS 社区w5a'ia&lGU*?
This variable sets the maximum size to which MEMORY tables are allowed to grow.木铎校园 BBS 社区x3d^U8Q Io%f1N?
The value of the variable is used to calculate MEMORY table MAX_ROWS values.木铎校园 BBS 社区.Z6K:A(tF7PKj/@DI3f
Setting this variable has no effect on any existing MEMORY table,
9d;ypE5A]8X;|0unless the table is re-created with a statement such as CREATE TABLE or木铎校园 BBS 社区 l/?$TK)UHiW
altered with ALTER TABLE or TRUNCATE TABLE.木铎校园 BBS 社区8OE[+C{,V

k;b8WP&Z!^6Hx"E0The MEMORY (HEAP) Storage Engine
UN3F"o#cMNI0MEMORY tables are never converted to disk tables. To ensure that you木铎校园 BBS 社区xRt Dv+YA
don't accidentally do anything foolish, you can set the max_heap_table_size
Q(xM,~M$c8D+K0system variable to impose a maximum size on MEMORY tables. For individual tables,木铎校园 BBS 社区W X R2Z
U6`#V]
you can also specify a MAX_ROWS table option in the CREATE TABLE statement.