What’s New At Releem - April 2025
APR 25, 2025 • WRITTEN BY ROMAN AGABEKOV
This spring 🌱, we’ve been hard at work enhancing Releem’s monitoring, configuration tuning, and SQL query optimization capabilities. Our mission remains constant: helping you get the most out of your databases — with less hassle and better results😊
Updates to Releem Dashboard
We’ve expanded the dashboard’s capabilities to give you clearer insights:
New Events Section
Track key MySQL events and their impact on performance so you can quickly identify cause-and-effect relationships.
New Events Section
Track key MySQL events and their impact on performance so you can quickly identify cause-and-effect relationships.
MySQL Process List
Instantly spot long-running queries with our new real-time process monitoring view.
Instantly spot long-running queries with our new real-time process monitoring view.
Configuration History
Easily compare different configurations to understand how changes affect performance over time.
Easily compare different configurations to understand how changes affect performance over time.
Updates to Releem Platform
For the Releem Platform, we focused on providing more actionable intelligence:
Improved Releem Score Calculation
We’ve refined our scoring algorithm to make performance metrics more intuitive and helpful for decision-making. Read more about Releem Score here.
Improved Releem Score Calculation
We’ve refined our scoring algorithm to make performance metrics more intuitive and helpful for decision-making. Read more about Releem Score here.
Index Incompatibility Detection
Releem now reports queries where conditions (!=, NOT LIKE, NOT IN) can’t effectively use indexes, with clear suggestions for workarounds.
Embedded SQL Warnings
When recommending index or table changes, Releem now includes helpful comments about potential blocking operations for non-InnoDB tables, allowing you to plan maintenance windows more effectively. A comment is embedded on the query so the user knows the operation will block the table while it is performed:
Releem now reports queries where conditions (!=, NOT LIKE, NOT IN) can’t effectively use indexes, with clear suggestions for workarounds.
Embedded SQL Warnings
When recommending index or table changes, Releem now includes helpful comments about potential blocking operations for non-InnoDB tables, allowing you to plan maintenance windows more effectively. A comment is embedded on the query so the user knows the operation will block the table while it is performed:
CREATE INDEX /* -- Warning: table access will be blocked while the index is created */ idx_updated_to
ON `rv_log_maintenance_statistics`(`updated_to`) ALGORITHM=COPY
LOCK=SHAREDFragmented Table Detection
Our schema checks now identify and report fragmented tables. Learn more about these checks here.
Fixed Windows Compatibility Issue
Resolved a bug where recommended innodb_flush_method settings were incompatible with Windows servers, causing MySQL startup failures. We’ve updated our configuration engine to correctly handle platform-specific settings (Issue #401).
Fixed MariaDB Change Buffer Issue
Addressed a potential index corruption issue when using innodb_change_buffering with MariaDB. Releem now disables the change buffer for MariaDB instances to prevent incorrect behavior during reverse index scans (Issue #393).
Our schema checks now identify and report fragmented tables. Learn more about these checks here.
Fixed Windows Compatibility Issue
Resolved a bug where recommended innodb_flush_method settings were incompatible with Windows servers, causing MySQL startup failures. We’ve updated our configuration engine to correctly handle platform-specific settings (Issue #401).
Fixed MariaDB Change Buffer Issue
Addressed a potential index corruption issue when using innodb_change_buffering with MariaDB. Releem now disables the change buffer for MariaDB instances to prevent incorrect behavior during reverse index scans (Issue #393).
Updates to Releem Agent
MySQL Process List Collection
Our agent now gathers MySQL process list data without requiring additional permissions.
Optimized Database Querying
Significantly improved performance on servers with many databases by optimizing how Releem queries database information. This fix eliminates slow-running INFORMATION_SCHEMA queries that were previously appearing in slow query logs (Issue #398).
Our agent now gathers MySQL process list data without requiring additional permissions.
Optimized Database Querying
Significantly improved performance on servers with many databases by optimizing how Releem queries database information. This fix eliminates slow-running INFORMATION_SCHEMA queries that were previously appearing in slow query logs (Issue #398).
Community Contributions
WRITTEN BY ROMAN AGABEKOV