[opencms-dev] Re: Re: need help: how improving opencmsperformance?

[Isaac R. Higgins]

Achim is right.  If you set the JVM to use all of windows' RAM, Windows will swap EVERYTHING it does.  With MySQL running on the same machine and 1-3K queries per page, you can expect MySQL to do some swapping too.

Question: What kind of content are you running on your pages?  I have a page that pulls information from other servers and platforms and it loads slower than other pages, but never more than 6 seconds (running on my temp/crappy laptop 768MB Ram 2.4GHz Celeron, 4200RPM Drive, WINXPSP2).

I suggest you check your MySQL my.ini settings. If you are not using INNODB or MyISAM then disable it.  Also, check the memory allocation and caching of MySQL.  I have mine set to only use 4MB on startup.  This isn't the most efficient setting, but it keeps resources free.

Also, check the number of processes you have running in XP.  Mine is currently at 35 and I have all kinds of stuff running.  I think mine is around 27 on a reboot.  You can goto "start" -> "run" and type "msconfig" to remove some processes loaded at startup.  Also disable drive indexing service and windows auto update service (start->run->services.msc).

Lastly, run optimize on your MySQL tables.

-Isaac

PS I'll let you know if I think of anything else.

-----Original Message-----
From: opencms-dev-bounces at opencms.org on behalf of Joachim Arrasz
Sent: Wed 1/24/2007 11:01 AM
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Re: Re: need help: how improving opencmsperformance?
 
Hi,

> I used those values because we are experiencing  java heap space problems.
> Tomcat is version 5.5.15 and i'm using MySQL 4.1 because this is the version 
> used in production environment (in a server with 2 CPU and at least 4 GB 
> ram)

then your tests are no tests in my opinion. A test enviroment should act
as the productive enviroment.

> I don't know what thinking about.

i think this is because swapping of windows. There is not enough real
memory available, so Windows swaps sometimes, sometimes not ...

Regards Achim

-- 
/**
 * Joachim Arrasz
 * Head of technical Research
 * Synyx GmbH & Co. KG --OpenCms Solution Provider--J2ME Solutions--
 * Karlstr. 68
 * 76137 Karlsruhe
 * phone  +49(0)721 66 48 79 32
 * fax    +49(0)721 66 48 877
 * eMail  joachim.arrasz at synyx.de
 * www    http://www.synyx.de
 */

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev



-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4203 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20070124/d0c435fb/attachment.bin>