Hello I am using Python connector 8.0.13 under Python 3.6 and MySQL 5.5.62. On Win 7
I want to write large Blob Data into my Tables. The problem is that under Python the query crashes the server with the Error:
C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqld.exe: Out of memory (Needed 240225944 bytes)
Error: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
My Ram neither Swap are Full when this occurs. The strange thing is. If I use MySQL Workbench, the Data gets inserted.
What I did to this point:
- Set all timeout settings to at least 600 (also in mysql.connector.connect)
The insertion via Python looks sort like this:
command = 'INSERT into table (col1,Blob, col3,... ) Values(val1, %s, val3) on duplicate key update col1=val1, Blob = %s, col3=val3' cursor.execute(command, [Blobdata, Blobdata])
The the above code works for data about 15-20 MB flawless but with for example 200 MB (like in the Error above) the Server shuts down.
I would be thankful if some of you got an idea how to solve this.