Added connection pool metrics to prometheus client (#21576)

ref https://linear.app/ghost/issue/ENG-1592/start-monitoring-connection-pool-utilization-in-ghost - This commit adds prometheus metrics to the connection pool so we can start to track connection pool utilization, number of pending acquires, and also adds some basic SQL query summary metrics like queries per minute and query duration percentiles. - The connection pool has now been theorized to be a main constraint of Ghost for some time, but it's been challenging to get actual visibility into the state of the connection pool. With this change, we should be able to directly observe, monitor and alert on the connection pool. - Updated grafana version to fix a bug in the query editor that was fixed in 8.3, even though this is a couple versions ahead of production
TryGhost · Nov 8, 2024 · 85408d1 · 85408d1
1 parent 08fe08a
commit 85408d1
Show file tree

Hide file tree

Showing 8 changed files with 2,526 additions and 1,585 deletions.
diff --git a/.github/scripts/docker-compose.yml b/.github/scripts/docker-compose.yml
@@ -37,13 +37,14 @@ services:
       - ./prometheus/prometheus.yml:/etc/prometheus/prometheus.yml
   grafana:
     profiles: [monitoring]
-    image: grafana/grafana:8.2.3
+    image: grafana/grafana:8.3.0
     container_name: ghost-grafana
     ports:
       - "3000:3000"
     restart: always
     environment:
       - GF_AUTH_ANONYMOUS_ENABLED=true
+      - GF_AUTH_ANONYMOUS_ORG_ROLE=Admin
     volumes:
       - ./grafana/datasources:/etc/grafana/provisioning/datasources
       - ./grafana/dashboard.yml:/etc/grafana/provisioning/dashboards/main.yaml

diff --git a/.github/scripts/grafana/dashboard.yml b/.github/scripts/grafana/dashboard.yml
@@ -9,7 +9,7 @@ providers:
     type: file
     disableDeletion: false
     updateIntervalSeconds: 10
-    allowUiUpdates: false
+    allowUiUpdates: true
     options:
       path: /var/lib/grafana/dashboards
       foldersFromFilesStructure: true