I use org.apache.commons.dbcp.BasicDataSource and set maxActive =1000 i don't know why is 8? why not other number?
Maarten Bosteels wrote: > > Hello, > > With 8 users or less your server is doing 2600 inserts per second ? > And each insert is a new database transaction ? > First of all, I think that ain't bad at all ! > > Are you using a database connection pool ? > Check the size of the pool. > > Since you don't have problems when you don't perform db operations, I > think > your problem is not related to MINA. > > The bottleneck in our MINA based server also turned out to be Oracle, more > specifically the number of commits that Oracle could do per second. I am > not > saying that Oracle is bad (quite the opposite) just that I think that's > where you should look: it has A LOT of tuning options. > > Maarten > > On 10/24/07, tiandike <[EMAIL PROTECTED]> wrote: >> >> >> I use loadruner to test my server ,my handler performs database >> operations(insert a row a request) >> i disable the default ThreadModel setting following >> http://mina.apache.org/configuring-thread-model.html >> >> when i use loadruner to run performance test , a strange phenomenon is >> that >> when the number of Running Vusers >> in loadruner is less than 8 (include 8) the tps is about 2600 ,but when >> the number of Running Vusers is greater than 8 in loadruner ,the tps >> reduce >> to very low and number of the records that inserted in oracle also >> reduce >> to very low . >> I don't know why, anyone can help me? >> >> my server is 4 cpu (Intel(R) Xeon(R) CPU 5110 1.60GHz), linux >> my database is oracle >> jvm version is 6.0 >> >> (But : if my handler not perform database operations the condition above >> never happen!) >> >> -- >> View this message in context: >> http://www.nabble.com/a-question--when-running-performance--test-by-loadruner-tf4683007s16868.html#a13381592 >> Sent from the Apache MINA Support Forum mailing list archive at >> Nabble.com >> . >> >> > > -- View this message in context: http://www.nabble.com/a-question--when-running-performance--test-by-loadruner-tf4683007s16868.html#a13383246 Sent from the Apache MINA Support Forum mailing list archive at Nabble.com.
