mysql插入数据过大， Lost connection to MySQL server

Out of memory (Needed xxx bytes) 

解决的方案是这样的
内存不足，可以适当修改以下参数：（my.ini，my.cnf中的【mysqld】）
key_buffer_size =128M
table_cache =256
sort_buffer_size =2M
read_buffer_size =2M
read_rnd_buffer_size =2M
tmp_table_size=16M
innodb_buffer_pool_size = 128M
innodb_additional_mem_pool_size = 8M
innodb_log_buffer_size = 1M
修改后重启，

Error Code: 2013. Lost connection to MySQL server during query

MySQL关于timeout的处理，记录如下

mysql> show variables like '%time%'; 
+----------------------------+-------------------+ 
| Variable_name | Value | 
+----------------------------+-------------------+ 
| connect_timeout | 10 | 
| datetime_format | %Y-%m-%d %H:%i:%s | 
| delayed_insert_timeout | 300 | 
| flush_time | 1800 | 
| innodb_lock_wait_timeout | 50 | 
| innodb_old_blocks_time | 0 | 
| innodb_rollback_on_timeout | OFF | 
| interactive_timeout | 28800 | 
| lc_time_names | en_US | 
| lock_wait_timeout | 31536000 | 
| long_query_time | 10.000000 | 
| net_read_timeout | 30 | 
| net_write_timeout | 60 | 
| slave_net_timeout | 3600 | 
| slow_launch_time | 2 | 
| system_time_zone | | 
| time_format | %H:%i:%s | 
| time_zone | SYSTEM | 
| timed_mutexes | OFF | 
| timestamp | 1366027807 | 
| wait_timeout | 28800 | 
+----------------------------+-------------------+ 
21 rows in set, 1 warning (0.00 sec) 

修改wait_timeout 的值
更改方法，需同时更改如下2个参数（单位--秒）：

set wait_timeout=86400;
set interactive_timeout=86400;