[ulrich-scholz]

We found it. The following (for a different data source) works well for us:

http://localhost:9990/management/host/master/server/CENTRAL/subsystem/datasources/xa-data-source/WORKFLOWDB_Pool/statistics/pool?include-runtime=true

Thanks

[jeryma]

hi,I used this  well on my standalone ctl .but I can't use this on my domain ctl .

It seems that there doesn't exsit   "statistics=pool" on my domain ctl.

[domain@10.19.222.53:9999 data-source=MysqlDS] :read-resource(include-runtime=true)

{

    "outcome" => "success",

    "result" => {

        "allocation-retry" => undefined,

        "allocation-retry-wait-millis" => undefined,

        "background-validation" => false,

        "background-validation-millis" => undefined,

        "blocking-timeout-wait-millis" => undefined,

        "check-valid-connection-sql" => undefined,

        "connection-properties" => undefined,

        "connection-url" => "jdbc:mysql://10.22.4.46:3306/mysql",

        "datasource-class" => undefined,

        "driver-class" => "com.mysql.jdbc.Driver",

        "driver-name" => "mysql",

        "enabled" => true,

        "exception-sorter-class-name" => undefined,

        "exception-sorter-properties" => undefined,

        "flush-strategy" => undefined,

        "idle-timeout-minutes" => undefined,

        "jndi-name" => "java:jboss/datasources/MysqlDS",

        "jta" => "true",

        "max-pool-size" => 100,

        "min-pool-size" => 10,

        "new-connection-sql" => undefined,

        "password" => "root",

        "pool-prefill" => undefined,

        "pool-use-strict-min" => undefined,

        "prepared-statements-cache-size" => undefined,

        "query-timeout" => undefined,

        "reauth-plugin-class-name" => undefined,

        "reauth-plugin-properties" => undefined,

        "security-domain" => undefined,

        "set-tx-query-timeout" => "false",

        "share-prepared-statements" => false,

how can I monitor datasouce pool on my domain cluster?  what should I do ?

thanks for advise.

[rohanemmanuel]

why does it show the Available count as 20 always in pool usuage , even when i specify the min pool n max pool values. from where exactly this value 20 is being picked up from. please advise

[weboctave]

For domain, you can monitor per node.

jboss-cli.sh --connect controller=[yourdomaincontroller:port] command="/host=host1/server=server1/subsystem=datasources/data-source=ExampleDS/statistics=pool:read-resource(include-runtime=true)"

Replace host1 with your host name in the host*.xml.

Replace server1 with your server name in the server-group.