Page History

...

For now, Ignite has not build-in profiling tool for user's operations and internal processes. Such a tool will be able to collect performance statistics and create a human-readable report. It will help to analyze load workload and to tune configuration and applications.

Example of similar tools in other products: AWR (Oracle); pgbadger, pgmetrics, powa (PostgresSQL).

...

• Ignite and plugins versions
• Profiling start/end time
• Queries (SQL, scan, ..) timings:
  • Queries that took up the most time
  • Slowest queries
  • Most frequent queries
  • Failing queries
• User tasks timings (similar to queries timings)
• Cache operations timings on affinity nodes:
  • Get
  • Put
  • Remove
  • RemoveAndGet
  • PutAndGet
  • Invoke
  • Lock
  • create/destroy caches
• Transactions commit/rollback timings
• WAL timings
• Checkpoints statistics
• PME statistics

...