mysql memory engine

创建:

mysql> create table mt engine = memory select * from information_schema.tables;

Query OK, 334 rows affected (1.80 sec)

Records: 334  Duplicates: 0  Warnings: 0

限制表的大小

alter table mt max_row = 200 ;

或者

set global max_heap_table_size=1024*1024*1024

创建索引

alter table mt add index idx_hash_mt [using hash(table_name) ];

alter table mt add index idx_btree_mt using btree(table_name);

巴特西

mysql memory

mysql memory engine

最新文章

热门文章