Releem Score

Releem Score is a metric developed by Releem and designed to classify how well a MySQL server is performing and represents the best practices for maintaining servers. The Releem Score can be accessed at any time via the Releem Dashboard. This new metric is intended to simplify and automate the evaluation of a MySQL configuration

The Releem Score is a numerical value (0 - 100%) that reflects how well your MySQL server aligns with best practices in performance, configuration, and resource usage.

This score is based on a set of health checks, organized into logical groups. Each group has a different weight depending on its importance. The score helps you quickly identify areas that need attention and track improvements over time.

Monitoring data is combined to produce a numerical value that can be classified as Good Performance, Performance Improvements Needed, and Poor Performance. Releem Scores will range between:

• 90-100: Good Performance (Fast)
• 50-89: Performance Improvements Needed (Average)
• 0-49: Poor Performance (Slow)

To further understand this breakdown:

• Good Performance means the MySQL server is well-optimized with limited bottlenecks or irregularities.
  
• Performance Improvements Needed means that the MySQL server is somewhat optimized but DBA's may look into improving specific metrics that fall short.
  
• Poor Performance means the MySQL server is not well optimized and configurations changes should be made as soon as possible to improve speeds.

Releem calculates Releem Score by summarizing MySQL Health Checks that describe the efficiency of using Memory, Connections, Logs, Cache, Disk, Indexes, Threads.

The Releem Score is calculated in four simple steps:
1. Health checks are grouped into categories (e.g., System, InnoDB, Memory).
2. Each check passes (1) or fails (0) based on performance and configuration thresholds.
3. For each group, we calculate the percentage of checks passed.
4. The final Releem Score is the weighted average of all group scores.

Releem organizes MySQL health checks into four key groups:

1. MyISAM / InnoDB (30% of total score)
Focuses on InnoDB (and some MyISAM) engine-specific performance indicators. These checks determine if your storage engine is tuned properly for performance and durability.

Checks:

1. InnoDB Dirty Pages Ratio
2. MyISAM Cache Hit Rate
3. MyISAM Key Write Ratio
4. InnoDB Cache Hit Rate
5. InnoDB Log File Size

Group Weight: 30%


2. Memory (10% of total score)
Evaluates how effectively MySQL uses internal memory for caching and threading. Good memory tuning reduces latency and improves concurrency.

Checks:

1. Table Cache Hit Rate
2. Table Definition Cache Hit Rate
3. Thread Cache Hit Rate
4. Thread Cache Ratio
5. Table Locking Efficiency

Group Weight: 10%


3. Queries / Logs (20% of total score)
Assesses query-related configurations, temporary tables, and logging behavior. Poor values here often indicate bottlenecks or slow queries.

Checks:

1. Flushing Logs
2. Query Truncation Status
3. Sort Merge Passes Ratio
4. Temporary Disk Data

Group Weight: 20%


4. System (40% of total score)
Covers overall server health and system resource usage—this is the most critical group, hence the highest weight.

Checks:

1. CPU Utilization
2. Memory Utilization
3. Disk Space Usage
4. Open Files Utilization
5. Database Connection Utilization

Group Weight: 40%


Example: 100% Score

Here’s an example result:
In this case, all checks passed, resulting in a perfect Releem Score of 100%.

How to use MySQL Performance Score?

You can use this metric to determine the effectiveness of the MySQL configuration on your database server.
When the Releem Score decreases, it means that you have the opportunity to change the MySQL configuration to improve performance.

Where can I find more information on MySQL Configuration?

To learn more, look over this curated list of resources covering MySQL configuration.

Does Releem support my database management system in calculating Releem Score?

Releem supports all versions of MySQL, MariaDB and Percona.

How can I get Releem Score for my database server?

Releem Score for your server is provided by Releem. To learn more or sign up for free, visit releem.com