Database Metrics

Where this lives now: this screen is part of Health in the database scope. Its address is /admin/health?scope=database, and the old one redirects there.

The Metrics page in the Database section provides real-time database performance and usage statistics.

Overview

Former address: /admin/database-metrics (this page describes an earlier version of this screen)

The page header reads: "Real-time database performance and usage statistics."

A Refresh button is available to reload the metrics data.

Metrics Cards

The page displays five metric cards:

Connections

• Current - Number of current database connections.
• Maximum - Maximum allowed connections.
• Usage - Connection usage as a percentage, with a progress bar.

InnoDB Performance

• Buffer Pool Hit Rate - InnoDB buffer pool hit rate percentage.
• Log Waits - Number of log waits.
• Hit Rate - Overall hit rate with a progress bar.

Table Statistics

• Open Tables - Number of currently open tables.
• Opened Tables - Total number of tables opened since server start.
• Table Locks Waited - Number of times a table lock was waited for.

Query Performance

• Total - Total number of queries executed.
• Per Second - Queries per second rate.
• Slow Queries - Number of slow queries.
• Slow Query Rate - Rate of slow queries.

Cache Performance

• Query Cache Hits - Number of query cache hits.
• Query Cache Misses - Number of query cache misses.
• Hit Rate - Cache hit rate.

Database Disk Usage

A table at the bottom shows disk usage per database:

• Database - The database name.
• Size (MB) - Size of the database in megabytes.
• Usage Bar - Visual bar showing relative disk usage.