| docs

Appearance

Database Metrics ​

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

Database Metrics

Overview ​

URL: /admin/database-metrics

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.