You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jerry Malcolm <te...@malcolms.com> on 2018/01/11 18:47:23 UTC

Monitoring Tomcat JDBC Connection Pool with JConsole?

I followed the instructions to enable JMX on Tomcat.  I added the 
following lines to java config:

-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=8083
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.authenticate=false
-Djava.rmi.server.hostname=localhost

I opened JConsole localhost;8083, and it connected.   I can see CPU, 
heap, classes, and thread graphs.  When I look at the MBean tab, I see a 
Catalina entry and a "DataSource" entry below that.  Expanding that 
gives me a ton of attributes, operations, and notifications for my 
various datasources.  That's fine.  But what I want is to be able to do 
is monitor a graph of the connection pools.  I saw an example graph on a 
3rd party web post from several years ago.  But I can't find anything 
that shows connection pool usage graphs in my JConsole.

What am I missing?

Thanks.

Jerry


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Jerry,

Please don't hijack threads. Start a new thread by sending a fresh
message to users@tomcat.apache.org. Don't just reply to an existing
message in the list and change the subject.

- -chris

On 1/11/18 1:47 PM, Jerry Malcolm wrote:
> I followed the instructions to enable JMX on Tomcat.  I added the 
> following lines to java config:
> 
> -Dcom.sun.management.jmxremote 
> -Dcom.sun.management.jmxremote.port=8083 
> -Dcom.sun.management.jmxremote.ssl=false 
> -Dcom.sun.management.jmxremote.authenticate=false 
> -Djava.rmi.server.hostname=localhost
> 
> I opened JConsole localhost;8083, and it connected.   I can see
> CPU, heap, classes, and thread graphs.  When I look at the MBean
> tab, I see a Catalina entry and a "DataSource" entry below that.
> Expanding that gives me a ton of attributes, operations, and
> notifications for my various datasources.  That's fine.  But what I
> want is to be able to do is monitor a graph of the connection
> pools.  I saw an example graph on a 3rd party web post from several
> years ago.  But I can't find anything that shows connection pool
> usage graphs in my JConsole.
> 
> What am I missing?
> 
> Thanks.
> 
> Jerry
> 
> 
> ---------------------------------------------------------------------
>
> 
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQJRBAEBCAA7FiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlpX558dHGNocmlzQGNo
cmlzdG9waGVyc2NodWx0ei5uZXQACgkQHPApP6U8pFggTw/8DLOx0f30zEwSP4an
n6yAq6MaPQhOCLvGHSGRwspfM9ehsrSduAODO6BMx7/lZt+YTIm5/b8YRByN/UKT
gmUX/bcqpAyz9ZcKefnKqhfNLhBLD5QkRM1xqavfV8gvWuzVrVXRuP0rYKqP62pz
GKsyni6dj318cYq2d2QpdNyWjAMEnzbuOUsfGO5D34Ua/u8v/sHXtMPKBQMjr68h
pBal7OSbvo7tTxWUYQ3PutsnAlanE/lf9zh5bSuFPvFVVR7tPme5AltHt0CU3mlq
Q172uW+DN0faTvWpg0ha+dL5KgAdWRjagmcD30jX5tlTMGJAlbp2ItrCV/1Mdrq9
euAI6sMUdsxREXFfoljEusoE80Wx4HYqtivKQ3evkaVdO/Oq32ZyDQG6b2MiScsP
FvJ/vk8Vc6yyhXCOVb5NfyKRt9pvRyWotzyYzKL0X8GUYB9Asjnlwa1Cj/fRdMDe
DITKO8RIOyvGBXxXzvnHPYIJdCKc1Vsby/5GmiklEigxpcHZZ7mdX7kPnlfmlmdB
C5FrtNtO40Oe3Es5bi0Q17QD4HPw6NIYFwKzlfka6p4XtXW6ejTud6wyfHB2S6KQ
uwA0xHrIttSmh1Sj/dBETF8tcf9N1OyAOdSwoSPaL0G0gDT6n9kEhcNVZGa7uixF
/SXO8YiaWfdPXJv/elF8Dof2Ucs=
=VxSx
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

Posted by Jerry Malcolm <te...@malcolms.com>.
Thanks for the info.  But it appears that the mbean:

      org.apache.tomcat.jdbc.pool.jmx.ConnectionPool

is not registered.  I found some code that collects info from this bean, 
and this mbean doesn't even show up when querying jmx in Tomcat.  I am 
running Tomcat 8.5.  I've tried googling and couldn't find any info on 
how to activate this bean.  Can someone explain how to make it show up?

Thanks.

Jerry


On 1/11/2018 3:41 PM, Simon De Uvarow wrote:
> "No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no
> traiciones, lo que siempre te ha hecho vivir."
>
> On Thu, Jan 11, 2018 at 6:47 PM, Jerry Malcolm <te...@malcolms.com>
> wrote:
>
>> I followed the instructions to enable JMX on Tomcat.  I added the
>> following lines to java config:
>>
>> -Dcom.sun.management.jmxremote
>> -Dcom.sun.management.jmxremote.port=8083
>> -Dcom.sun.management.jmxremote.ssl=false
>> -Dcom.sun.management.jmxremote.authenticate=false
>> -Djava.rmi.server.hostname=localhost
>>
>> I opened JConsole localhost;8083, and it connected.   I can see CPU, heap,
>> classes, and thread graphs.  When I look at the MBean tab, I see a Catalina
>> entry and a "DataSource" entry below that.  Expanding that gives me a ton
>> of attributes, operations, and notifications for my various datasources.
>> That's fine.  But what I want is to be able to do is monitor a graph of the
>> connection pools.  I saw an example graph on a 3rd party web post from
>> several years ago.  But I can't find anything that shows connection pool
>> usage graphs in my JConsole.
>>
>> What am I missing?
>>
>> Thanks.
>>
>> Jerry
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
> Maybe you can try jvisualvm instead of JConsole.
> The binary is in the /bin folder of the JAVA_HOME.
> You can also add plugins to it. Maybe there is a plugin for your need.
>
> regards,
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Re: Monitoring Tomcat JDBC Connection Pool with JConsole?

Posted by Simon De Uvarow <sd...@gmail.com>.
"No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no
traiciones, lo que siempre te ha hecho vivir."

On Thu, Jan 11, 2018 at 6:47 PM, Jerry Malcolm <te...@malcolms.com>
wrote:

> I followed the instructions to enable JMX on Tomcat.  I added the
> following lines to java config:
>
> -Dcom.sun.management.jmxremote
> -Dcom.sun.management.jmxremote.port=8083
> -Dcom.sun.management.jmxremote.ssl=false
> -Dcom.sun.management.jmxremote.authenticate=false
> -Djava.rmi.server.hostname=localhost
>
> I opened JConsole localhost;8083, and it connected.   I can see CPU, heap,
> classes, and thread graphs.  When I look at the MBean tab, I see a Catalina
> entry and a "DataSource" entry below that.  Expanding that gives me a ton
> of attributes, operations, and notifications for my various datasources.
> That's fine.  But what I want is to be able to do is monitor a graph of the
> connection pools.  I saw an example graph on a 3rd party web post from
> several years ago.  But I can't find anything that shows connection pool
> usage graphs in my JConsole.
>
> What am I missing?
>
> Thanks.
>
> Jerry
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
Maybe you can try jvisualvm instead of JConsole.
The binary is in the /bin folder of the JAVA_HOME.
You can also add plugins to it. Maybe there is a plugin for your need.

regards,