[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    RE: Out of memory (Needed xxx ...
From:       "Robert DiFalco" <rdifalco () tripwire ! com>
Date:       2006-04-27 23:04:08
Message-ID: 1C21C32F5F592D48B16F28C7877D9BC11B1B32 () SVMAIL01 ! tripwire ! com
[Download RAW message or body]


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:carlos.proal@gmail.com] 
Sent: Thursday, April 27, 2006 11:31 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com; java@lists.mysql.com
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 <rdifalco@tripwire.com> 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: carlos.proal@gmail.com]
	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 < rdifalco@tripwire.com
	<mailto: rdifalco@tripwire.com> > 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:carlos.proal@gmail.com]
	        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 <rdifalco@tripwire.com>
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/mysql?unsub=carlos.proal@gmail.com 
	        >
	        >
	
	
	        --
	        MySQL General Mailing List
	        For list archives: http://lists.mysql.com/mysql
	        To unsubscribe: 
	http://lists.mysql.com/mysql?unsub=carlos.proal@gmail.com
	
	
	
	
	
	




[prev in list] [next in list] [prev in thread] [next in thread]