After checking last patch from build 2.1.1_01, I started to think about some kind o monitoring tools in ODB. Those tools could look similar to MySQL 'show innodb status', where you can get some informations about how DB is doing.
It would be nice to monitor:
- inserts/s, updates/s, deletes/s, reads/s
- total inserts, update, deletes, reads
- I/O operations/s
- caches current usage
- uptime from last start
- caches hit rate
- total sessions from clients
- memory usage (for heap space tuning?)
The easiest way to obtain this kind of statistics would be to use normal typed query with predefined result class or just query with ResultSet.