Re: How to specify a maximum number of bulk insert rows at a time
Posted by:
Jeff Heon
Date: July 15, 2010 10:26PM
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.
Subject
Written By
Posted
Re: How to specify a maximum number of bulk insert rows at a time
July 15, 2010 10:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.