...
- CPU time per query/task/cache operations
- Disk, I/O wait/read/write per query/task/cache operations
- Query parse time
- Time for waiting blocks
- User time per transaction
- Messages process timings
- I/O per data regions
This statistics will provide:
- Top query/operations by CPU time
- Top query/operations by IO time
- What operations use most resources?
Phase 1
On the first phase will be implemented:
- Profiling public API and default implementation
- Java API, CLI, JMX process management
- Gathering overall and time statistics of queries, tasks, cache operations, checkpoints and PME's.
- Tool to create the report
Phase 2
On the second phase will be investigated and implemented:
- Gathering CPU time per operation
- Gathering I/O wait time, read/write counting
- Time for waiting blocks per operation
- Display of these statistics in the report
Public API changes
The new interface will be added: ProfilingSpi
.
...