#125 executemany limit

MySQLdb-1.0
closed
MySQLdb (285)
5
2012-09-19
2005-01-26
Anonymous
No

I get odd errors when I send large amonts of data to
the executemany function. If I print the data to a text
file it takes up about 1 Meg.

The errors are:

"MySQL server has gone away"

"Lost Connection to MySQL server during query"

If I reduce the amount of data passed to the function
it works perfectly.

Discussion

  • Nobody/Anonymous

    Logged In: NO

    Thanks for this info - it all makes sense now.

    I think for my needs I will keep the packet size at 1MB and
    just break up any large insert operations into smaller chunks.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks