1 2 Previous Next 18 Replies Latest reply on Sep 16, 2014 9:54 AM by weboctave Go to original post Branched to a new discussion.
      • 16. Re: Monitoring datasource connection pool on JBoss AS7.1
        xiaojie Ma Newbie

        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.

        • 17. Re: Monitoring datasource connection pool on JBoss AS7.1
          Rohan Emmanuel Newbie

          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

          • 18. Re: Monitoring datasource connection pool on JBoss AS7.1
            weboctave Newbie

            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.

            1 2 Previous Next