From eduardo.santanadasilva at gmail.com Wed Aug 27 07:19:29 2014 Content-Type: multipart/mixed; boundary="===============7300414387116277587==" MIME-Version: 1.0 From: Eduardo Sant'Ana da Silva To: wildfly-dev at lists.jboss.org Subject: Re: [wildfly-dev] JDBC stats, clarification needed Date: Wed, 27 Aug 2014 08:19:25 -0300 Message-ID: <2D3D00A2-4FC9-47F3-AF3C-474C69399A4E@gmail.com> In-Reply-To: 235E1BC4-43CC-48F7-B521-F3B41DE4D37B@gmail.com --===============7300414387116277587== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable You have 41 prepared statment access to the cache. This not mean that you h= ave 41 different statements. This means that you have actually only 6 different. Those 6 were added init= ially 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 wrote: > = > /** > * JBQA-6456 Test jdbc statistics of data sources > * > * @author Vladimir Rastseluev > */ > = > @RunWith(Arquillian.class) > @ServerSetup(DataSourceJdbcStatisticsTestCase.TestCaseSetup.class) > public class DataSourceJdbcStatisticsTestCase { > = > ... > = > public StringBuffer assertStatisticsSet(boolean yes, ModelNode stati= sticNode) throws Exception { > StringBuffer sb =3D new StringBuffer(); > String[] params =3D { "PreparedStatementCacheAccessCount", //= The number of times that the statement cache was > // a= ccessed > "PreparedStatementCacheAddCount", // The number of st= atements 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 tim= es that statements from the cache were used > = > }; > = > = > On Aug 27, 2014, at 6:10 AM, Heiko Braun wrote: > = >> PreparedStatementCacheAccessCount > = --===============7300414387116277587== Content-Type: text/html MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWwgY2hhcnNldD11cy1hc2NpaSI+PC9oZWFkPjxib2R5IHN0eWxlPSJ3b3JkLXdyYXA6IGJy ZWFrLXdvcmQ7IC13ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5lLWJyZWFrOiBh ZnRlci13aGl0ZS1zcGFjZTsiPjxkaXYgc3R5bGU9Im1hcmdpbjogMHB4OyBmb250LXNpemU6IDEx cHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPllvdSBoYXZlIDQxIHByZXBhcmVkIHN0YXRtZW50IGFj Y2VzcyB0byB0aGUgY2FjaGUuIFRoaXMgbm90IG1lYW4gdGhhdCB5b3UgaGF2ZSA0MSBkaWZmZXJl bnQgc3RhdGVtZW50cy48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAx MXB4OyBmb250LWZhbWlseTogTWVubG87Ij5UaGlzIG1lYW5zIHRoYXQgeW91IGhhdmUgYWN0dWFs bHkgb25seSA2IGRpZmZlcmVudC4gVGhvc2UgNiB3ZXJlIGFkZGVkIGluaXRpYWxseSB0byB0aGUg Y2FjaGUgYW5kPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTogMTFweDsg Zm9udC1mYW1pbHk6IE1lbmxvOyI+dGhlIG90aGVyIDM1IGFjY2VzcyBmb3VuZCB0aGVtIG9uIHRo ZSBjYWNoZSwgc28geW91IGhhdmUgMzUgaGl0cy48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDBw eDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87IGNvbG9yOiByZ2IoOTQsIDUy LCAyNTUpOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAm bmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOzwvZGl2PjxkaXYgc3R5bGU9IiI+PGRpdj5PbiBBdWcgMjcsIDIwMTQsIGF0IDc6NTggQU0s IEVkdWFyZG8gU2FudCdBbmEgZGEgU2lsdmEgJmx0OzxhIGhyZWY9Im1haWx0bzplZHVhcmRvLnNh bnRhbmFkYXNpbHZhQGdtYWlsLmNvbSI+ZWR1YXJkby5zYW50YW5hZGFzaWx2YUBnbWFpbC5jb208 L2E+Jmd0OyB3cm90ZTo8L2Rpdj48YnIgY2xhc3M9IkFwcGxlLWludGVyY2hhbmdlLW5ld2xpbmUi PjxibG9ja3F1b3RlIHR5cGU9ImNpdGUiPjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sIGNoYXJzZXQ9dXMtYXNjaWkiPjxkaXYgc3R5bGU9IndvcmQtd3Jh cDogYnJlYWstd29yZDsgLXdlYmtpdC1uYnNwLW1vZGU6IHNwYWNlOyAtd2Via2l0LWxpbmUtYnJl YWs6IGFmdGVyLXdoaXRlLXNwYWNlOyI+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7IGZvbnQtc2l6 ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPjxkaXYgc3R5bGU9 Im1hcmdpbjogMHB4OyI+LyoqPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7Ij4mbmJzcDsq IEpCUUEtNjQ1NiBUZXN0IGpkYmMgc3RhdGlzdGljcyBvZiBkYXRhIHNvdXJjZXM8L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46IDBweDsiPiZuYnNwOyo8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDBw eDsiPiZuYnNwOyogQGF1dGhvciAmbHQ7YSBocmVmPSI8YSBocmVmPSJtYWlsdG86dnJhc3RzZWxA cmVkaGF0LmNvbSI+dnJhc3RzZWxAcmVkaGF0LmNvbTwvYT4iJmd0O1ZsYWRpbWlyIFJhc3RzZWx1 ZXYmbHQ7L2EmZ3Q7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7Ij4mbmJzcDsqLzwvZGl2 PjxkaXYgc3R5bGU9Im1hcmdpbjogMHB4OyBtaW4taGVpZ2h0OiAxM3B4OyI+PGJyPjwvZGl2Pjxk aXYgc3R5bGU9Im1hcmdpbjogMHB4OyI+QFJ1bldpdGgoQXJxdWlsbGlhbi5jbGFzcyk8L2Rpdj48 ZGl2IHN0eWxlPSJtYXJnaW46IDBweDsiPkBTZXJ2ZXJTZXR1cChEYXRhU291cmNlSmRiY1N0YXRp c3RpY3NUZXN0Q2FzZS5UZXN0Q2FzZVNldHVwLmNsYXNzKTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjogMHB4OyI+cHVibGljIGNsYXNzIERhdGFTb3VyY2VKZGJjU3RhdGlzdGljc1Rlc3RDYXNlIHs8 L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pi4uLjwvZGl2PjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPjxicj48L2Rpdj48 ZGl2IHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVu bG87Ij4mbmJzcDsgJm5ic3A7ICZuYnNwO3B1YmxpYyBTdHJpbmdCdWZmZXIgYXNzZXJ0U3RhdGlz dGljc1NldChib29sZWFuIHllcywgTW9kZWxOb2RlIHN0YXRpc3RpY05vZGUpIHRocm93cyBFeGNl cHRpb24gezwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGZv bnQtZmFtaWx5OiBNZW5sbzsiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i c3A7IFN0cmluZ0J1ZmZlciBzYiA9IG5ldyBTdHJpbmdCdWZmZXIoKTs8L2Rpdj48ZGl2IHN0eWxl PSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJz cDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBTdHJpbmdbXSBwYXJhbXMgPSB7 ICJQcmVwYXJlZFN0YXRlbWVudENhY2hlQWNjZXNzQ291bnQiLCAvLyBUaGUgbnVtYmVyIG9mIHRp bWVzIHRoYXQgdGhlIHN0YXRlbWVudCBjYWNoZSB3YXM8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46 IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJzcDsmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAm bmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJz cDsgLy8gYWNjZXNzZWQ8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAx MXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgIlByZXBhcmVkU3RhdGVtZW50 Q2FjaGVBZGRDb3VudCIsIC8vIFRoZSBudW1iZXIgb2Ygc3RhdGVtZW50cyBhZGRlZCB0byB0aGUg c3RhdGVtZW50IGNhY2hlPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7IGZvbnQtc2l6ZTog MTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICJQcmVwYXJlZFN0YXRlbWVu dENhY2hlQ3VycmVudFNpemUiLCAvLyBUaGUgbnVtYmVyIG9mIHByZXBhcmVkIGFuZCBjYWxsYWJs ZSBzdGF0ZW1lbnRzIGN1cnJlbnRseSBjYWNoZWQgaW48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46 IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87Ij4mbmJzcDsmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAm bmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i c3A7ICZuYnNwOyAmbmJzcDsgLy8gdGhlIHN0YXRlbWVudCBjYWNoZTwvZGl2PjxkaXYgc3R5bGU9 Im1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPiZuYnNw OyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 ICZuYnNwOyAiUHJlcGFyZWRTdGF0ZW1lbnRDYWNoZURlbGV0ZUNvdW50IiwgLy8gVGhlIG51bWJl ciBvZiBzdGF0ZW1lbnRzIGRpc2NhcmRlZCBmcm9tIHRoZSBjYWNoZTwvZGl2PjxkaXYgc3R5bGU9 Im1hcmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiPiZuYnNw OyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 ICZuYnNwOyAiUHJlcGFyZWRTdGF0ZW1lbnRDYWNoZUhpdENvdW50IiAvLyBUaGUgbnVtYmVyIG9m IHRpbWVzIHRoYXQgc3RhdGVtZW50cyBmcm9tIHRoZSBjYWNoZSB3ZXJlIHVzZWQ8L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46IDBweDsgZm9udC1zaXplOiAxMXB4OyBmb250LWZhbWlseTogTWVubG87 IG1pbi1oZWlnaHQ6IDEzcHg7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwcHg7IGZv bnQtc2l6ZTogMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgfTs8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48L2Rp dj48ZGl2PjxkaXY+T24gQXVnIDI3LCAyMDE0LCBhdCA2OjEwIEFNLCBIZWlrbyBCcmF1biAmbHQ7 PGEgaHJlZj0ibWFpbHRvOmhicmF1bkByZWRoYXQuY29tIj5oYnJhdW5AcmVkaGF0LmNvbTwvYT4m Z3Q7IHdyb3RlOjwvZGl2PjxiciBjbGFzcz0iQXBwbGUtaW50ZXJjaGFuZ2UtbmV3bGluZSI+PGJs b2NrcXVvdGUgdHlwZT0iY2l0ZSI+PHNwYW4gc3R5bGU9ImNvbG9yOiByZ2IoMTQ5LCAxNjUsIDE2 Nyk7IGZvbnQtZmFtaWx5OiAnU291cmNlIENvZGUgUHJvJzsgZm9udC1zaXplOiAxNHB4OyBmb250 LXN0eWxlOiBub3JtYWw7IGZvbnQtdmFyaWFudDogbm9ybWFsOyBmb250LXdlaWdodDogbm9ybWFs OyBsZXR0ZXItc3BhY2luZzogbm9ybWFsOyBsaW5lLWhlaWdodDogbm9ybWFsOyBvcnBoYW5zOiBh dXRvOyB0ZXh0LWFsaWduOiBzdGFydDsgdGV4dC1pbmRlbnQ6IDBweDsgdGV4dC10cmFuc2Zvcm06 IG5vbmU7IHdoaXRlLXNwYWNlOiBub3JtYWw7IHdpZG93czogYXV0bzsgd29yZC1zcGFjaW5nOiAw cHg7IC13ZWJraXQtdGV4dC1zdHJva2Utd2lkdGg6IDBweDsgYmFja2dyb3VuZC1jb2xvcjogcmdi KDAsIDU3LCA3MCk7IGRpc3BsYXk6IGlubGluZSAhaW1wb3J0YW50OyBmbG9hdDogbm9uZTsiPlBy ZXBhcmVkU3RhdGVtZW50Q2FjaGVBY2Nlc3NDb3VudDwvc3Bhbj48L2Jsb2NrcXVvdGU+PC9kaXY+ PGJyPjwvZGl2PjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PC9ib2R5PjwvaHRtbD4= --===============7300414387116277587==--