Re: Best way to find out how many DB connections that are open at any given time
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: > > 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
Re: Best way to find out how many DB connections that are open at any given time
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 > >
Re: Best way to find out how many DB connections that are open at any given time
-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
Re: Best way to find out how many DB connections that are open at any given time
Thank you Andre and calder. On the AIX side this worked. I am limited also I think due to the shell. If I use the -p tcp option it gives me a long list of counts of TCP connections and bytes. This command gave me similar on AIX: netstat -a|grep 1526 tcp0 0 cpmfttapt21.51186 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.51198 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.51211 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55213 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55214 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55215 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.57493 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.57495 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35153 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35154 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35157 cpmfttdbt01-vip..1526 ESTABLISHED On Tue, Jan 10, 2017 at 12:40 PM, André Warnier (tomcat)wrote: > On 10.01.2017 18:06, Joleen Barker wrote: > >> Hi Andre - I played around a little more and ran the command netstat -a | >> grep 1526 which is the port number and received information that looks >> like >> 11 connections are open at this time. Do you know what the number is that >> follows the machine name in the forth column for example the 51186? >> > > I do not know AIX. Maybe try : > netstat -h > and/or > man netstat > > (and also try the command without the grep, to see the column headers) > > > >> netstat -a | grep 1526 >> >> tcp0 0 cpmfttapt21.51186 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.51198 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.51211 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.55213 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.55214 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.55215 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.57493 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.57495 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.35153 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.35154 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> tcp0 0 cpmfttapt21.35157 cpmfttdbt01-vip..1526 >> ESTABLISHED >> >> On Tue, Jan 10, 2017 at 11:59 AM, Joleen Barker >> wrote: >> >> Hello Filippo - I do not have JConsole available and the proposed idea is >>> past my knowledge level. >>> >>> Hello André - This was an interesting idea but it didn't work for me. I >>> only have the ksh available and could only use netstat -p tcp but the >>> output didn't make sense to me. >>> >>> On Tue, Jan 10, 2017 at 11:24 AM, André Warnier (tomcat) >>> wrote: >>> >>> On 10.01.2017 17:10, 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. > > Thank you for the help in advance. > > > Hi. Maybe an "out of the box" answer, not using java. I don't know how the following commands fare under AIX, but on a Linux system, the OS-level command : ~# netstat -pan --tcp | grep ESTABLISHED will show you pretty much all TCP connections that are established between any process and any other, local or remote. Sample output : tcp6 0 0 127.0.0.1:45095 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53564
Re: Best way to find out how many DB connections that are open at any given time
On 10.01.2017 18:06, Joleen Barker wrote: Hi Andre - I played around a little more and ran the command netstat -a | grep 1526 which is the port number and received information that looks like 11 connections are open at this time. Do you know what the number is that follows the machine name in the forth column for example the 51186? I do not know AIX. Maybe try : netstat -h and/or man netstat (and also try the command without the grep, to see the column headers) netstat -a | grep 1526 tcp0 0 cpmfttapt21.51186 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.51198 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.51211 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55213 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55214 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55215 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.57493 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.57495 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35153 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35154 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35157 cpmfttdbt01-vip..1526 ESTABLISHED On Tue, Jan 10, 2017 at 11:59 AM, Joleen Barkerwrote: Hello Filippo - I do not have JConsole available and the proposed idea is past my knowledge level. Hello André - This was an interesting idea but it didn't work for me. I only have the ksh available and could only use netstat -p tcp but the output didn't make sense to me. On Tue, Jan 10, 2017 at 11:24 AM, André Warnier (tomcat) wrote: On 10.01.2017 17:10, 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. Thank you for the help in advance. Hi. Maybe an "out of the box" answer, not using java. I don't know how the following commands fare under AIX, but on a Linux system, the OS-level command : ~# netstat -pan --tcp | grep ESTABLISHED will show you pretty much all TCP connections that are established between any process and any other, local or remote. Sample output : tcp6 0 0 127.0.0.1:45095 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53564 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53677 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53659 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53656 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53620 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53608 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:45142 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:43558 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:45128 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:45069 127.0.0.1:11002 ESTABLISHED 11096/java I presume that you could easily find out the process-id of your Tomcat, and the port number under which the database is accessed. It would be a simple matter to "grep" the above and count the lines, to get the answer you seem to want. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Best way to find out how many DB connections that are open at any given time
The fourth column is the "Local Address" (local machine) - in the case, a machine-name (vs IP address) and the port value (such as 51186) the machine is listening on. Of course, the machine-name will resolve to an IP address, so in some netstat output, you might see tcp 0 0 10.240.100.20:51186 10.240.100.55:1526 ESTABLISHED - or possibly - tcp 0 0 0.0.0.0:51186 10.240.100.55:1526 ESTABLISHED - or possibly - tcp 0 0 127.0.0.1:51186 10.240.100.55:1526 ESTABLISHED This Local Address is the address to which the socket in question is bound to and which it receives connections on. The fifth column is the "Foreign Address" (destination machine), sometimes shown with its port# (as is the case here) and a connection is established. On Tue, Jan 10, 2017 at 5:06 PM, Joleen Barkerwrote: > Hi Andre - I played around a little more and ran the command netstat -a | > grep 1526 which is the port number and received information that looks like > 11 connections are open at this time. Do you know what the number is that > follows the machine name in the forth column for example the 51186? > > netstat -a | grep 1526 > > tcp0 0 cpmfttapt21.51186 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.51198 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.51211 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.55213 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.55214 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.55215 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.57493 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.57495 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.35153 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.35154 cpmfttdbt01-vip..1526 > ESTABLISHED > > tcp0 0 cpmfttapt21.35157 cpmfttdbt01-vip..1526 > ESTABLISHED > > On Tue, Jan 10, 2017 at 11:59 AM, Joleen Barker > wrote: > > > Hello Filippo - I do not have JConsole available and the proposed idea is > > past my knowledge level. > > > > Hello André - This was an interesting idea but it didn't work for me. I > > only have the ksh available and could only use netstat -p tcp but the > > output didn't make sense to me. > > > > On Tue, Jan 10, 2017 at 11:24 AM, André Warnier (tomcat) > > wrote: > > > >> On 10.01.2017 17:10, 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. > >>> > >>> Thank you for the help in advance. > >>> > >>> > >> Hi. > >> Maybe an "out of the box" answer, not using java. > >> I don't know how the following commands fare under AIX, but on a Linux > >> system, the OS-level command : > >> ~# netstat -pan --tcp | grep ESTABLISHED > >> will show you pretty much all TCP connections that are established > >> between any process and any other, local or remote. > >> > >> Sample output : > >> > >> tcp6 0 0 127.0.0.1:45095 127.0.0.1:11002 > >> ESTABLISHED 11096/java > >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53564 > >> ESTABLISHED 2677/java > >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53677 > >> ESTABLISHED 2677/java > >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53659 > >> ESTABLISHED 2677/java > >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53656 > >> ESTABLISHED 2677/java > >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53620 > >> ESTABLISHED 2677/java > >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53608 > >> ESTABLISHED 2677/java > >> tcp6 0 0 127.0.0.1:45142 127.0.0.1:11002 > >> ESTABLISHED 11096/java > >> tcp6 0 0 127.0.0.1:43558
Re: Best way to find out how many DB connections that are open at any given time
Hi Andre - I played around a little more and ran the command netstat -a | grep 1526 which is the port number and received information that looks like 11 connections are open at this time. Do you know what the number is that follows the machine name in the forth column for example the 51186? netstat -a | grep 1526 tcp0 0 cpmfttapt21.51186 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.51198 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.51211 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55213 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55214 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.55215 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.57493 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.57495 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35153 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35154 cpmfttdbt01-vip..1526 ESTABLISHED tcp0 0 cpmfttapt21.35157 cpmfttdbt01-vip..1526 ESTABLISHED On Tue, Jan 10, 2017 at 11:59 AM, Joleen Barkerwrote: > Hello Filippo - I do not have JConsole available and the proposed idea is > past my knowledge level. > > Hello André - This was an interesting idea but it didn't work for me. I > only have the ksh available and could only use netstat -p tcp but the > output didn't make sense to me. > > On Tue, Jan 10, 2017 at 11:24 AM, André Warnier (tomcat) > wrote: > >> On 10.01.2017 17:10, 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. >>> >>> Thank you for the help in advance. >>> >>> >> Hi. >> Maybe an "out of the box" answer, not using java. >> I don't know how the following commands fare under AIX, but on a Linux >> system, the OS-level command : >> ~# netstat -pan --tcp | grep ESTABLISHED >> will show you pretty much all TCP connections that are established >> between any process and any other, local or remote. >> >> Sample output : >> >> tcp6 0 0 127.0.0.1:45095 127.0.0.1:11002 >> ESTABLISHED 11096/java >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53564 >> ESTABLISHED 2677/java >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53677 >> ESTABLISHED 2677/java >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53659 >> ESTABLISHED 2677/java >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53656 >> ESTABLISHED 2677/java >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53620 >> ESTABLISHED 2677/java >> tcp6 0 0 127.0.0.1:8009 127.0.0.1:53608 >> ESTABLISHED 2677/java >> tcp6 0 0 127.0.0.1:45142 127.0.0.1:11002 >> ESTABLISHED 11096/java >> tcp6 0 0 127.0.0.1:43558 127.0.0.1:11002 >> ESTABLISHED 11096/java >> tcp6 0 0 127.0.0.1:45128 127.0.0.1:11002 >> ESTABLISHED 11096/java >> tcp6 0 0 127.0.0.1:45069 127.0.0.1:11002 >> ESTABLISHED 11096/java >> >> I presume that you could easily find out the process-id of your Tomcat, >> and the port number under which the database is accessed. >> It would be a simple matter to "grep" the above and count the lines, to >> get the answer you seem to want. >> >> >> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> >
Re: Best way to find out how many DB connections that are open at any given time
Hello Filippo - I do not have JConsole available and the proposed idea is past my knowledge level. Hello André - This was an interesting idea but it didn't work for me. I only have the ksh available and could only use netstat -p tcp but the output didn't make sense to me. On Tue, Jan 10, 2017 at 11:24 AM, André Warnier (tomcat)wrote: > On 10.01.2017 17:10, 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. >> >> Thank you for the help in advance. >> >> > Hi. > Maybe an "out of the box" answer, not using java. > I don't know how the following commands fare under AIX, but on a Linux > system, the OS-level command : > ~# netstat -pan --tcp | grep ESTABLISHED > will show you pretty much all TCP connections that are established between > any process and any other, local or remote. > > Sample output : > > tcp6 0 0 127.0.0.1:45095 127.0.0.1:11002 > ESTABLISHED 11096/java > tcp6 0 0 127.0.0.1:8009 127.0.0.1:53564 > ESTABLISHED 2677/java > tcp6 0 0 127.0.0.1:8009 127.0.0.1:53677 > ESTABLISHED 2677/java > tcp6 0 0 127.0.0.1:8009 127.0.0.1:53659 > ESTABLISHED 2677/java > tcp6 0 0 127.0.0.1:8009 127.0.0.1:53656 > ESTABLISHED 2677/java > tcp6 0 0 127.0.0.1:8009 127.0.0.1:53620 > ESTABLISHED 2677/java > tcp6 0 0 127.0.0.1:8009 127.0.0.1:53608 > ESTABLISHED 2677/java > tcp6 0 0 127.0.0.1:45142 127.0.0.1:11002 > ESTABLISHED 11096/java > tcp6 0 0 127.0.0.1:43558 127.0.0.1:11002 > ESTABLISHED 11096/java > tcp6 0 0 127.0.0.1:45128 127.0.0.1:11002 > ESTABLISHED 11096/java > tcp6 0 0 127.0.0.1:45069 127.0.0.1:11002 > ESTABLISHED 11096/java > > I presume that you could easily find out the process-id of your Tomcat, > and the port number under which the database is accessed. > It would be a simple matter to "grep" the above and count the lines, to > get the answer you seem to want. > > > > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
Re: Best way to find out how many DB connections that are open at any given time
On 10.01.2017 17:10, 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. Thank you for the help in advance. Hi. Maybe an "out of the box" answer, not using java. I don't know how the following commands fare under AIX, but on a Linux system, the OS-level command : ~# netstat -pan --tcp | grep ESTABLISHED will show you pretty much all TCP connections that are established between any process and any other, local or remote. Sample output : tcp6 0 0 127.0.0.1:45095 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53564 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53677 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53659 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53656 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53620 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:8009 127.0.0.1:53608 ESTABLISHED 2677/java tcp6 0 0 127.0.0.1:45142 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:43558 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:45128 127.0.0.1:11002 ESTABLISHED 11096/java tcp6 0 0 127.0.0.1:45069 127.0.0.1:11002 ESTABLISHED 11096/java I presume that you could easily find out the process-id of your Tomcat, and the port number under which the database is accessed. It would be a simple matter to "grep" the above and count the lines, to get the answer you seem to want. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Best way to find out how many DB connections that are open at any given time
Ciao Joleen, maybe you could retrieve this information connecting via JMX (JConsole, VisualVM) to the tomcat instances. According to the way the datasource is configured, you could find a JMX bean exposing this information. Before that, tomcat should be launched in a way JMX connections are allowed from remote. For example, connecting via JMX I can find something under Catalina/Data Source/etc etc. HTH On Tue, Jan 10, 2017 at 5:10 PM, Joleen Barkerwrote: > 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. > > Thank you for the help in advance. > > Joleen >
Best way to find out how many DB connections that are open at any given time
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. Thank you for the help in advance. Joleen