| docs

Appearance

MySQL Health ​

MySQL Health shows how the server's MariaDB or MySQL database server is doing: its overall state, how many connections it holds now, its average query rate, the slow queries and table lock waits it has counted since it started, and how much space each database takes. Since panel 1.9.3 it is a page of its own under Health. In 1.9.2 only part of it remained, as the database scope of the Health page.

MySQL Health with the overall status, the connection, query and table readings, and the size of each database

Overview ​

URL: /admin/health/mysql

Open it from Health > MySQL in the sidebar. The menu entry is MySQL, because it already sits under Health; the page itself is titled MySQL Health, with the subheading "Database server health status and performance indicators."

The entry appears once a MariaDB configuration profile exists, the profiles you manage on MySQL Settings. Without one, the page is not listed and does not open by its address either.

The readings are taken when the page opens. Refresh in the header reads them again.

If the server cannot be asked for its readings, the page shows Error Loading Health Data with the reason, and no cards.

Overall Health Status ​

The top card shows the overall state as a badge, Healthy, Warning, or Critical, with the time of the check and the database server's uptime on the right. The state is the worst of the three indicators below: high connection usage, many slow queries, or many table lock waits, the last two counted since the database server started.

Health cards ​

Three cards sit side by side. Each value that can be a problem is a badge that turns from green to amber to red as it gets worse.

Connection Health ​

  • Current - the connections open now.
  • Maximum - the most connections the server accepts.
  • Usage - current connections as a share of the maximum, with a bar under the card.

Query Performance ​

  • Queries/Second - the average number of queries per second since the database server started.
  • Slow Queries - the number of slow queries the database server has counted since it started.
  • A line under the values says No slow queries detected, Some slow queries detected, or High number of slow queries.

Table Health ​

  • Open Tables - the tables open now.
  • Table Locks Waited - the number of times a query waited for a table lock since the database server started.
  • A line under the values says No table lock contention, Some table lock waits, or High table lock contention.

Database Disk Usage ​

The Database Disk Usage card lists the databases, largest first, each with its size in MB and a bar that compares it with the largest one. The same card appears on PostgreSQL Health for PostgreSQL databases.

  • PostgreSQL Health - the same view for PostgreSQL, when that module is enabled.
  • Health - every finding across the server, including the database scope.
  • MySQL Settings - the database server's configuration and its profiles.