AW: [opencms-dev] problem to export database in .zip file

["Bührle, Martin, FCI1"]

Hi List!

Sorry, I didnt get the forst message, just the response.
In the message of Aleksandar I have just an attachment "image1.gif", no
text, nothing else.

We had the same problem before, living on a Suse Linux 7.3 prof. machine.
Ich changed the following statements in the tomcat-startup-script (Tomcat
4.0.1):

a) added CATALINA_OPTS="-Xms12m -Xmx600m"
b) added echo 16384 > /proc/sys/fs/file-max

Then it worked. 
With huge databases sometimes it was necessary to improve the -Xmx-Parameter
to 900m to be able to export the content.


But anyway, I am still looking to get better parameter-optimization from
anybody else on the list.
Does anybody have more experiences with a huge installation of opencms.
It seems that the java-environments memory consumption is quite huge and the
garbage-collector isnt working quite strict.
We restart the hole tomcat every night to free some memory. We have 1
Gigabyte of RAM on the machine, up to 20 concurrent opencms-authors and
about a few hundred intranet-users.

We use IBM JDK 1.3, Tomcat 4.0.1, mySQL on Suse Linux 7.3 prof. together
with Apache 1.3 and the WARP-Connector to Tomcat.


Best regards
 Martin 

_________________________________________________________________________
Martin Buehrle, FCI1
EADS - European Aeronautic Defence and Space Company
LFK GmbH
Telefax: +49 89 3179-8927
eMail: Martin.Buehrle at lfk.eads.net
_________________________________________________________________________



> -----Ursprüngliche Nachricht-----
> Von:	Stefan Marx [SMTP:Stefan.Marx at framfab.de]
> Gesendet am:	Mittwoch, 18. September 2002 13:01
> An:	opencms-dev at www.opencms.org
> Betreff:	[opencms-dev] problem to export database in .zip file
> 
> Hi,
> 
> seems to me that you have realy huge data amounts acting
> nearly at PC limits. Hope you project is living on a RISC
> platform ;=).
> Just guessing: The quantity of hits while selecting from your
> data source are so huge that they smash the stacks and can't
> be handled on your heap. Maybe you can divide your OC tables 
> in the database and export them one partition after the an
> other.
> 
> cu Stefan
> 
> Good luck! SCR ...
> 
> Stefan Marx
> Manager Application Server
> ---------------------------------------
> Framfab Deutschland AG
> Augustinusstrasse 11a
> D 50226 Frechen
> GERMANY
> mailto:Stefan.Marx at framfab.de
> http://www.framfab.de
> Phone +49 (0)2234 . 699 334
> Fax +49 (0)2234 . 699 335
> ---------------------------------------
> official court Kerpen, HRB 3152
> 
> Framfab is an Internet consulting and solutions provider,
> specializing in developing Internet-based solutions. 
> Stay informed about our latest solutions and projects 
> at http://www.framfab.de.