You may also want to have a look at flexy pool - https://github.com/vladmihalcea/flexy-pool
With kind regards Thomas With kind regards Thomas > Am 11.01.2017 um 01:36 schrieb Joleen Barker <oldenuf2no...@gmail.com>: > > As always, thank you Christopher, I'll take a look at the slides. > > And Thank you to the other for pointing me in some directions for this. > > -Joleen > > On Tue, Jan 10, 2017 at 3:19 PM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA256 >> >> Joleen, >> >>> On 1/10/17 11:10 AM, Joleen Barker wrote: >>> Hello All, >>> >>> Details: Tomcat Version: 7.0.64.0 Java Version: 1.8.0 OS: AIX 6.1 >>> Database: Oracle 11 >>> >>> The web application installed on the server above makes data >>> connections to run file transfers from point A to point B. The >>> default Database connection setting that are set when the >>> application server comes up are as follows: >>> >>> DataBasePoolingFlag - APACHE MaxActive - 400 MaxIdle - 20 MinIdle - >>> 10 >>> >>> We had an incident where all these connections were actually used >>> up due to a script someone had that looped. I need to determine at >>> any given point in time how many DB connections exist from the web >>> application to the DB. There may be more than one way to do this. I >>> am sure there is a DB command that could be run against the schema >>> but the schema is pointed to by many servers. I am wondering if >>> there is a java command of some kind that I could run that may tell >>> me how many connections are open at that time or possibly a tomcat >>> or apache command. >> >> This may be helpful: >> >> http://people.apache.org/~schultz/ApacheCon%20NA%202016/Monitoring%20Apa >> che%20Tomcat%20with%20JMX.pdf >> >> Slides 15-16 show you where you can find the DataSource information >> via JMX, and then later on in the presentation there are slides to >> show how you can get that information via HTTP instead of JMX. Scripts >> are provided to fetch a value at intervals, track values over time, etc. >> >> - -chris >> -----BEGIN PGP SIGNATURE----- >> Comment: GPGTools - http://gpgtools.org >> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ >> >> iQIcBAEBCAAGBQJYdUHCAAoJEBzwKT+lPKRY8lAP/0C6wfLboz4K2MxaHR/86moX >> sKIev9jV+wQ17n0nf1Wj1UA7GDGALye485Z2XMgIjlOaXmufVClfa3MWY07z+bv2 >> R67AmDQ797jlCwTAAhpaRtB0FJmX4cd0EnJkC9r03NCH+kPRIK8G91bkgn8ehw4L >> x0jrgKO/N0UEpshNI/baPxRJRX7yr83g2ZHiKVoFAXM25rEcJNSPOkvlTkBxZ5Yv >> RCQuobinJa9X64p8beYXSkO/9wbP+b5/wcUxpewfvByK9Hits+n33/Mbq5RpKlR7 >> vIHpwDJKlTo2/8ivIDHngIPiRQetlXEgwSWwN+5Fsr+V4bFSh6XnzIBAiB8SNoua >> A9m71pyOoyQhdAAQzNfWwtLPWg9jrDaIRB7bj+HnbrKnCUa4rDyWfUDm4IwanfLW >> QcDUggAgD151UstbSAQafLKJb0TBCWqHpIAvsJwCziOb6LnvtIf5xoLe7s48JZE9 >> 44YfDFI4qg0NSdP59vF/Z1Ho5sveScHrcgmB03BGWVunj9caclqKOWWnJOscAVLJ >> UXQG0B6VvboLJRgKUU4/z0s1a2sOcTLRUz+H1Ib9giqLirI6NVYUSg0lEZdVm5BA >> 0Ctwd6qD7G1j8e4ZiuChC3paCA0nYVhEea0dAVHXB+ZYER89yeoBzPkZnc/vWLEe >> LO1AZaxZ2nDebk0ubBn9 >> =JgPw >> -----END PGP SIGNATURE----- >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >>
smime.p7s
Description: S/MIME cryptographic signature
