Results 1 to 4 of 4
  1. #1
    inabv is offline Member
    Join Date
    Sep 2012
    Posts
    2
    Rep Power
    0

    Default Tomcat Postgre Pooling Performance Problems

    Hi,

    i am using Tomcat 6.0, Postgre 8.2 on a normal XP PC, with following pooling settings:

    <datasource.maxIdle>50</datasource.maxIdle>
    <datasource.maxWait>100</datasource.maxWait>
    <datasource.maxActive>100</datasource.maxActive>

    My application is following as i have a bunch of data (like 100-500 records) every 10 sec up to 10 min being added to the DB. Also there are some web clients not more than 5 at a time watching this data on the webpage, no alteration happening on the data.

    Now in beginning, when starting up Tomcat all works well and CPU is at average 5%, Tomcat memory 120 Mb, lots of postgre processes, not taking much any serious ressources.

    With some activity on the clients the Tomcat CPU goes to average 20-30 %, Memory a bit higher 160 Mb.

    But when activities on clients drop this also drops.

    Now after few days the Tomcat is with CPU at 90% and all seems to be blocked.

    I dont think there is a problem of PC, also pooling settings i have tried using different values, i cant really see any leaks, i am unable to find the problem.

    I also dont know of any performance monitoring tool which can help me analyse this problem. I am trying all with Windows Task Manager, but this doesnt give me any clue at all...

    I would really appreciate some help from somebody how to tackle this, how to check pooling performance, other pooling seetings, or leak analysis.

    I really need some urgent help!

    Thanks for your support!

    Ina

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default Re: Tomcat Postgre Pooling Performance Problems

    Take some heap dumps over time and see if something is leaking using a heap analysis tool of some sort (Eclipse MAT is quite good).
    Also check your connections are being closed (though that would normally result in a quicker resource loss than this appears to be). You should be able to monitor open connections, though that'll depend on your server.
    Please do not ask for code as refusal often offends.

  3. #3
    inabv is offline Member
    Join Date
    Sep 2012
    Posts
    2
    Rep Power
    0

    Default Re: Tomcat Postgre Pooling Performance Problems

    Hi Tolls,

    thanks, i would try with Eclipse MAT.
    How can i see if connections are closed?
    Sometimes i feel that it is also releated to the web sessions, that it doesnt close the sessions, can it be? since i have a timout of 30 min for each browser session, but i can see in Tomcat Monitor that the sessions are always there.

    Ina

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default Re: Tomcat Postgre Pooling Performance Problems

    Not sure how Tomcat manages its sessions.
    You might need to dig through the documentation on that I'm afraid.
    I would have expected the active sessions to reduce.
    Please do not ask for code as refusal often offends.

Similar Threads

  1. performance problems with JList/default list model
    By prescott in forum AWT / Swing
    Replies: 3
    Last Post: 11-16-2011, 04:06 AM
  2. How to do connection pooling in Tomcat and JBoss
    By jason.3dmagic in forum JDBC
    Replies: 4
    Last Post: 02-17-2010, 01:36 PM
  3. Replies: 12
    Last Post: 02-17-2010, 07:50 AM
  4. [newbie] Postgre jdbc
    By jon80 in forum New To Java
    Replies: 1
    Last Post: 06-28-2009, 10:01 AM
  5. Problems with Tomcat 5.5.16
    By Felissa in forum Enterprise JavaBeans (EJB)
    Replies: 2
    Last Post: 07-03-2007, 05:45 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •