WildFly DataSource Monitoring: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 37: Line 37:
==Prepared Statements Statistics==
==Prepared Statements Statistics==


"jboss.as:subsystem=datasources,xa-data-source=<ds-name>,statistics=jdbc"
<pre>
jboss.as:subsystem=datasources,xa-data-source=<ds-name>,statistics=jdbc
</pre>
 
The following JMX attributes are available:


====PreparedStatementCacheAccessCount====
====PreparedStatementCacheAccessCount====

Revision as of 16:01, 11 May 2017

Internal

Relevance

  • EAP 6.4.10

JMX Monitoring

JDBC DataSource connection pool and prepared statements statistics are available from the “datasources” subsystem, using the following ObjectNames:

Connection Pool Statistics

jboss.as:subsystem=datasources,xa-data-source=<ds-name>,statistics=pool

The following JMX attributes are available:

ActiveCount

AvailableCount

AverageBlockingTime

AverageCreationTime

CreatedCount

DestroyedCount

InUseCount

MaxCreationTime

MaxUsedCount

MaxWaitCount

MaxWaitTime

TimedOut

TotalBlockingTime

TotalCreationTime

Prepared Statements Statistics

jboss.as:subsystem=datasources,xa-data-source=<ds-name>,statistics=jdbc

The following JMX attributes are available:

PreparedStatementCacheAccessCount

PreparedStatementCacheAddCount

PreparedStatementCacheCurrentSize

PreparedStatementCacheDeleteCount

PreparedStatementCacheHitCount

PreparedStatementCacheMissCount