Skip to content

Check wildfly-xa-datasource-stats

Overview

This check plugin returns metrics of XA datasources of a WildFly server, using its HTTP-JSON based API (JBossAS REST Management API). This allows us to monitor the application server without any additional configuration and installation - no need to deploy WAR-Agents like Jolokia. The plugin supports both standalone mode and domain mode.

Tested with WildFly 11 and WildFly 23+.

Hints:

  • See additional notes for all wildfly monitoring plugins

  • The check recognizes if a datasource does not support statistics.

  • To enable database statistics:

    • Open the WildFly Admin Console
    • Go to Configuration > Subsystems > Datasources & Drivers > Datasources
    • Select your datasource
    • Click on View > Tab Attributes > Edit "Statistics Enabled"

Fact Sheet

Fact Value
Check Plugin Download https://github.com/Linuxfabrik/monitoring-plugins/tree/main/check-plugins/wildfly-xa-datasource-stats
Check Interval Recommendation Once a minute
Can be called without parameters No
Compiled for Windows No

Help

usage: wildfly-xa-datasource-stats [-h] [-V] [--always-ok] [--critical CRIT]
                                   [--datasource DATASOURCE] [--insecure]
                                   [--instance INSTANCE]
                                   [--mode {standalone,domain}] [--no-proxy]
                                   [--node NODE] -p PASSWORD
                                   [--timeout TIMEOUT] [--url URL]
                                   --username USERNAME [--warning WARN]

Returns metrics about XA Datasources of a Wildfly/JBossAS over HTTP.

options:
  -h, --help            show this help message and exit
  -V, --version         show program's version number and exit
  --always-ok           Always returns OK.
  --critical CRIT       Set the critical threshold.
  --datasource DATASOURCE
                        The name of a specific datasource (repeating).
                        Default: None
  --insecure            This option explicitly allows to perform "insecure"
                        SSL connections. Default: False
  --instance INSTANCE   The instance (server-config) to check if running in
                        domain mode.
  --mode {standalone,domain}
                        The mode the server is running.
  --no-proxy            Do not use a proxy. Default: False
  --node NODE           The node (host) if running in domain mode.
  -p, --password PASSWORD
                        WildFly API password.
  --timeout TIMEOUT     Network timeout in seconds. Default: 3 (seconds)
  --url URL             WildFly API URL. Default: http://localhost:9990
  --username USERNAME   WildFly API username. Default: wildfly-monitoring
  --warning WARN        Set the warning threshold.

Usage Examples

# return stats on all datasources
./wildfly-xa-datasource-stats --username wildfly-monitoring --password password --url http://wildfly:9990 --warning 80 --critical 90

# return stats on specific datasources
./wildfly-xa-datasource-stats --username wildfly-monitoring --password password --url http://wildfly:9990 --warning 80 --critical 90 --datasource MyFirstDS --datasource MySecondDS

Output:

MyFirstDS: 0.0% active used (0/20), 0.0% max used (0/20); Statistics are not enabled for data source MySecondDS

States

Triggers an alarm on usage in percent.

  • WARN or CRIT if active or max used datapool connections are above certain thresholds (default 80/90%).

Perfdata / Metrics

Name Type Description
xa-ds-NAME-active Number The number of active connections. Each of the connections is either in use by an application or available in the pool.
xa-ds-NAME-active-pct Percentage xa-ds-<name>-active / xa-ds-<name>-available * 100
xa-ds-NAME-available Number The number of available connections in the pool.
xa-ds-NAME-blockingfailurecount Number
xa-ds-NAME-createdcount Number The number of connections created.
xa-ds-NAME-destroyedcount Number The number of connections destroyed.
xa-ds-NAME-idlecount Number
xa-ds-NAME-inusecount Number The number of connections currently in use.
xa-ds-NAME-maxused Number The maximum number of connections used.
xa-ds-NAME-maxused-pct Percentage xa-ds-<name>-maxused / xa-ds-<name>-available * 100
xa-ds-NAME-maxwaitcount Number The maximum number of requests waiting for a connection at the same time.
xa-ds-NAME-waitcount Number The number of requests that had to wait for a connection.
xa-ds-NAME-xacommitcount Number
xa-ds-NAME-xaendcount Number
xa-ds-NAME-xaforgetcount Number
xa-ds-NAME-xapreparecount Number
xa-ds-NAME-xarecovercount Number
xa-ds-NAME-xarollbackcount Number
xa-ds-NAME-xastartcount Number

Also have a look at https://access.redhat.com/documentation/en-us/jboss_enterprise_application_platform/6.2/html/administration_and_configuration_guide/datasource_statistics.

Credits, License