Update Grafana dashboard to include persistence metrics

[nscuro]

Current Behavior

As of 4.6.0, Dependency-Track exposes metrics about DataNucleus (the ORM we use) and HikariCP (the database connection pool we use).

4.7.0 will refine HikariCP metrics by correctly naming the individual pools (transactional and non-transactional vs. HikariPool-3 and HikariPool-4). See #1935 for the reason of why there are two connection pools instead of just one.

Neither DN nor HCP metrics are currently part of the sample Grafana dashboard.

Especially the HikariCP metrics are important though, in order choose adequate pool sizes.

Proposed Behavior

Extend the sample Grafana dashboard with metrics about the DataNucleus and HikariCP.

Available metrics in the datanucleus namespace:

datanucleus_connections_active 0.0
datanucleus_datastore_reads_total 35229.0
datanucleus_datastore_writes_total 25007.0
datanucleus_object_deletes_total 1.0
datanucleus_object_fetches_total 11043.0
datanucleus_object_inserts_total 331.0
datanucleus_object_updates_total 25744.0
datanucleus_queries_active 0.0
datanucleus_queries_executed_total 21764.0
datanucleus_queries_failed_total 0.0
datanucleus_query_execution_time_ms_avg 0.0
datanucleus_transaction_execution_time_ms_avg 0.0
datanucleus_transactions_active_total 0.0
datanucleus_transactions_committed_total 6990.0
datanucleus_transactions_rolledback_total 0.0
datanucleus_transactions_total 6990.0

Available metrics in the hikaricp namespace:

hikaricp_connections_acquire_seconds_count{pool="non-transactional",} 49050.0
hikaricp_connections_acquire_seconds_count{pool="transactional",} 1289.0
hikaricp_connections_acquire_seconds_max{pool="non-transactional",} 1.59544E-4
hikaricp_connections_acquire_seconds_max{pool="transactional",} 3.55904E-4
hikaricp_connections_acquire_seconds_sum{pool="non-transactional",} 0.013955304
hikaricp_connections_acquire_seconds_sum{pool="transactional",} 0.001371525
hikaricp_connections_active{pool="non-transactional",} 0.0
hikaricp_connections_active{pool="transactional",} 0.0
hikaricp_connections_creation_seconds_count{pool="non-transactional",} 10.0
hikaricp_connections_creation_seconds_count{pool="transactional",} 11.0
hikaricp_connections_creation_seconds_max{pool="non-transactional",} 0.0
hikaricp_connections_creation_seconds_max{pool="transactional",} 0.0
hikaricp_connections_creation_seconds_sum{pool="non-transactional",} 0.0
hikaricp_connections_creation_seconds_sum{pool="transactional",} 0.0
hikaricp_connections_idle{pool="non-transactional",} 11.0
hikaricp_connections_idle{pool="transactional",} 12.0
hikaricp_connections_max{pool="non-transactional",} 20.0
hikaricp_connections_max{pool="transactional",} 20.0
hikaricp_connections_min{pool="non-transactional",} 10.0
hikaricp_connections_min{pool="transactional",} 10.0
hikaricp_connections_pending{pool="non-transactional",} 0.0
hikaricp_connections_pending{pool="transactional",} 0.0
hikaricp_connections{pool="non-transactional",} 11.0
hikaricp_connections{pool="transactional",} 12.0
hikaricp_connections_timeout_total{pool="non-transactional",} 0.0
hikaricp_connections_timeout_total{pool="transactional",} 0.0
hikaricp_connections_usage_seconds_count{pool="non-transactional",} 49050.0
hikaricp_connections_usage_seconds_count{pool="transactional",} 1289.0
hikaricp_connections_usage_seconds_max{pool="non-transactional",} 0.62
hikaricp_connections_usage_seconds_max{pool="transactional",} 0.055
hikaricp_connections_usage_seconds_sum{pool="non-transactional",} 21.853
hikaricp_connections_usage_seconds_sum{pool="transactional",} 1.332

Checklist

• I have read and understand the contributing guidelines
• I have checked the existing issues for whether this enhancement was already requested

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.