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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.