Jump to content

chanders

Members
  • Posts

    67
  • Joined

  • Last visited

Posts posted by chanders

  1. Thanks Krydos, I would certainly appreciate if it is possible to temporarily increase it so I can do some benchmarking without butting into system queue delays. I can assure you that I am very carefully with regards to monitoring, and ensure that the pooled connection is closed immediately after operation is completed. Thanks again and warm regards.

  2. Dear Krydos,

     

    Thank you for the great suggestion -- apparently the current global variable: max_user_connections is set to 4 -- which might just be too low!. Also, I checked my code and it seems that: I open the pooled connection instance -- process sql-- and then immediately close it right after the operation. So, most of the time it seems to work, but annoying stops or slows down causing data access errors. Most people suggest changing the global max_user_connections first, before changing the pooling scheme or anything else. So temporarily changing this global variable higher will prove this hypothesis. Besides this global variable change does not affect the system resources much, since the top limit is already set to 75.

     

    at: /home/citisnet

    warm regards.

  3. After reading a few posts, I get the impression that deploying war and enabling java servlet on 'johnny' server could take a lot longer. If so -- please move my implementation to 'tommy' or other server that is more readily available and supports mysql/jdbc. My user and war file info is:

    user: chanders

    war file: citisnetsql3.war

     

    regards.

×
×
  • Create New...