Performance degradation JBoss 4.0.2 +Specj 2002 + MySQL

[prakashbabu]

Hello all,

I tried testing the performance of JBoss 4.0.2 with Specj2002 on HPUX with Mysql 4.x as the backend.
The TOPS value reduces as the injection rate(txRate) increases.

TOPS=1.7 * txRate

txRate TOPS Expected Value

I have removed the values. Due to spec rules you can't publish any numbers

I have tried
1. Fine tuning the kernel parameters (max_thread_proc,nkthread, maxdsiz)
2. Using the various mysql configurations(small,medium,huge etc)
3. I have tried using MySQL Innodb tables ( row level locking)
4. Fine tuning the JAVA option (increase HEAP size to 2048)
5. Using 3.x versions of JBoss

The following error occurs frequently in the server log.

06:44:29,860 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.spec.jappserver.util.helper.SequenceBlock org.spec.jappserver.util.sequenceent.ejb.SequenceEntLocal.nextSequenceBlock(), causedBy: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=neptune.kovaiteam.com//758, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.ejb.EJBException: Expected one updated row but got: 0)

There is some problem with comitting the transaction.

Is this a problem with JBoss or MySQL ?
Has any you tried the above combination of components and got a better result?
Do I have to tune any other parameter ?

Thanks,
Prakash

[clebert.suconic]

You should invest your time in Specj2004:


I - Specj2002 is retired
II - We have a KIT that jump start you on Specj2004 http://www.jboss.org/wiki/Wiki.jsp?page=SPECjAppServer2004Setup
III - You are probably getting errors during your executiong. We could have higher numbers


Also, I'm moving this thread to "Design of Internal Benchmark".

I will be glad in help you if you need help in setting up Specj2004. Send me questions through the Benchmark forum.

If you want to send TOPS/JOPS for comparisson, do it in private if you can disclosure them with me. You can't do it in any public forum/webpage.


Clebert