Setting max_allowed_packet does not seem to make a difference on how large the blob to the database can be. The MySQL server still gives the OOM exception after streaming ~600mb to a LOB regardless of how max_allowed_packet is set. R.
________________________________ From: Carlos Proal [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 11:31 AM To: Robert DiFalco Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: Re: Out of memory (Needed xxx ... 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]
