ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vivek <er.jadiyavi...@gmail.com>
Subject Creating a new connection pool?
Date Fri, 16 Sep 2011 09:04:08 GMT
Dear Ofbiz User ML Members,

Greetings of the day.

I am working on ofbiz & had found myself under deep problem after deploying
the application on production server.

The application is crashing very frequently. The analysis after performing
JMeter test reveals that it is not able to serve the multiple users at a
time (approx 500 users in a minute or 2 concurrency failure).

Also after performing the memory analysis using jconsole (heap dump) & MAT,
i found out that most of the memory is being utilized by RMI threads & the
base.start class.

Also on checking the memory on console (unix) with jmeter running
simultaneously i found that DB (postgres) & JVM both are acquiring a lot of
memory & CPU usage goes to 130- 140% with very less amount of buffer memory
remaining (in kbs)

I have configured the application as per recommendations for production
(cache, debug, serverstats etc...) Still the problem persists.

I want to establish an extra connection pool in order to trigger few select
queries (prepared statements) bypassing the entity engine such that whenever
any select operation need to be performed i can fetch connection from the
separate pool & then trigger the query bypassing the entity engine without
disturbing the pre-allocated pool.

How shall i approach in this regard, like where to define new custom
parameters for the pool & how to obtain the connection from the separate
pool.

Any help or guidance on this will deeply appreciated.

Looking forward to read from you very soon.

Thanks.

Best Regards,
Vivek

-----
Kind Regards,
Vivek J
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Creating-a-new-connection-pool-tp3817670p3817670.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Mime
View raw message