[jira] Commented: (IBATIS-324) cache hits/misses

["Clinton Begin (JIRA)" <ib...@incubator.apache.org>]

    [ http://issues.apache.org/jira/browse/IBATIS-324?page=comments#action_12421742 ] 
            
Clinton Begin commented on IBATIS-324:
--------------------------------------


>> cache hits/misses monitoring

This is actually already available.  We just need to expose the method in the public interface.  

http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/src/com/ibatis/sqlmap/engine/cache/CacheModel.java

>> size of cache by map name in megs

There's no reliable way to do this in Java.

>> and report by hour/date # of times a statment was used. 

That can be added outside of iBATIS.  You can inject a proxy between the SqlMapClient interface and the default implementation to track these stats.  If you build such a thing, we can consider adding it to the framework if others are interested.

>> log the slow sql statements, like anything that takes more then 1/3 of a seconds to log the statment and arguments

Same as above.  This could be done as a SqlMapClient proxy.

If you want to try the two above as proxies, we'll see where we land with it.

> cache hits/misses
> -----------------
>
>                 Key: IBATIS-324
>                 URL: http://issues.apache.org/jira/browse/IBATIS-324
>             Project: iBatis for Java
>          Issue Type: New Feature
>          Components: SQL Maps
>            Reporter: V.C.
>            Priority: Minor
>
> It be nice to be able in real time and loged report on cache hits/misses monitoring, size of cache by map name in megs, and report by hour/date # of times a statment was used.
> (also log the slow sql statements, like anything that takes more then 1/3 of a seconds to log the statment and arguments).
> these are standard managment issues that come up now and then.
> i'd consider implementing if that helps.
> .V

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira