Re: How to specify a maximum number of bulk insert rows at a time

[Jeff Heon]

Ok, I made a wrong assumption. It turns out bulk insert has nothing to do with my error. I transformed all my inserts bulks in individual insert statements and SOME inserts give me the 139 error. It seems related to data size of my columns although they are longtext column which are excluded from the 8k row size limit.

Ok, I'm sorry I had not searched the forums properly before.

I wish I could just delete my two posts.

Anyway, long story short:
"InnoDB stores the first 767 bytes of each BLOB or TEXT in the row, itself; the rest is stored elsewhere. " (http://forums.mysql.com/read.php?10,373036,373653#msg-373653)

And the sum of these first 767 bytes in all my LONGTEXT columns are taken into account for the 8k row size limit.



Edited 3 time(s). Last edit at 07/16/2010 08:49AM by Jeff Heon.