MySQL Memory table + temp Table

Temp table: Table in memory, data in memory.

Memory table: Table on disk, data in memory.

Modify the size of the staging table and memory table in the My.cnf file:

[Mysqld]
　　 # Memory Table capacity
　　max_heap_table_size=1024m
　　# temp Table capacity
　　tmp_table_size=1024m

< Span style= "FONT-FAMILY:HELVETICA,TAHOMA,ARIAL,SANS-SERIF; font-size:14px; line-height:25px; Text-align:left; " >< Span style= "FONT-FAMILY:HELVETICA,TAHOMA,ARIAL,SANS-SERIF; font-size:14px; line-height:25px; Text-align:left; " > create:

< Span style= "FONT-FAMILY:HELVETICA,TAHOMA,ARIAL,SANS-SERIF; font-size:14px; line-height:25px; Text-align:left; " >< Span style= "FONT-FAMILY:HELVETICA,TAHOMA,ARIAL,SANS-SERIF; font-size:14px; line-height:25px; Text-align:left; " > memory table:  Note engine is memory

CREATE TABLE coldtest_vardata (   int(one) auto_increment,   varchar(255  ) ENGINE=DEFAULT CHARSET=UTF8 Row_format=

< Span style= "FONT-FAMILY:HELVETICA,TAHOMA,ARIAL,SANS-SERIF; font-size:14px; line-height:25px; Text-align:left; " >< Span style= "FONT-FAMILY:HELVETICA,TAHOMA,ARIAL,SANS-SERIF; font-size:14px; line-height:25px; Text-align:left; " > temp table:

　　　　Create temporary table TMP1 (ID int not NULL);

RELATED links:

http://blog.csdn.net/feihong247/article/details/7847722//temporary tables and memory tables

http://blog.chinaunix.net/uid-16844903-id-3026988.html//temporary tables and memory tables

MySQL Memory table + temp Table