MySQL Forums
Forum List  »  IBM DB2

store and retrieve BLOB db2 vs mysql
Posted by: nimo mayr
Date: July 19, 2009 01:03PM

I used db2 to store large BLOBs and described these datatypes as follows:

"blob(209715200) not logged not compact"

my first question:

WHERE (HOW) can I set my blobs in mySQL as "not logged not compact".
Are there any similar keywords for "not logged not compact".
WHERE (HOW) can I set my blobs in mySQL as not compact "not logged not compact"??


In db2, I set these 4 properties to avoid a out-of-memory-exception (heap space) when retrieving the BLOB-File from the database (without the need for changing my java heap space):

fullyMaterializeLobData=true;
fullyMaterializeInputStreams=false;
progressiveStreaming=2;
progresssiveLocators=2;



In mySQL, I have to change the property:
max_allowed_packet = 1G (so my maxBlob can be 1G)

However, in mySQL, I get always a out-of-memory-exception (heap space) when not enhancing my heap space.

so my second question:

Are there any similiar properties in mySQL for ??:

fullyMaterializeLobData=true;
fullyMaterializeInputStreams=false;
progressiveStreaming=2;
progresssiveLocators=2;

Options: ReplyQuote


Subject
Views
Written By
Posted
store and retrieve BLOB db2 vs mysql
10337
July 19, 2009 01:03PM


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.