【MySQL】ERROR : (2006, 'MySQL server has gone away')
来源:互联网 发布:淘宝已发货是什么意思 编辑:程序博客网 时间:2024/05/17 08:47
意思就是指client和MySQL server之间的链接断开了。
造成这样的原因一般是sql操作的时间过长,或者是传送的数据太大(例如使用insert ... values的语句过长, 这种情况可以通过修改max_allowed_packed的配置参数来避免,也可以在程序中将数据分批插入)。
以下用python稍微封装了一下数据分批插入的操作:
def process_insert_list(cursor, tbl_name, insert_list): insert_sql = '' insert_head = "insert ignore into %s values"%tbl_name len_col = len(insert_list[0]) tmp_str_s = '(' tmp_str_e = ')' for i in range (1 , len_col): tmp_str_s = tmp_str_s + '%s,' tmp_str = tmp_str_s + '%s' + tmp_str_e insert_sql = "%s%s"%(insert_head,tmp_str) list_len = len(insert_list) if list_len>0 and insert_sql!='': insert_len = 5000 #自定义每次插入的记录量 insert_times = list_len/insert_len+1 for i in xrange(0, insert_times): start_index = i*insert_times end_index = start_index+insert_len if start_index>=list_len: break if end_index>=list_len: end_index = list_len tmp_list = insert_list[start_index:end_index] cursor.executemany(insert_sql, tmp_list)
- MYSQL Error 2006:MySQL server has gone away的解决方案
- 【MySQL】ERROR : (2006, 'MySQL server has gone away')
- MYSQL Error Code: 2006 – MySQL server has gone away
- mysql出现ERROR : (2006, 'MySQL server has gone away')
- mysql出现ERROR : 2006, 'MySQL server has gone away'
- MySQL错误 ERROR 2006 (HY000): MySQL server has gone away
- MySQL error: server has gone away
- Error Code: 2006 - MySQL server has gone away
- Error Code: 2006 – MySQL server has gone away
- Error Code: 2006 - MySQL server has gone away window
- ERROR 2006 (HY000): MySQL server has gone away
- Error Code: 2006 - MySQL server has gone away
- Error Code: 2006 - MySQL server has gone away
- MySQL server has gone away(error 2006)异常整理
- ERROR 2006 (HY000): MySQL server has gone away
- ERROR 2006 (HY000): MySQL server has gone away
- General error: 2006 MySQL server has gone away
- 2006 - MySQL server has gone away
- LeetCode - Unique Paths
- iNode---服务器回应报文解析失败
- windows vis c++/GetEnvironmentStrings 如何获取打开进程的环境变量字符串
- ubuntu 10.04升级到gnome3(参考)
- 通过Gearman实现MySQL到Redis的数据同步
- 【MySQL】ERROR : (2006, 'MySQL server has gone away')
- 希尔排序
- 1046. Plane Spotting
- 如何破解wayos禁止二级路由
- C/C++如何传递二维数组?
- 每天读一遍,坚持27天,你的英语水平就可以达到跟美国人交流
- Python基础 - 迭代
- BNU 26473 Aaah!【签到--->查找字符串】
- cocos2d-x 关于 Sprite应用 的一个小游戏 - Sky Defense