PmaControl logo PmaControl
Resources › MySQL optimization center › Performance Evaluation Page

Performance Evaluation Page

Structured Markdown documentation to diagnose, measure, and optimize MySQL.

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Objective

The performance evaluation page aggregates the main signals of a MySQL server into one reading. It is used to prioritize actions, not to replace DBA analysis.

Useful Dimensions

  • Configuration: consistency of variables with memory, storage, and workload.
  • Queries: weight of slow and frequent queries.
  • Schema: indexes, primary keys, volume, and temporary tables.
  • Stability: restarts, connection errors, deadlocks, and thread saturation.
  • Capacity: CPU, I/O, QPS, connections, and disk-space trends.

Example Grid

Axis Signal Priority
Memory Buffer pool too small or swapping High
Queries 5 digests consume most of the time High
Schema Critical tables without suitable indexes Medium to high
Connections Max_used_connections close to max_connections Medium

Key Point

A global score has value only if it remains explainable. Every point must lead to a metric, a query, or a verifiable configuration.