We spent March focused on expanding query optimization, building out partner integrations, continuing PostgreSQL testing, and improve the overall experience for hosting providers and teams using Releem.
We also had the chance to connect with the hosting community at CloudFest. There, we met with hosting providers interested in partnering with Releem to offer Database Advisor to their customers. I gave a talk on Database Advisor for teams running databases without a DBA.
Gabriel presented a deep technical session at Scale23X titled The Hidden Lives of Temp Tables: Unraveling MySQL Internal Management.
Community Contributions
We're always collecting issues and feature requests on our GitHub. Here's where you can contribute:
Issues – If you encounter any problems or bugs, report them here.
Feature Requests – Have an idea to make Releem even better? Share your suggestions here.
Product Updates
Batch SQL query analysis and recommendations
You can now see recommendations for all queries directly in Query Analytics without any additional clicks, and save them to the Query Optimization tab for further review and optimization.
If no issues are found, the result shows that the query was analyzed along with the timestamp of the latest check, so you can clearly see what was reviewed and when.
Releem continues to automatically identify the most impactful queries based on workload and adds them as discovered opportunities in the Query Optimization tab.
Custom SQL query optimization
You can now analyze and get recommendations for your own SQL queries, not just the ones Releem detects automatically. Developers can review and optimize queries before they reach production. In Queries & Schema plate go to Query Optimization tab and press + Add Custom Query
WHM/cPanel integration
Releem also integrates with WHM/cPanel, simplifying the installation process and providing access to the Releem dashboard directly from WHM. During installation, Releem disables cPanel auto-tuning rules to ensure compatibility.
Learn more in the documentation.
API and WHMCS integration for hosting partners
We released an API for hosting partners, enabling programmatic integration of Releem into hosting platforms and making it possible to offer Database Advisor to VPS, dedicated, and cloud server customers.
Releem also integrates with WHMCS, allowing providers to sell and manage Database Advisor as an add-on through their existing billing workflows.
Get the partner deck to learn more about integration and partnership options.
AWS Aurora Serverless support
We added support for AWS Aurora Serverless, bringing Releem’s performance analysis and recommendations to these environments (Feature request #477).
The installation process is the same as for AWS RDS.
Deadlock export to CSV
Detected deadlocks can now be exported to CSV for external analysis and reporting (Feature request #503).
Improved data collection performance
We fixed an issue in how Releem queried table_io_waits_summary_by_index_usage reducing unnecessary full table scans on servers with many databases (Issue #500).
Uninstallation dependency fix
The agent no longer downloads unnecessary dependencies during uninstallation (Issue #466).
Duplicate index detection improvement
We improved duplicate index analysis to account for foreign key-backed indexes, helping prevent unsafe recommendations during index optimization (Issue #478).
Expanded query parser support
Releem now supports optimization for queries that start with '(' instead of 'SELECT' (Issue #427).
Offline agent apply-task fix
We fixed an issue that allowed configuration apply tasks to be scheduled while the agent was offline (Issue #311).
More...
 |
 |
We also had the chance to connect with the hosting community at CloudFest. There, we met with hosting providers interested in partnering with Releem to offer Database Advisor to their customers. I gave a talk on Database Advisor for teams running databases without a DBA.
Gabriel presented a deep technical session at Scale23X titled The Hidden Lives of Temp Tables: Unraveling MySQL Internal Management.
Community Contributions
We're always collecting issues and feature requests on our GitHub. Here's where you can contribute:
Issues – If you encounter any problems or bugs, report them here.
Feature Requests – Have an idea to make Releem even better? Share your suggestions here.
Product Updates
Batch SQL query analysis and recommendations
You can now see recommendations for all queries directly in Query Analytics without any additional clicks, and save them to the Query Optimization tab for further review and optimization.
If no issues are found, the result shows that the query was analyzed along with the timestamp of the latest check, so you can clearly see what was reviewed and when.
Releem continues to automatically identify the most impactful queries based on workload and adds them as discovered opportunities in the Query Optimization tab.
Custom SQL query optimization
You can now analyze and get recommendations for your own SQL queries, not just the ones Releem detects automatically. Developers can review and optimize queries before they reach production. In Queries & Schema plate go to Query Optimization tab and press + Add Custom Query
WHM/cPanel integration
Releem also integrates with WHM/cPanel, simplifying the installation process and providing access to the Releem dashboard directly from WHM. During installation, Releem disables cPanel auto-tuning rules to ensure compatibility.
Learn more in the documentation.
API and WHMCS integration for hosting partners
We released an API for hosting partners, enabling programmatic integration of Releem into hosting platforms and making it possible to offer Database Advisor to VPS, dedicated, and cloud server customers.
Releem also integrates with WHMCS, allowing providers to sell and manage Database Advisor as an add-on through their existing billing workflows.
Get the partner deck to learn more about integration and partnership options.
AWS Aurora Serverless support
We added support for AWS Aurora Serverless, bringing Releem’s performance analysis and recommendations to these environments (Feature request #477).
The installation process is the same as for AWS RDS.
Deadlock export to CSV
Detected deadlocks can now be exported to CSV for external analysis and reporting (Feature request #503).
Improved data collection performance
We fixed an issue in how Releem queried table_io_waits_summary_by_index_usage reducing unnecessary full table scans on servers with many databases (Issue #500).
Uninstallation dependency fix
The agent no longer downloads unnecessary dependencies during uninstallation (Issue #466).
Duplicate index detection improvement
We improved duplicate index analysis to account for foreign key-backed indexes, helping prevent unsafe recommendations during index optimization (Issue #478).
Expanded query parser support
Releem now supports optimization for queries that start with '(' instead of 'SELECT' (Issue #427).
Offline agent apply-task fix
We fixed an issue that allowed configuration apply tasks to be scheduled while the agent was offline (Issue #311).
More...