Community Contributions

Product Updates

Batch SQL query analysis and recommendations

Custom SQL query optimization

WHM/cPanel integration

API and WHMCS integration for hosting partners

AWS Aurora Serverless support

Deadlock export to CSV

Improved data collection performance

Uninstallation dependency fix

Duplicate index detection improvement

Expanded query parser support

Offline agent apply-task fix 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. 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. 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. 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 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. 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. 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. Detected deadlocks can now be exported to CSV for external analysis and reporting (Feature request #503). 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). The agent no longer downloads unnecessary dependencies during uninstallation (Issue #466). We improved duplicate index analysis to account for foreign key-backed indexes, helping prevent unsafe recommendations during index optimization (Issue #478). Releem now supports optimization for queries that start with '(' instead of 'SELECT' (Issue #427). We fixed an issue that allowed configuration apply tasks to be scheduled while the agent was offline (Issue #311). Templates let you quickly answer FAQs or store snippets for re-use. as well , this person and/or