On 10/25/07, tiandike <[EMAIL PROTECTED]> wrote: > > > I didn't set value to intialSize, maxIdle, minIdle and use the default > value. > do these param affect performance?
yes, very much. check out the docs and play a bit with the settings. . Your connection pool is probably opening and closing 'physical' connections all the time which is exactly what you try to avoid by using a connection pool. try a higher value for maxIdle, maybe also for minIdle and initialSize Maarten and i find there are other param in BasicDataSource , do i need to set the > right value? > > > Maarten Bosteels wrote: > > > > what are the other values for BasicDataSource ? > > initialSize, maxIdle, minIdle ? > > > > How much threads is your mina app using ? > > > > You could try to see how much insert/transactions your app can do per > > second > > without using mina and loadrunner: just start x threads INSIDE your > > application that do the db operations in a loop. > > Then you know if it's mina related or not. > > > > Maarten > > > > On 10/24/07, tiandike <[EMAIL PROTECTED]> wrote: > >> > >> > >> 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 > >> . > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/a-question--when-running-performance--test-by-loadruner-tf4683007s16868.html#a13407640 > Sent from the Apache MINA Support Forum mailing list archive at Nabble.com > . > >
