Metrics

• 1: Introduction
• 2: MySQL And MariaDB
• 3: PostgreSQL
• 4: Redis
• 5: System
• 6: Valkey

1 - Introduction

CCX uses Prometheus and exporters for monitoring. The monitoring data is exposed though the exports from each node. This is a controlled under the Firewall tab in the CCX UI.

2 - MySQL And MariaDB

• MySQL / MariaDB
  • Handler Stats
    • Statistics for the handler. Shown as:
      • Read Rnd
        • Count of requests to read a row based on a fixed position
      • Read Rnd Next
        • Count of requests to read a subsequent row in a data file
      • Read Next
        • Count of requests to read the next row in key order
      • Read Last
        • Count of requests to read the last key in an index
      • Read Prev
        • Count of requests to read the previous row in key order
      • Read First
        • Count of requests to read a row based on an index key value
      • Read Key
        • Count of requests to read the last key in an index
      • Update
        • Count of requests to update a row
      • Write
        • Count of requests to insert to a table
  • Handler Transaction Stats
  • Database Connections
    • Count of connections to the database. Shown as:
      • Thread Connected
        • Count of clients connected to the database
      • Max Connections
        • Count of max connections allowed to the database
      • Max Used Connections
        • Maximum number of connections in use
      • Aborted Clients
        • Number of connections aborted due to client not closing
      • Aborted Connects
        • Number of failed connection attempts
      • Connections
        • Number of connection attempts
  • Queries
    • Count of queries executed
  • Scan Operations
    • Count of operations for the operations: SELECT, UPDATE and DELETE
  • Table Locking
    • Count of table locks. Shown as:
      • Table locks immediate
        • Count of table locks that could be granted immediately
      • Table locks waited
        • Count of locks that had to be waited due to existing locks or another reason
  • Temporary Tables
    • Count of temporary tables created. Shown as:
      • Temporary tables
        • Count of temporary tables created
      • Temporary tables on Disk
        • Count of temporary tables created on disk rather than in memory
  • Sorting
  • Aborted Connections
    • Count of failed or aborted connections to the database. Shown as:
      • Aborted Clients
        • Number of connections aborted due to client not closing
      • Aborted Connects
        • Number of failed connection attempts
      • Access Denied Errors
        • Count of unsuccessful authentication attempts
    • Memory Utilisation

3 - PostgreSQL

• PostgreSQL
  • SELECT (fetched)
    • Count of rows fetched by queries to the database
  • SELECT (returned)
    • Count of rows returned by queries to the database
  • INSERT
    • Count of rows inserted to the database
  • UPDATE
    • Count of rows updated in the database
  • DELETE
    • Count of rows deleted in the database
  • Active Sessions
    • Count of currently running queries
  • Idle Sessions
    • Count of connections to the database that are not currently in use
  • Idle Sessions in transaction
    • Count of connections that have begun a transaction but not yet completed while not actively doing work
  • Idle Sessions in transaction (aborted)
    • Count of connections that have begun a transaction but did not complete and were forcefully aborted before they could complete
  • Lock tables
    • Active locks on the database
  • Checkpoints requested and timed
    • Count of checkpoints requested and scheduled
  • Checkpoint sync time
    • Time synchronising checkpoint files to disk
  • Checkpoint write time
    • Time to write checkpoints to disk

4 - Redis

• Redis
  • Blocked Clients
    • Clients blocked while waiting on a command to execute
  • Memory Used
    • Amount of memory used by Redis (in bytes)
  • Connected Clients
    • Count of clients connected to Redis
  • Redis commands per second
    • Count of commands processed per second
  • Total keys
    • The total count of all keys stored by Redis
  • Replica Lag
    • The lag (in seconds) between the primary and the replica(s)

5 - System

• System - Hardware level metrics for your Datastore
  • Load Average
    • The overall load on your Datastore within the preset period
  • CPU Usage
    • The breakdown of CPU utilisation for your Datastore, including both System and User processes
  • RAM Usage
    • The amount of RAM (in Gigabytes) used and available within the preset period
  • Network Usage
    • The amount of data (in Kilobits or Megabits per second) received and sent within the preset period
  • Disk Usage
    • The total amount of storage used (in Gigabytes) and what is available within the preset period
  • Disk IO
    • The input and output utilisation for your disk within the preset period
  • Disk IOPS
    • The number of read and write operations within the preset period
  • Disk Throughput
    • The amount of data (in Megabytes per second) that is being read from, or written to, the disk within the preset period

6 - Valkey

• Valkey
  • Blocked Clients
    • Clients blocked while waiting on a command to execute
  • Memory Used
    • Amount of memory used by Valkey (in bytes)
  • Connected Clients
    • Count of clients connected to Valkey
  • Valkey commands per second
    • Count of commands processed per second
  • Total keys
    • The total count of all keys stored by Valkey
  • Replica Lag
    • The lag (in seconds) between the primary and the replica(s)