[wildfly-dev] JDBC stats, clarification needed

Andrig Miller anmiller at redhat.com
Wed Aug 27 08:42:04 EDT 2014


The AccessCount is the total number of accesses, so it is the AddCount plus the DeleteCount plus the MissCount, plus the HitCount. 

As you can see from the numbers, 6 + 0 + 0 + 35 = 41. 

Andy 

----- Original Message -----

> I am trying to make sense of the data source stats and need some help. Can
> someone explain these figures to me? The hit count is smaller then the
> access count. I would expect the other accesses to show up in the miss
> count, but they don't. Is it a bug or do I misinterpret these numbers?

> [standalone at localhost:9999 /]
> /subsystem=datasources/data-source=ExampleDS/statistics=jdbc:read-resource(include-runtime=true)
> {
> "outcome" => "success",
> "result" => {
> "PreparedStatementCacheAccessCount" => "41",
> "PreparedStatementCacheAddCount" => "6",
> "PreparedStatementCacheCurrentSize" => "6",
> "PreparedStatementCacheDeleteCount" => "0",
> "PreparedStatementCacheHitCount" => "35",
> "PreparedStatementCacheMissCount" => "0",
> "statistics-enabled" => true
> }
> }

> Regards, Heiko

> _______________________________________________
> wildfly-dev mailing list
> wildfly-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/wildfly-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/wildfly-dev/attachments/20140827/31644040/attachment-0001.html 


More information about the wildfly-dev mailing list