What’s New At Releem - WHM/cPanel integration is available

Releem 最新动态：WHM/cPanel 集成现已上线

We spent March focused on expanding query optimization, building out partner integrations, continuing PostgreSQL testing, and improving 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.

三月，我们专注于扩展查询优化功能、构建合作伙伴集成、继续进行 PostgreSQL 测试，并改善托管服务提供商和使用 Releem 的团队的整体体验。我们还有机会在 CloudFest 上与托管社区进行了交流。在那里，我们结识了有兴趣与 Releem 合作，向其客户提供“数据库顾问”（Database Advisor）服务的托管服务提供商。我发表了一场关于为没有 DBA 的团队提供数据库顾问服务的演讲。Gabriel 在 Scale23X 上进行了一场深入的技术分享，主题为《临时表的隐藏生命：揭秘 MySQL 内部管理》。

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.

我们一直在 GitHub 上收集问题和功能需求。您可以通过以下方式参与贡献：问题反馈（Issues）——如果您遇到任何问题或 Bug，请在此报告。功能需求（Feature Requests）——对如何让 Releem 变得更好有想法？请在此分享您的建议。

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.

批量 SQL 查询分析与建议 现在，您无需额外点击即可直接在“查询分析”（Query Analytics）中查看所有查询的建议，并将其保存到“查询优化”（Query Optimization）选项卡中以供进一步审查和优化。如果没有发现问题，结果将显示查询已完成分析以及最近一次检查的时间戳，因此您可以清楚地看到审查的内容和时间。Releem 将继续根据工作负载自动识别最具影响力的查询，并将其作为发现的机会添加到“查询优化”选项卡中。

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.

自定义 SQL 查询优化 现在，您不仅可以分析 Releem 自动检测到的查询，还可以分析您自己的 SQL 查询并获取建议。开发人员可以在查询进入生产环境之前对其进行审查和优化。在“查询与架构”（Queries & Schema）面板中，转到“查询优化”选项卡，然后点击“+ 添加自定义查询”（+ 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.

WHM/cPanel 集成 Releem 现已集成 WHM/cPanel，简化了安装过程，并支持直接从 WHM 访问 Releem 仪表板。在安装过程中，Releem 会禁用 cPanel 的自动调优规则以确保兼容性。详情请参阅文档。

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.

面向托管合作伙伴的 API 和 WHMCS 集成 我们发布了面向托管合作伙伴的 API，支持将 Releem 以编程方式集成到托管平台中，从而能够向 VPS、独立服务器和云服务器客户提供“数据库顾问”服务。Releem 还集成了 WHMCS，允许服务提供商通过现有的计费工作流程将“数据库顾问”作为附加组件进行销售和管理。获取合作伙伴手册以了解更多关于集成和合作方案的信息。

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.

AWS Aurora Serverless 支持 我们增加了对 AWS Aurora Serverless 的支持，将 Releem 的性能分析和建议功能引入到这些环境中（功能需求 #477）。安装过程与 AWS RDS 相同。

Deadlock export to CSV Detected deadlocks can now be exported to CSV for external analysis and reporting (Feature request #503).

死锁导出为 CSV 检测到的死锁现在可以导出为 CSV 文件，以便进行外部分析和报告（功能需求 #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).

数据采集性能提升 我们修复了 Releem 查询 table_io_waits_summary_by_index_usage 的方式，减少了在拥有大量数据库的服务器上不必要的全表扫描（问题 #500）。

Uninstallation dependency fix The agent no longer downloads unnecessary dependencies during uninstallation (Issue #466).

卸载依赖项修复 代理程序在卸载过程中不再下载不必要的依赖项（问题 #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).

重复索引检测改进 我们改进了重复索引分析，将外键支持的索引纳入考量，有助于防止在索引优化过程中出现不安全的建议（问题 #478）。

Expanded query parser support Releem now supports optimization for queries that start with ’(’ instead of ‘SELECT’ (Issue #427).

扩展查询解析器支持 Releem 现在支持对以 ’(’ 开头而非以 ‘SELECT’ 开头的查询进行优化（问题 #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).

离线代理任务应用修复 我们修复了一个问题，该问题曾允许在代理离线时调度配置应用任务（问题 #311）。