tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joleen Barker <oldenuf2no...@gmail.com>
Subject Re: Best way to find out how many DB connections that are open at any given time
Date Tue, 10 Jan 2017 17:58:10 GMT
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

tcp        0      0  cpmfttapt21.51186      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.51198      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.51211      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.55213      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.55214      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.55215      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.57493      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.57495      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.35153      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.35154      cpmfttdbt01-vip..1526
ESTABLISHED

tcp        0      0  cpmfttapt21.35157      cpmfttdbt01-vip..1526
ESTABLISHED

On Tue, Jan 10, 2017 at 12:40 PM, André Warnier (tomcat) <aw@ice-sa.com>
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
>>
>> tcp        0      0  cpmfttapt21.51186      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.51198      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.51211      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.55213      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.55214      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.55215      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.57493      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.57495      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.35153      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.35154      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> tcp        0      0  cpmfttapt21.35157      cpmfttdbt01-vip..1526
>> ESTABLISHED
>>
>> On Tue, Jan 10, 2017 at 11:59 AM, Joleen Barker <oldenuf2nobtr@gmail.com>
>> 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) <aw@ice-sa.com>
>>> 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-unsubscribe@tomcat.apache.org
>>>> For additional commands, e-mail: users-help@tomcat.apache.org
>>>>
>>>>
>>>>
>>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message