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
>> 
>> 

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to