Re: JPAStressTest with derby, h2 and mysql

2010-05-03 Thread Eric Charles
Hi Norman, I've set ulimit -n 65535 (default was 1024), used -Xmx512m (cfr your last commit) and connectionBacklog=900 lsof -p pid| wc -l gives around 550 (stable). No issue after stop (test with embedded Derby). Disk swapping and exceptions came from the 64m limit if you don't set -Xmx

Re: JPAStressTest with derby, h2 and mysql

2010-05-03 Thread Norman Maurer
Hi Eric, thx for all your help and tests :) Bye, Norman 2010/5/3 Eric Charles eric.char...@u-mangate.com: Hi Norman, I've set ulimit -n 65535 (default was 1024), used -Xmx512m (cfr your last commit) and connectionBacklog=900 lsof -p pid| wc -l gives around 550 (stable). No issue after

Re: JPAStressTest with derby, h2 and mysql

2010-05-02 Thread Eric Charles
Hi Norman, Trying to simulate a more real-life test case, I developed a small bomber class that launches parallel threads. Each thread sends mails with attachements (with small pause between each mail sending). I tested with embedded derby with JDBCDomainList. Depending on the parameters

Re: JPAStressTest with derby, h2 and mysql

2010-05-02 Thread Norman Maurer
Hi Eric, for such high load you will need to adjust a few things: 1) set a higher ulimit. By default its 1024 on linux which is prolly not enough ( I use fbsd which use 11095 by default) 2) set a higher connection backlock in smtpserver.log Bye, Norman 2010/5/2 Eric Charles

Re: JPAStressTest with derby, h2 and mysql

2010-05-02 Thread Eric Charles
Hi Norman, What do you mean with ...backlock in smtpserver.log ? Tks, Eric On 05/02/2010 01:15 PM, Norman Maurer wrote: Hi Eric, for such high load you will need to adjust a few things: 1) set a higher ulimit. By default its 1024 on linux which is prolly not enough ( I use fbsd which use

Re: JPAStressTest with derby, h2 and mysql

2010-05-02 Thread Norman Maurer
Ups I mean connectionBacklog200/connectionBacklog in smtpserver.xml Bye, Norman 2010/5/2 Eric Charles eric.char...@u-mangate.com: Hi Norman, What do you mean with ...backlock in smtpserver.log ? Tks, Eric On 05/02/2010 01:15 PM, Norman Maurer wrote: Hi Eric, for such high load

Re: JPAStressTest with derby, h2 and mysql

2010-05-01 Thread Norman Maurer
Hi Eric, thx for your tests. The order of the uid is caused by the threads, thats nothing to worry about. About the timeout, can you try to add this to the test case: properties.put(openjpa.LockTimeout, 3); And keep in mind that we don't use any connection pooling in the test case so the

Re: JPAStressTest with derby, h2 and mysql

2010-05-01 Thread Eric Charles
Hi Norman, Similar exceptions with properties.put(openjpa.LockTimeout, 3); I think the environment simply can not follow the load (more than one mail sent each ms). Bootleneck can be anywhere (connection creation, database lock, openjpa,...). This is why I put a sleep between each mail

Re: JPAStressTest with derby, h2 and mysql

2010-05-01 Thread Norman Maurer
About 6000, then I run out of heap space.. Can you maybe try to deploy it with james and bomb it via smtp ? I was not able to see any exception. Thx, Norman 2010/5/1 Eric Charles eric.char...@u-mangate.com: Hi Norman, Similar exceptions with properties.put(openjpa.LockTimeout, 3); I