Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

Additional investigation required to gather following statistics:

  • CPU time per query/task/cache operations
  • Disk, I/O wait/read/write per query/task/cache operations
  • Query parse time
  • Lock waiting time
  • User time
  • Messages process timings

...