4:10 a.m.
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@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
5:58 a.m.
/**
* JBQA-6456 Test jdbc statistics of data sources
*
* @author <a href="vrastsel(a)redhat.com">Vladimir Rastseluev</a>
*/
@RunWith(Arquillian.class)
@ServerSetup(DataSourceJdbcStatisticsTestCase.TestCaseSetup.class)
public class DataSourceJdbcStatisticsTestCase {
...
public StringBuffer assertStatisticsSet(boolean yes, ModelNode statisticNode) throws
Exception {
StringBuffer sb = new StringBuffer();
String[] params = { "PreparedStatementCacheAccessCount", // The
number of times that the statement cache was
// accessed
"PreparedStatementCacheAddCount", // The number of
statements added to the statement cache
"PreparedStatementCacheCurrentSize", // The number of
prepared and callable statements currently cached in
// the statement cache
"PreparedStatementCacheDeleteCount", // The number of
statements discarded from the cache
"PreparedStatementCacheHitCount" // The number of times that
statements from the cache were used
};
On Aug 27, 2014, at 6:10 AM, Heiko Braun <hbraun(a)redhat.com> wrote:
PreparedStatementCacheAccessCount
6:19 a.m.
You have 41 prepared statment access to the cache. This not mean that you have 41
different statements.
This means that you have actually only 6 different. Those 6 were added initially to the
cache and
the other 35 access found them on the cache, so you have 35 hits.
On Aug 27, 2014, at 7:58 AM, Eduardo Sant'Ana da Silva
<eduardo.santanadasilva(a)gmail.com> wrote:
/**
* JBQA-6456 Test jdbc statistics of data sources
*
* @author <a href="vrastsel(a)redhat.com">Vladimir Rastseluev</a>
*/
@RunWith(Arquillian.class)
@ServerSetup(DataSourceJdbcStatisticsTestCase.TestCaseSetup.class)
public class DataSourceJdbcStatisticsTestCase {
...
public StringBuffer assertStatisticsSet(boolean yes, ModelNode statisticNode) throws
Exception {
StringBuffer sb = new StringBuffer();
String[] params = { "PreparedStatementCacheAccessCount", // The
number of times that the statement cache was
// accessed
"PreparedStatementCacheAddCount", // The number of
statements added to the statement cache
"PreparedStatementCacheCurrentSize", // The number of
prepared and callable statements currently cached in
// the statement cache
"PreparedStatementCacheDeleteCount", // The number of
statements discarded from the cache
"PreparedStatementCacheHitCount" // The number of times
that statements from the cache were used
};
On Aug 27, 2014, at 6:10 AM, Heiko Braun <hbraun(a)redhat.com> wrote:
> PreparedStatementCacheAccessCount
6:33 a.m.
"Add count" and "miss count" are redundant attributes to me.
I think that only the "miss count" should be used since in cache terms this
is more commonly used and you will surely add them to cache in case of a
miss.
2014-08-27 6:10 GMT-03:00 Heiko Braun <hbraun(a)redhat.com>:
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@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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/wildfly-dev
--
__________________________
Eduardo Sant'Ana da Silva - Dr.
Pesquisador / Consultor de TI
7:42 a.m.
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@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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/wildfly-dev
3752
days inactive
3752
days old
4 comments
4 participants
participants (4)
-
Andrig Miller -
Eduardo Sant'Ana da Silva -
Eduardo Sant´Ana da Silva
-
Heiko Braun