[Cosmo-dev] 32Gb and no clue

[Mike]

On Aug 14, 2007, at 12:03 PM, Jared Rhine wrote:

> How would you tune a 32Gb RAM box running one Cosmo instance and MySQL?

<snip>

> It just occurred to me that we could do another "Java Runtime 
> Analyzer" run; we did that back in the cosmo-demo days to try to track 
> down some performance bugs, but maybe there's some GC/heap info in it 
> too.

The answer from all the research I did way back when Java and Tomcat 
were new to OSAF was this:  you can tweak all you want but without 
having the analyzer running it will be nothing but dart-tosses and 
chicken-runs.

I would stick with the values we last used and hook up the analyzer and 
start looking at trends.

> There's another thread needed about MySQL tuning, but that one might 
> be a little more straightforward.

Now this is a bit simpler, but only a bit - because while the Cosmo 
data is stored in MySQL, I'm willing to bet the usage patterns for each 
table has not been determined and index/query plans have not been 
determined.

The answer to this will also be the same as above - let's hook up a 
runtime stats collector and start flinging large test runs at it.  We 
may find that more indexes are needed or some of the larger tables may 
need performance tweaks (or in database lingo: normalization and 
aggregation - we are probably at 2nd normal form right now with an eye 
towards 3rd)

---
Bear

Build and Release Engineer
Open Source Applications Foundation (OSAF)
bear at osafoundation.org
http://www.osafoundation.org

bear at code-bear.com
http://code-bear.com

PGP Fingerprint = 9996 719F 973D B11B E111  D770 9331 E822 40B3 CD29


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.osafoundation.org/pipermail/cosmo-dev/attachments/20070814/ed15d50b/PGP.pgp