[wildfly-dev] JDBC stats, clarification needed

[Eduardo Sant'Ana da Silva]

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 at gmail.com> wrote:

> 
> /**
>  * JBQA-6456 Test jdbc statistics of data sources
>  *
>  * @author <a href="vrastsel at 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 at redhat.com> wrote:
> 
>> PreparedStatementCacheAccessCount
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/wildfly-dev/attachments/20140827/27b03df2/attachment.html