<html><body><div style="font-family: Arial; font-size: 12pt; color: #000000"><div>The AccessCount is the total number of accesses, so it is the AddCount plus the DeleteCount plus the MissCount, plus the HitCount.<br></div><div><br></div><div>As you can see from the numbers, 6 + 0 + 0 + 35 = 41.<br></div><div><br></div><div>Andy<br></div><div><br></div><hr id="zwchr"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div><br></div><div><br></div><div>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?</div><div><br></div><div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;">[standalone@localhost:9999 /] /subsystem=datasources/data-source=ExampleDS/statistics=jdbc:read-resource(include-runtime=true)</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;">{</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "outcome" => "success",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "result" => {</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "PreparedStatementCacheAccessCount" => "41",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "PreparedStatementCacheAddCount" => "6",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "PreparedStatementCacheCurrentSize" => "6",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "PreparedStatementCacheDeleteCount" => "0",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70);" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946;"> "PreparedStatementCacheHitCount" => "35",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70); position: static; z-index: auto;" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946; position: static; z-index: auto;"> "PreparedStatementCacheMissCount" => "0",</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70); position: static; z-index: auto;" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946; position: static; z-index: auto;"> "statistics-enabled" => true</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70); position: static; z-index: auto;" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946; position: static; z-index: auto;"> }</div><div style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: rgb(149, 165, 167); background-color: rgb(0, 57, 70); position: static; z-index: auto;" data-mce-style="margin: 0px; font-size: 14px; font-family: 'Source Code Pro'; color: #95a5a7; background-color: #003946; position: static; z-index: auto;">}</div></div><div><br></div><div><br></div><div>Regards, Heiko</div><br>_______________________________________________<br>wildfly-dev mailing list<br>wildfly-dev@lists.jboss.org<br>https://lists.jboss.org/mailman/listinfo/wildfly-dev</blockquote><div><br></div></div></body></html>