As far as i remember you must set that variable in order to send huge blobs, and the error message can vary because it can means that the current memory space for that connection has been filled. Why not do you try to set it up, as mentioned in the manual and check the results.
Im forwarding this to the java list, maybe Mark can reserve a liitle time from the Mysql Users Conference and give us some feedback. Carlos On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote: > > It's not set, but I am streaming the LOG to the server, would max packet > impact this situation? Also, wouldn't I get a different error, i.e. > Packet Too Large? > > ________________________________ > > From: Carlos Proal [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 4:59 PM > To: Robert DiFalco > Cc: mysql@lists.mysql.com > Subject: Re: Out of memory (Needed xxx ... > > > And whats the size of your "max_allowed_packet" variable ? > > Carlos > > > > On 4/26/06, Robert DiFalco < [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > wrote: > > I am, the java heap is set to 2G. But I don't think it is my > java > process that is running out of memory, I believe it is the MySQL > server. > > > -----Original Message----- > From: Carlos Proal [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 4:53 PM > Cc: mysql@lists.mysql.com > Subject: Re: Out of memory (Needed xxx ... > > Hi Robert, are you using the extended parameters to increase the > jvm > heap memory ? > > ie. > > java -Xms256m -Xmx512m .... > > Carlos > > > On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote: > > > > Getting this error from JDBC while inserting a VERY large > VARBINARY or > > > MEDIUMTEXT field, ~250MB. I'm guessing this is an error from > the > server? > > Is there a way to have the server start streaming to disk > sooner with > > a LOB? Is there a property I'm not setting? > > > > TIA, > > > > R. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql To > unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > >
