Explanation of the JCA JDBC pool statistics for JBoss EAP

Solution Verified - Updated -

Issue

  • I would like to know the official explanation on the metrics of jdbc connection pool statistics. For example:
    • What is the meaning of MaxUsedCount and MaxCreationTime?
    • What is the meaning of the ActiveCount and AvailableCount?
    • What are the units of measurement for each of these?
  • How are datasource metrics calculated?
  • What are the meanings of the data-source statistics reported by the CLI statistics read command?
[standalone@localhost:9999 /] /subsystem=datasources/data-source=MySqlDS2/statistics=pool:read-resource(include-runtime=true)
{
    "outcome" => "success",
    "result" => {
        "ActiveCount" => "5",
        "AvailableCount" => "2",
        "AverageBlockingTime" => "0",
        "AverageCreationTime" => "83",
        "CreatedCount" => "5",
        "DestroyedCount" => "0",
        "InUseCount" => "3",
        "MaxCreationTime" => "335",
        "MaxUsedCount" => "3",
        "MaxWaitCount" => "0",
        "MaxWaitTime" => "0",
        "TimedOut" => "0",
        "TotalBlockingTime" => "0",
        "TotalCreationTime" => "419"
    }
}

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 7
    • 6
  • Java Connector Architecture (JCA)
    • 1.7
    • 1.6
  • IronJacamar 1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In