Version 7

    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"