Recomendations for Specj2004 - Scrap book
If you have any recomendations, feel free to add them here
If you are using RH3, you need to define LD_ASSUME_KERNEL=2.4.1
This is basic something broken into RH3's threading model. You would have some weird transaction behaviors without this parameter set
For now, multi processed environment are recommended for higher injection rates. Don't forget to enable hiperthreading if you system supports it
timestamps - It is absolutely critical that emulator/client/driver/SUT have the same time. We've been using ntp to keep system times in sync
When running with MySQL you will need to turn on the IGNORE_SPACES switch, sql_mode=IGNORE_SPACE
Add additonal index to MySQL tables that show up in slow query log. alter table C_customerinventory add index (CI_CUSTOMERID);
Use cached prepared statements.
Set the datasource for the CMPs at max values. (Creating/Destroying lots of connections will decrease your performance numbers)
Possible options to try:
JDK5: FLAGS="-Xmx512M -Xms512M -XX:CompileThreshold=1000 -XX:UseParallelGC -XX:Aggr\
essiveHeap -XX:NewRatio=1 -server"
JRockit: FLAGS="-Xmx512M -Xms512M -Xgc:parallel -server"