6 Replies Latest reply on May 17, 2016 9:45 PM by Yoshimasa Tanabe

    Empty pool statistics after moving to Wildfly 10

    Adam Lang Newbie

      Hello,

       

      In a Wildfly 8 application we run, from the jboss-cli, if I run:

      /subsystem=datasources/xa-data-source=<jndi-name>:read-resource(include-runtime=true,recursive=true)

      I get pool statistics.

       

      In a version we have that is using Wildfly 10, and I run (in the new version, the datasource isn't an xa):

      /subsystem=datasources/data-source=<jndi-name>:read-resource(include-runtime=true,recursive=true)

       

      I get and haven't been able to figure out if it is a config value I need to turn on somewhere, the command structure is different or something else:

      {

          "outcome" => "success",

          "result" => {

              "allocation-retry" => undefined,

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

              "allow-multiple-users" => false,

              "background-validation" => undefined,

              "background-validation-millis" => undefined,

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

              "capacity-decrementer-class" => undefined,

              "capacity-decrementer-properties" => undefined,

              "capacity-incrementer-class" => undefined,

              "capacity-incrementer-properties" => undefined,

              "check-valid-connection-sql" => "/* ping */ SELECT 1",

              "connectable" => false,

              "connection-listener-class" => undefined,

              "connection-listener-property" => undefined,

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

              "datasource-class" => undefined,

              "driver-class" => undefined,

              "driver-name" => "mysql",

              "enabled" => true,

              "enlistment-trace" => true,

              "exception-sorter-class-name" => "org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter",

              "exception-sorter-properties" => undefined,

              "flush-strategy" => undefined,

              "idle-timeout-minutes" => undefined,

              "initial-pool-size" => undefined,

              "jndi-name" => "java:/<jndi-name>",

              "jta" => true,

              "max-pool-size" => 40,

              "mcp" => "org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool",

              "min-pool-size" => 10,

              "new-connection-sql" => undefined,

              "password" => "",

              "pool-prefill" => true,

              "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,

              "spy" => false,

              "stale-connection-checker-class-name" => undefined,

              "stale-connection-checker-properties" => undefined,

              "statistics-enabled" => false,

              "track-statements" => "NOWARN",

              "tracking" => false,

              "transaction-isolation" => "TRANSACTION_REPEATABLE_READ",

              "url-delimiter" => undefined,

              "url-selector-strategy-class-name" => undefined,

              "use-ccm" => true,

              "use-fast-fail" => false,

              "use-java-context" => true,

              "use-try-lock" => undefined,

              "user-name" => "k3",

              "valid-connection-checker-class-name" => undefined,

              "valid-connection-checker-properties" => undefined,

              "validate-on-match" => undefined,

              "connection-properties" => undefined,

              "statistics" => {

                  "pool" => {

                      "ActiveCount" => 0,

                      "AvailableCount" => 0,

                      "AverageBlockingTime" => 0L,

                      "AverageCreationTime" => 0L,

                      "AverageGetTime" => 0L,

                      "AveragePoolTime" => 0L,

                      "AverageUsageTime" => 0L,

                      "BlockingFailureCount" => 0,

                      "CreatedCount" => 0,

                      "DestroyedCount" => 0,

                      "IdleCount" => 0,

                      "InUseCount" => 0,

                      "MaxCreationTime" => 0L,

                      "MaxGetTime" => 0L,

                      "MaxPoolTime" => 0L,

                      "MaxUsageTime" => 0L,

                      "MaxUsedCount" => 0,

                      "MaxWaitCount" => 0,

                      "MaxWaitTime" => 0L,

                      "TimedOut" => 0,

                      "TotalBlockingTime" => 0L,

                      "TotalCreationTime" => 0L,

                      "TotalGetTime" => 0L,

                      "TotalPoolTime" => 0L,

                      "TotalUsageTime" => 0L,

                      "WaitCount" => 0,

                      "XACommitAverageTime" => 0L,

                      "XACommitCount" => 0L,

                      "XACommitMaxTime" => 0L,

                      "XACommitTotalTime" => 0L,

                      "XAEndAverageTime" => 0L,

                      "XAEndCount" => 0L,

                      "XAEndMaxTime" => 0L,

                      "XAEndTotalTime" => 0L,

                      "XAForgetAverageTime" => 0L,

                      "XAForgetCount" => 0L,

                      "XAForgetMaxTime" => 0L,

                      "XAForgetTotalTime" => 0L,

                      "XAPrepareAverageTime" => 0L,

                      "XAPrepareCount" => 0L,

                      "XAPrepareMaxTime" => 0L,

                      "XAPrepareTotalTime" => 0L,

                      "XARecoverAverageTime" => 0L,

                      "XARecoverCount" => 0L,

                      "XARecoverMaxTime" => 0L,

                      "XARecoverTotalTime" => 0L,

                      "XARollbackAverageTime" => 0L,

                      "XARollbackCount" => 0L,

                      "XARollbackMaxTime" => 0L,

                      "XARollbackTotalTime" => 0L,

                      "XAStartAverageTime" => 0L,

                      "XAStartCount" => 0L,

                      "XAStartMaxTime" => 0L,

                      "XAStartTotalTime" => 0L,

                      "statistics-enabled" => false

                  },

                  "jdbc" => {

                      "PreparedStatementCacheAccessCount" => 0L,

                      "PreparedStatementCacheAddCount" => 0L,

                      "PreparedStatementCacheCurrentSize" => 0,

                      "PreparedStatementCacheDeleteCount" => 0L,

                      "PreparedStatementCacheHitCount" => 0L,

                      "PreparedStatementCacheMissCount" => 0L,

                      "statistics-enabled" => false

                  }

              }

          }

      }