大量行的MySQLdb错误的executemany [英] executemany for MySQLdb error for large number of rows
本文介绍了大量行的MySQLdb错误的executemany的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我当前正在运行一个脚本,以使用execute many函数将值(元组列表)插入MySQL数据库.当我使用少量的行(`1000)时,脚本运行良好.
I'm currently running a script to insert values (a list of tuples) into a MySQL database, using the execute many function. When I use a small number of rows (`1000), the script runs fine.
当我使用大约40,000行时,出现以下错误:
When I use around 40,000 rows, I receive the following errors:
cursor.executemany( stmt, trans_frame)
Traceback (most recent call last):
File "C:\Python27\lib\site-packages\IPython\core\interactiveshell.py", line 2538, in run_code
exec code_obj in self.user_global_ns, self.user_ns
File "<ipython-input-1-66b44e71cf5a>", line 1, in <module>
cursor.executemany( stmt, trans_frame)
File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 253, in executemany
r = self._query('\n'.join([query[:p], ',\n'.join(q), query[e:]]))
File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 346, in _query
rowcount = self._do_query(q)
File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 310, in _do_query
db.query(q)
OperationalError: (2006, 'MySQL server has gone away')
有什么建议吗?
推荐答案
sql ='SET GLOBAL max_allowed_packet=500*1024*1024'
cursor.execute(sql)
这篇关于大量行的MySQLdb错误的executemany的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文