<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Roman Agabekov on Medium]]></title>
        <description><![CDATA[Stories by Roman Agabekov on Medium]]></description>
        <link>https://medium.com/@romanagabekov?source=rss-1271bd12ede9------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*sgSwOqkemc1ypp8_j7K0Ww.jpeg</url>
            <title>Stories by Roman Agabekov on Medium</title>
            <link>https://medium.com/@romanagabekov?source=rss-1271bd12ede9------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 05:41:28 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@romanagabekov/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Safe automation for MySQL index recommendations | What’s New At Releem]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-june-2026-1c5107763bf1?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/1c5107763bf1</guid>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[postgresql]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[java]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Sun, 02 Aug 2026 04:36:56 GMT</pubDate>
            <atom:updated>2026-08-02T04:37:25.716Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6EHyPDuz9J6tnxx2YLd18g.png" /></figure><p>Over the past few months, we’ve been expanding Releem into more database environments while making recommendations easier to understand and act on. June continues that work with updates designed to shorten the path from identifying an issue to resolving it safely.</p><p>This release introduces a more guided <strong>Installation Wizard</strong>, broader <strong>PostgreSQL configuration coverage</strong>, improvements to reporting and reliability, and a new workflow for safely <strong>applying index recommendations.</strong></p><p>Together, these updates bring Releem closer to our vision of a single workflow for database performance, resource usage, security, and availability.🎯</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/releem-agent">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/releem-agent/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/releem-agent/discussions">here</a>.</li></ul><h3>Product Updates</h3><ul><li><strong>Safe automation for index recommendations</strong></li></ul><p>Releem can now safely apply index recommendations. Every change goes through a guarded workflow designed to protect availability and preserve a recovery path:</p><ol><li>Before a schema change is sent to the Agent, Releem validates whether the affected data can be recovered and whether the operation can run online in that environment.</li><li>The workflow accounts for the database distribution, version, storage engine, and table structure when selecting an eligible execution method. If the database cannot support an online backup, point-in-time recovery is unavailable, or the change would require a blocking operation, Releem stops before execution.</li><li>The Agent then checks available space in the backup and database filesystems and confirms that the required backup tools are installed. It creates a backup and runs a schema-change dry run before applying the index.</li></ol><p>Any failed prerequisite, backup, or dry run aborts the change. This gives teams a controlled path from identifying a missing index to applying it safely.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FPd-DUK0so9Y%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DPd-DUK0so9Y&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FPd-DUK0so9Y%2Fhqdefault.jpg&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/fcd3fec3d7fa1bc9ffa2d8d564a22fe7/href">https://medium.com/media/fcd3fec3d7fa1bc9ffa2d8d564a22fe7/href</a></iframe><ul><li><strong>Added multi-step Installation Wizard</strong></li></ul><p>The new Installation Wizard guides users through three setup decisions:</p><ol><li>Which database they want to connect</li><li>Where the database is running</li><li>How Releem should be installed</li></ol><p>The wizard supports MySQL, MariaDB, and PostgreSQL. For self-managed environments, users can choose Linux, Windows, WHM/cPanel, Docker, or Kubernetes. Managed cloud options include AWS, Google Cloud, and Azure.</p><p>For Linux and Windows installations, the database password is no longer entered in the web interface. The generated script requests it locally during installation, keeping the credential out of the browser-based setup flow for added security.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/741/1*nupkGA-J6sPh9JYfwz1ZSw.png" /></figure><ul><li><strong>Expanded PostgreSQL configuration recommendations</strong></li></ul><p>Releem now provides recommendations for a broader range of PostgreSQL settings, giving users more control over autovacuum behavior, memory allocation, storage use, parallel query execution, and idle transactions.</p><p>The expanded recommendation set includes:</p><p>– autovacuum_max_workers <br>– autovacuum_vacuum_cost_limit<br>– autovacuum_vacuum_cost_delay<br>– autovacuum_naptime<br>– autovacuum_vacuum_scale_factor<br>– autovacuum_vacuum_threshold</p><p>– autovacuum_analyze_scale_factor<br>– autovacuum_analyze_threshold<br>– idle_in_transaction_session_timeout<br>– hash_mem_multiplier<br>– max_parallel_workers_per_gather<br>– work_mem_recommended</p><p><em>These additions allow Releem to make more specific recommendations based on how each PostgreSQL database is operating.</em></p><ul><li><strong>Show just the recommended configuration changes</strong></li></ul><p>Recommended Configuration now includes a <strong>Show just changes</strong> view, allowing users to focus on the settings that differ from their current database configuration instead of reviewing every available value.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/926/1*EDMgJS-H_LOv_hgahFsccw.png" /></figure><ul><li><strong>Reports for invited users on shared servers</strong></li></ul><p>Invited users can now receive reports for servers shared with them. This keeps collaborators informed about the databases they work on without requiring the server owner to forward updates manually.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*h8DVM7ztbeLyVE4bMDhrjQ.png" /></figure><ul><li><strong>Removed an irrelevant security check for cloud-managed MySQL and MariaDB</strong></li></ul><p>Releem previously displayed a symlink security check for managed cloud MySQL and MariaDB instances, even though users cannot change the related setting or access the underlying host.<br>The check is now skipped for cloud-managed instances, removing a warning and advice that users could not act on.</p><ul><li><strong>Fixed deadlock analysis for names with special characters</strong></li></ul><p>Deadlock analysis can now parse quoted database and table names that contain special characters. We update the parser’s regular expressions after finding cases where these names prevented Releem from reading the deadlock output correctly.</p><ul><li><strong>Fixed an error when adding servers simultaneously</strong></li></ul><p>We fixed an error that could occur when two servers were added at the same time. Parallel server onboarding can now complete without one addition interfering with the other (<a href="https://github.com/Releem/releem-agent/issues/515)">Closes #515</a>).</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1c5107763bf1" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-june-2026-1c5107763bf1">Safe automation for MySQL index recommendations | What’s New At Releem</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Releem May 2026 Update: PostgreSQL, Azure MySQL, and Windows Automation]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-may2026-45c513518e08?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/45c513518e08</guid>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[postgresql]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Mon, 22 Jun 2026 06:31:10 GMT</pubDate>
            <atom:updated>2026-06-22T06:31:10.851Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MLbe1ES3eADnC76g1g0VDA.png" /></figure><p>Releem now supports more database environments, helping teams monitor database health, review recommendations, and improve security, performance, and reliability from one workflow.</p><p>In April and May, we added PostgreSQL support, Azure Database for MySQL support, Windows installation improvements, automated configuration changes for Windows, and several Query Analytics updates to make recommendations faster to understand. 🎉</p><p>We’ve also been sharing more of our database research with the community. This month, Gabriel presented a deep technical session at Percona Live titled <em>The Hidden Lives of Temp Tables: Unraveling MySQL Internal Management</em>.</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/mysqlconfigurer">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/mysqlconfigurer/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/mysqlconfigurer/discussions">here</a>.</li></ul><h3>Product Updates</h3><ul><li><strong>Expanded database support to PostgreSQL</strong></li></ul><p>Releem now supports PostgreSQL, giving teams a more consistent way to monitor database health, receive recommendations, and manage performance across MySQL, MariaDB, and PostgreSQL environments. Health checks, security checks, query analytics, activity monitoring, and configuration tuning are currently in place.<br><a href="https://docs.releem.com/releem-agent/installation-guides/postgresql-manual-linux"><strong>Read the PostgreSQL installation docs</strong></a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UPcrEhMV3BEjXAG11qi7Xg.png" /></figure><ul><li><strong>Expanded database support to Azure Database for MySQL</strong></li></ul><p>Releem now supports Azure database for MySQL, making it easier to connect managed MySQL environments on Azure and bring them into the same database management workflow as other supported databases (<a href="https://github.com/Releem/mysqlconfigurer/issues/265">Closes #265</a>).<br><a href="https://docs.releem.com/releem-agent/installation-guides/cloud-managed-azure-mysql-automatic-installation"><strong>Read the installation docs</strong></a></p><ul><li><strong>Improved Windows installation and automation</strong></li></ul><p>We added a Windows installer and helper scripts to simplify installation, updates, apply, and rollback workflows on Windows. This reduces manual setup and makes it easier to keep Releem Agent installed and up to date in Windows environments (<a href="https://github.com/Releem/mysqlconfigurer/issues/436">Closes #436</a>).</p><p><a href="https://docs.releem.com/releem-agent/installation-guides/self-managed-servers-manual-installation-windows"><strong>Read the Windows installation docs</strong></a></p><ul><li><strong>Safe configuration changes on Windows</strong></li></ul><p>Releem can now safely apply approved configuration changes on Windows. Teams can review recommendations in the dashboard, approve them with a click, and let Releem apply the selected changes automatically.</p><ul><li><strong>Query recommendations now shown in Query Analytics</strong></li></ul><p>Query Analytics now shows query recommendations directly inside the analytics tab. Instead of clicking a button to request results, you can see available recommendations immediately and move from identifying expensive queries to reviewing what can be improved.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/649/1*vkwo3KQ0HG6uF5iyphAM0A.png" /></figure><ul><li><strong>Last analysis details added to Query Analytics</strong></li></ul><p>Query Analytics now shows when each SQL query was last analyzed with a timestamp displayed in this format: <strong>Analyzed at: 2026.5.29 20.01</strong>. This helps teams understand whether recommendations reflect recent workload activity, which is especially useful after deployments, traffic changes, or configuration updates.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/653/1*8Cw8cRKUVbWU7QbRC5TWAQ.png" /></figure><ul><li><strong>Configurable Security Checks</strong></li></ul><p>Releem now allows you to disable Security Checks that are not relevant to your environment. This gives teams more control over security monitoring and helps reduce noise from checks that do not apply to a specific system configuration. A special thanks to our early user Jeff for suggesting this improvement 🙌 (<a href="https://github.com/Releem/mysqlconfigurer/discussions/472">Closes #472</a>)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BnKsJv07NBZGyoH4_rckCQ.gif" /></figure><ul><li><strong>Demo server added for new users</strong></li></ul><p>New users now get access to a demo server. This makes it easier to explore the Releem dashboard, review the recommendation workflow, and understand the product before connecting to a production database.</p><ul><li><strong>Notifications for invited users</strong></li></ul><p>Invited users now receive weekly reports, recommendations and other notifications, so partners and teams can bring additional users into the workflow more easily.</p><ul><li><strong>Agent security fixes</strong></li></ul><p>We shipped security fixes for Releem Agent as part of our ongoing work to keep the Agent safer and more reliable in production environments.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=45c513518e08" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-may2026-45c513518e08">Releem May 2026 Update: PostgreSQL, Azure MySQL, and Windows Automation</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What’s New At Releem — WHM/cPanel integration is available]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-march-2026-b50c04858d7d?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/b50c04858d7d</guid>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[database]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Thu, 30 Apr 2026 22:01:48 GMT</pubDate>
            <atom:updated>2026-04-30T22:01:48.780Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*v1qNhdhcWc-ZreKY.png" /></figure><p>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.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*q_rtNX4NFFaRoe4R8lHDug.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/400/1*qMOMyhMlFXEr6i2rHdF4Hg.png" /></figure><p>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.</p><p>Gabriel presented a deep technical session at Scale23X titled <a href="https://www.socallinuxexpo.org/scale/23x/presentations/hidden-lives-temp-tables-unraveling-mysql-internal-management"><em>The Hidden Lives of Temp Tables: Unraveling MySQL Internal Management</em></a>.</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/mysqlconfigurer">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/mysqlconfigurer/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/mysqlconfigurer/discussions">here</a>.</li></ul><h3>Product Updates</h3><p><strong>Batch SQL query analysis and recommendations</strong></p><p>You can now see recommendations for all queries directly in <strong>Query Analytics</strong> without any additional clicks, and save them to the <strong>Query Optimization</strong> tab for further review and optimization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xpVoGmdQwdKsMdXtu6QJUg.png" /></figure><p>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.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DZIPTC0PnY_HFly6c6JOpQ.png" /></figure><p>Releem continues to automatically identify the most impactful queries based on workload and adds them as discovered opportunities in the Query Optimization tab.</p><p><strong>Custom SQL query optimization</strong></p><p>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 <strong>Queries &amp; Schema</strong> plate go to <strong>Query Optimization</strong> tab and press + Add Custom Query</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AumYGT0rak0xHUyiJdrPjg.png" /></figure><p><strong>WHM/cPanel integration</strong></p><p>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.</p><p>Learn more in the <a href="https://docs.releem.com/releem-agent/installation-guides/whm-cpanel">documentation</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CUY-NgoX7FnOxMB6Ae1T4A.png" /></figure><p><strong>API and WHMCS integration for hosting partners</strong></p><p>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.</p><p>Releem also integrates with <strong>WHMCS</strong>, allowing providers to sell and manage Database Advisor as an add-on through their existing billing workflows.</p><p><a href="https://releem.com/get-releem-partner-deck">Get the partner deck</a> to learn more about integration and partnership options.</p><p><strong>AWS Aurora Serverless support</strong></p><p>We added support for AWS Aurora Serverless, bringing Releem’s performance analysis and recommendations to these environments (<a href="https://github.com/Releem/mysqlconfigurer/discussions/477">Feature request #477</a>).<br>The installation process is the same as for AWS RDS.</p><p><strong>Deadlock export to CSV</strong></p><p>Detected deadlocks can now be exported to CSV for external analysis and reporting (<a href="https://github.com/Releem/mysqlconfigurer/discussions/503">Feature request #503</a>).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kTvk0qgUnKEaeyn6vjEAgQ.png" /></figure><p><strong>Improved data collection performance</strong></p><p>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 (<a href="https://github.com/Releem/mysqlconfigurer/issues/500">Issue #500</a>).</p><p><strong>Uninstallation dependency fix</strong></p><p>The agent no longer downloads unnecessary dependencies during uninstallation (<a href="https://github.com/Releem/mysqlconfigurer/issues/466">Issue #466</a>).</p><p><strong>Duplicate index detection improvement</strong></p><p>We improved duplicate index analysis to account for foreign key-backed indexes, helping prevent unsafe recommendations during index optimization (<a href="https://github.com/Releem/mysqlconfigurer/issues/478">Issue #478</a>).</p><p><strong>Expanded query parser support</strong></p><p>Releem now supports optimization for queries that start with ‘(‘ instead of ‘SELECT’ (<a href="https://github.com/Releem/mysqlconfigurer/issues/427">Issue #427</a>).</p><p><strong>Offline agent apply-task fix</strong></p><p>We fixed an issue that allowed configuration apply tasks to be scheduled while the agent was offline (<a href="https://github.com/Releem/mysqlconfigurer/issues/311">Issue #311</a>).</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b50c04858d7d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-march-2026-b50c04858d7d">What’s New At Releem — WHM/cPanel integration is available</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What’s New At Releem — January 2026]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-january-2026-b64ccd7ce6ef?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/b64ccd7ce6ef</guid>
            <category><![CDATA[database]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[web-development]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Thu, 05 Mar 2026 16:56:17 GMT</pubDate>
            <atom:updated>2026-03-05T16:57:37.563Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*9QZu_nH-xRS7EpW-.png" /></figure><p>In the first month of the new year, we focused on practical improvements for the Dashboard, Platform, and Agent, while continuing development on a set of larger integrations that are nearing release. We’ll be sharing details soon.</p><p>In March, we’ll be at <a href="https://www.cloudfest.com/event"><strong>CloudFest in Germany (23–26 March)</strong></a>, and you can find us in <strong>Startup Alley</strong>. If you’re planning to attend, let us know so we can connect in person and discuss database performance, automation, and partnership opportunities.</p><p>For Releem Community members, we have <strong>free tickets available</strong>. <br>To claim your free ticket and save € <strong>499</strong>, just send us request.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*7bkLs509NhRg5v4TTA48gg.png" /></figure><p>We also shipped <strong>Dashboard Sharing 💪</strong> This was something we initially treated as a lower-priority request, but it kept coming up. Eventually it became clear it was blocking teams from using Releem together, so we moved it up and shipped it.</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/mysqlconfigurer">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/mysqlconfigurer/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/mysqlconfigurer/discussions">here</a>.</li></ul><h3>Updates to Releem Dashboard</h3><p>This month’s dashboard updates concentrate on making Query Analytics easier to work with and streamlining how you handle optimization recommendations:</p><ul><li><strong>Filtering control statements</strong></li></ul><p>You can now filter out control statements such as <strong>COMMIT, USE</strong>, and similar commands inside Query Analytics. This helps isolate performance-relevant queries without noise from session or transaction control statements (<a href="https://github.com/Releem/mysqlconfigurer/issues/457">Closes #457</a>).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*FKWIS8iFeIGHJUiETQLPUw.png" /></figure><ul><li><strong>Improved query optimization workflow</strong></li></ul><p>You can now delete optimization recommendations directly from the interface, with a confirmation step to prevent accidental removal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kPFymDidH8Hax6n2-WCaXA.png" /></figure><ul><li><strong>Filter queries by status</strong></li></ul><p>Easily filter optimization recommendations by status to focus only on discovered, custom or optimized items.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/1*cVVS33eyUaTHJarHwHRocw.png" /></figure><ul><li><strong>Optional schema checks</strong></li></ul><p>You can now disable schema checks when they’re not relevant to your database environment.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zKCYzP2sQEu5VAnAixvdpA.png" /></figure><ul><li><strong>Google authentication</strong></li></ul><p>Google Sign-In is now available during new account registration, making it faster to get started with Releem.</p><h3>Updates to Releem Platform</h3><p>We pushed out several fixes this month to improve reliability and compatibility:</p><ul><li>Fixed duplicate entry errors during multiple team member invitations (<a href="https://github.com/Releem/mysqlconfigurer/issues/489">Closes #489</a>).</li><li>Fixed InnoDB index key size detection logic (<a href="https://github.com/Releem/mysqlconfigurer/issues/487">Closes #487</a>).</li><li>Fixed configuration application issues for RDS MariaDB instances (<a href="https://github.com/Releem/mysqlconfigurer/issues/484">Closes #484</a>).</li></ul><h3>Updates to Releem Agent</h3><p>We simplified Releem Agent installation for WHM/cPanel environments.</p><p>The agent received security and performance improvements:</p><ul><li><strong>Updated Go and dependencies</strong> to the latest versions, resolving critical and high-severity CVEs.</li><li><strong>Removed envsubst</strong> from the Agent image to eliminate unnecessary vulnerability exposure.</li><li><strong>Fixed an issue that triggered full table scans </strong>during constraint metadata collection, reducing impact on database servers (<a href="https://github.com/Releem/mysqlconfigurer/issues/493">Closes #493</a>).</li></ul><h3>Events</h3><p>We spoke at AI DBA Conf and MariaDB Day in Brussels during FOSDEM, connecting with DBAs and engineers focused on automation and database performance.</p><p>If you missed these sessions, you can watch them here:</p><ul><li><a href="https://youtu.be/CXTJLkv9ZIk?si=spwZxIEJtA7s5bS3">From Manual DBA Work to Safe Automation</a></li><li><a href="https://youtu.be/NJue5xXyFkQ?si=1YZLokD5rfz5GbZH">SQL Query Optimization Without Query Ownership</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b64ccd7ce6ef" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-january-2026-b64ccd7ce6ef">What’s New At Releem — January 2026</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[When “MySQL” isn’t actually MySQL]]></title>
            <link>https://medium.com/@romanagabekov/when-mysql-isnt-actually-mysql-6ecc071d536a?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/6ecc071d536a</guid>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[backend-development]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[saas]]></category>
            <category><![CDATA[devops]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Tue, 17 Feb 2026 14:17:02 GMT</pubDate>
            <atom:updated>2026-02-17T14:22:47.965Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EfVKwQSPUF2T2wUHji5zqA.png" /></figure><p>I was recently looking at engine distribution across a few thousand production database instances running Releem agent.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/967/1*oxBg-OPOOEw8WbDqb4bD9Q.png" /></figure><p>What stood out is that some teams believed they were running MySQL, but were actually on MariaDB.</p><p>In most cases this isn’t confusion. It’s environment defaults.</p><p>Many Linux distributions replaced MySQL with MariaDB years ago. Hosting panels and cloud images often install MariaDB by default. The mysql client works the same. ORMs abstract most differences. From the application layer, everything looks like “MySQL.”</p><p>Is your database engine an intentional architectural choice, or something inherited from your base image or hosting stack?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6ecc071d536a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Releem 2025 Recap: Building a Database Advisor for Developer Teams]]></title>
            <link>https://medium.com/releem/releem-2025-recap-dbb1fa5803d8?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/dbb1fa5803d8</guid>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[ai]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Thu, 22 Jan 2026 15:26:33 GMT</pubDate>
            <atom:updated>2026-01-22T15:26:33.009Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fvv6hoAMs4I8KC0fkZqrVQ.png" /></figure><p>Hello friends 👋</p><p>2025 was the year we finally had the team we needed.</p><p>For most of Releem’s existence, I was the bottleneck. Features sat in backlogs. Support tickets aged. Every decision waited on me.</p><p>Getting <a href="https://www.linkedin.com/in/victor-podkopaev/">Victor</a> and <a href="https://www.linkedin.com/in/dmitrii-kochetov-563a36354/">Dmitrii</a> full-time changed that overnight. Features moved from idea to production faster, and more time went into tickets, feedback, and edge cases.</p><p>We also welcomed the <a href="https://releem.com/blog/tuningwizard-joins-releem">TuningWizard team and their founder Gabriel</a><strong> </strong>to Releem. Their hands-on SQL optimization experience directly shaped how we analyze queries today and pushed us to raise the bar on accuracy and safety.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*B0w5sp7WWVAc04kzkaQA_w.jpeg" /></figure><p>The scale still surprises me. We reached milestones that honestly felt far away when we started:</p><ul><li>348 billion SQL queries collected</li><li>808 million API requests</li><li>714,000 schema recommendations</li><li>6 million query recommendations</li><li>571,000 deadlocks detected and analyzed</li><li>53,000 config tuning suggestions</li><li>Around 1,000 new users joined along the way 🚀</li></ul><h3>What we shipped</h3><p>On the product side we spent most of the year improving visibility into problems that usually surface too late, and adding automation that is safe to trust in live systems. This included:</p><ul><li>Real-time deadlock detection with root cause analysis</li><li>Live visibility into blocking and long-running queries</li><li>Schema checks for missing, unused, and redundant indexes</li><li>Full configuration history with before-and-after performance metrics</li><li>Full support for GCP Cloud SQL</li><li>Per-server access control and user roles</li></ul><p>Oh, and Dark Mode🌙. Users <em>really</em> wanted dark mode.</p><h3>Thank you</h3><p>Behind the scenes, the team ran more than <strong>100 live demos</strong>, answered over <strong>1,400 support questions</strong>, shipped <strong>1,292 commits</strong>, and <strong>deployed the platform roughly 200 times</strong>.</p><p>None of this would be possible without everyone who was willing to try something new, report issues, ask hard questions, and push us to do better. Thank you to our early adopters, our customers, and the broader database community for the trust and feedback throughout the year ❤️</p><p>We are proud of what we built in 2025 and excited to keep going in 2026.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dbb1fa5803d8" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/releem-2025-recap-dbb1fa5803d8">Releem 2025 Recap: Building a Database Advisor for Developer Teams</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What’s New At Releem — November 2025]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-november-2025-af6fe1009b01?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/af6fe1009b01</guid>
            <category><![CDATA[saas]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[devops]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Wed, 24 Dec 2025 22:17:11 GMT</pubDate>
            <atom:updated>2025-12-24T22:17:11.822Z</atom:updated>
            <content:encoded><![CDATA[<h3>What’s New At Releem — November 2025</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QnX36Yp6RTsonqzv0TILDQ.png" /></figure><p>Another month wrapped up at Releem, and this month we focused on removing friction in everyday workflows.</p><p>We finally brought <strong>Dark Mode</strong> to Releem Dashboard 🎉 It took longer than expected, with small UI details needing clean up before it was ready to ship. We quietly rolled the feature out, but a few dozen users enabled it right away!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*B5tKM4gBlsXOVtxnnb3Y8A.png" /></figure><p>We also shipped <strong>Dashboard Sharing 💪</strong> This was something we initially treated as a lower-priority request, but it kept coming up. Eventually it became clear it was blocking teams from using Releem together, so we moved it up and shipped it.</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/mysqlconfigurer">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/mysqlconfigurer/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/mysqlconfigurer/discussions">here</a>.</li></ul><h3>Updates to Releem Dashboard</h3><p>We’ve shipped a set of dashboard improvements focused on usability, collaboration, and the workflows you use everyday:</p><ul><li><strong>Dashboard Sharing &amp; User Roles</strong></li></ul><p>You can now invite users to shared dashboards per server through server Settings and assign roles (<a href="https://github.com/Releem/mysqlconfigurer/discussions/279">Issue #279</a>):</p><ul><li>Viewer — Read-only access to dashboard and insights</li><li>Editor — Can change settings and apply recommendations.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*51u-_H4IAX8iZGhuyME4Ew.png" /></figure><ul><li><strong>Dark Mode</strong></li></ul><p>You can now apply a dark theme to the dashboard. Dark Mode has always had a dedicated group of users who overwhelmingly prefer it to light mode. We’re glad to finally make it available.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MRX-N-sUb4eFmKREFi9rvQ.png" /></figure><ul><li><strong>Export Process List to CSV</strong></li></ul><p>You can now export the process list directly to CSV, making it easier to analyze queries, share snapshots, and include data in reports and incident reviews (<a href="https://github.com/Releem/mysqlconfigurer/discussions/437">Issue #437</a>).</p><ul><li><strong>Improved Apply Workflow</strong></li></ul><p>To reduce confusion during configuration changes, the <strong>Apply</strong> button has been moved directly into the <strong>Recommended Configuration</strong> popup. This keeps review and action in one place.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_qQ0pKRiThPuBFtIu815dA.png" /></figure><h3>Updates to Releem Platform</h3><p>Several fixes this month focused on recommendation accuracy and schema analysis:</p><ul><li><strong>Smarter Buffer Pool Recommendations</strong></li></ul><p>Releem now takes overall system memory pressure into account when generating <strong>innodb_buffer_pool_size</strong> recommendations. When RAM usage is already high, recommended values are scaled down instead of being calculated solely from total available memory. This prevents over-allocation in constrained environments and reduces the risk of memory pressure (<a href="https://github.com/Releem/mysqlconfigurer/issues/481">Issue #481</a>).</p><ul><li><strong>Primary Key Detection Fix</strong></li></ul><p>Resolved an issue where tables could be flagged as missing a primary key where the Agent has limited schema permissions. Previously, missing column-level metadata could lead to false “no primary key” warnings. The updated logic now handles these cases correctly (<a href="https://github.com/Releem/mysqlconfigurer/issues/475">Issue #475</a>).</p><h3>Updates to Releem Agent</h3><ul><li><strong>Expanded Initial Configuration Options</strong></li></ul><p>We added support for generating an initial MySQL configuration directly from the Releem Agent. With a single command, the agent analyzes server hardware and creates a sensible baseline config for new or default MySQL installations, before workload-based tuning kicks in. You can find full details in the <a href="https://docs.releem.com/configuration-tuning/initial-mysql-configuration">updated documentation</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=af6fe1009b01" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-november-2025-af6fe1009b01">What’s New At Releem — November 2025</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What’s New At Releem — October 2025]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-october-2025-f63d9f6aa030?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/f63d9f6aa030</guid>
            <category><![CDATA[mariadb]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[mysql]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Wed, 12 Nov 2025 14:37:42 GMT</pubDate>
            <atom:updated>2025-11-12T14:37:42.840Z</atom:updated>
            <content:encoded><![CDATA[<h3>What’s New At Releem — October 2025</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nazRO4Pj0yxmOKpqjLquiw.png" /></figure><p>Another month in the books — and it’s been a great one. Highlights include support for GCP Cloud SQL, enhanced servers overview for multi-server management, and a round of Agent improvements focused on stability and lighter performance impact.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0GNia3XmgFSgJkSAxSn3Eg.png" /></figure><p>Kicking things off, we’re excited to share that the <strong>TuningWizard </strong>team has officially joined Releem, bringing their expertise in database optimization and performance analytics directly into what we’re building together.</p><p>Led by <strong>Gabriel Ciciliani</strong>, TuningWizard has spent the past four years perfecting SQL Query Optimization, helping users identify costly queries and improve performance with precision. This partnership traces back to an introduction by <strong>Peter Zaitsev</strong>, founder of Percona, which sparked a collaboration that’s been growing ever since. You can read more about how the teams are merging efforts in our <a href="https://releem.com/blog/tuningwizard-joins-releem">official announcement</a>.</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/mysqlconfigurer">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/mysqlconfigurer/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/mysqlconfigurer/discussions">here</a>.</li></ul><h3>Updates to Releem Dashboard</h3><p>We’ve added new controls to simplify <strong>multi-server management</strong> and speed up configuration workflows across all your databases:</p><h4><strong>Servers Overview Bar</strong></h4><p>Provides a quick summary of total servers and pending configurations directly on the <strong>Servers</strong> page, improving visibility and navigation for teams managing multiple instances.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MEAZaQDYwS7ehwwEGT_68w.png" /></figure><h4><strong>One-Click Apply Across Servers</strong></h4><p>You can now apply configuration recommendations to all servers simultaneously. This reduces repetitive work and saves you even more time (<a href="https://github.com/Releem/mysqlconfigurer/discussions/452">Feature request #452</a>).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/781/1*b-G1mlCuf1vcN2kDOCeS5g.png" /></figure><h4><strong>Status Indicators</strong></h4><p>Adds clear visual markers for <strong>Error</strong> and <strong>Unapplied</strong> configurations, helping you see what needs attention at a glance.</p><h4><strong>Automatic Restart Option</strong></h4><p>A new “Restart if needed” checkbox allows Releem to safely handle restarts during configuration updates without your intervention.</p><h3>Updates to Releem Platform</h3><p>We’ve expanded Releem’s platform with smarter indexing and broader cloud coverage. This update helps optimize complex queries and brings full support for Google Cloud SQL alongside AWS RDS:</p><h4><strong>GCP Cloud SQL Support</strong></h4><p>Adds full integration for Google Cloud’s managed MySQL and PostgreSQL databases, joining existing AWS RDS and Azure Database compatibility (<a href="https://github.com/Releem/mysqlconfigurer/discussions/259">Feature request #259</a>). Enterprise customers can now enjoy complete cloud provider coverage with Releem.</p><h4><strong>GROUP BY / ORDER BY Index Detection</strong></h4><p>Now identifies missing indexes in queries that aggregate or sort large result sets, cutting down on processing time for reporting and analytics (<a href="https://github.com/Releem/mysqlconfigurer/issues/441">Issue #441</a>).<br>- Looks at real query history to pinpoint where indexes will make the biggest difference and suggest practical fixes.<br>- In testing, these improvements have delivered 30–50% faster query performance for affected queries.</p><h4><strong>Index Identification Accuracy</strong></h4><p>Fixed an issue where optimization recommendations remained marked as “Discovered” even after indexes were created. The platform now correctly tracks index changes across multiple databases and updates the status to “Evaluating” once the fix is applied (<a href="https://github.com/Releem/mysqlconfigurer/issues/474">Issue #474</a>).</p><h3>Updates to Releem Agent</h3><p>We’ve improved Releem Agent to make it more accurate, responsive, and efficient. It now handles version changes and server reporting more smoothly while using fewer resources overall.</p><h4><strong>Database Upgrade Detection</strong></h4><p>The Agent now recognizes the exact MySQL / MariaDB / Percona version when the database is upgraded and updates recommendations to match. This prevents outdated or irrelevant suggestions when variables are added, changed, or deprecated in newer releases (<a href="https://github.com/Releem/mysqlconfigurer/issues/408">Issue #408</a>).</p><h4><strong>Server Visibility Fix</strong></h4><p>Now registers servers in the Releem Dashboard immediately after startup. Previously, some servers remained invisible for hours if the Agent existed during early metric collection (<a href="https://github.com/Releem/mysqlconfigurer/issues/411">Issue #411</a>).</p><h4><strong>Optimized Data Collection</strong></h4><p>Streamlined how query examples and process data are gathered. This has lowered Agent resource consumption by 25% and sped up metric collection. Monitoring now runs with less impact on production workloads.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f63d9f6aa030" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-october-2025-f63d9f6aa030">What’s New At Releem — October 2025</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What’s New At Releem — September 2025]]></title>
            <link>https://medium.com/releem/whats-new-at-releem-september-2025-243fd04271cd?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/243fd04271cd</guid>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[devops]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[mysql]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Tue, 28 Oct 2025 09:50:26 GMT</pubDate>
            <atom:updated>2025-10-28T09:50:26.285Z</atom:updated>
            <content:encoded><![CDATA[<h3>What’s New At Releem — September 2025</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*9-U0iXI0x8sC3t5S.png" /></figure><p>September was a month of momentum. We focused on problems that frustrate every DBA: deadlocks, incomplete visibility, and cloud deployment quirks. We’ve shipped real-time deadlock monitoring, expanded the weekly reports, and fixed key issues with Releem Agent for RDS.</p><p>Beyond the product, our company flag reached <a href="https://www.linkedin.com/feed/update/urn:li:activity:7371856454883966976/">Kazbek Mountain</a> (5,047m and one of the highest peaks in the Caucasus). It’s a small but symbolic reminder of how far we’ve come as a team and community.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0lCZDABnWMLMMWdE4rFvkg.png" /></figure><p>And while one part of the team was climbing mountains, our <a href="https://www.linkedin.com/posts/roman-agabekov_proud-of-the-team-my-co-founders-dmytrii-activity-7368326799723864066-Act3/">co-founders Dmytrii Kochetov and Victor Podkopaev</a> represented at Percona University Yerevan 2025. They shared insights into how LLMs can help with database performance tuning.</p><h3>Community Contributions</h3><p>We’re always collecting issues and feature requests on <a href="https://github.com/Releem/mysqlconfigurer">our GitHub</a>. Here’s where you can contribute:</p><ul><li><strong>Issues</strong> — If you encounter any problems or bugs, report them <a href="https://github.com/Releem/mysqlconfigurer/issues">here</a>.</li><li><strong>Feature Requests</strong> — Have an idea to make Releem even better? Share your suggestions <a href="https://github.com/Releem/mysqlconfigurer/discussions">here</a>.</li></ul><h3>Updates to Releem Dashboard</h3><p><strong>Deadlock Monitoring</strong></p><p>After many requests, real-time MySQL and MariaDB deadlock detection has landed (<a href="https://github.com/Releem/mysqlconfigurer/discussions/293">Issue #293</a>). No more hunting through logs. You’ll now see:</p><p>- Instant alerts when a deadlock occurs<br>- A detailed breakdown of conflicting transactions<br>- Actionable recommendations to prevent recurrence</p><p><a href="https://releem.com/blog/mysql-deadlock-detection">Read our full deep-dive on deadlock detection to learn more</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pPdB3CNCOvT50rZGMroIKw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/936/1*ikbitNCel9yp-6LOcratAQ.png" /></figure><p><strong>New Weekly Reports</strong></p><p>Weekly reports now give a richer snapshot of your server health including:</p><ul><li>Expanded Health Checks — System, MyISAM/InnoDB, Memory, Queries/Logs</li><li>A new Security Check summary with severity levels</li><li>Cleaner formatting for quick scanning</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2oWPX3iiOKaN6iK4zhuAAw.png" /></figure><h3>Updates to Releem Agent</h3><p><strong>Resolved AWS Security Hub Alerts</strong></p><p>Releem Agent was previously being flagged by AWS Security Hub. The new update corrects those triggers (<a href="https://github.com/releem/mysqlconfigurer/issues/415">Issue #415</a>).</p><p><strong>Improved EC2 Deployment Documentation</strong></p><p>We’ve added guidance for monitoring multiple RDS instances from one EC2 instance. This reduces setup overhead and cuts Fargate resource costs. Read the documentation <a href="https://docs.releem.com/releem-agent/installation-guides/cloud-managed-aws-rds-automatic-installation">here</a>.</p><p><strong>Stabilized Setup Process</strong></p><p>Fixed an issue that caused the Agent to restart MySQL/MariaDB unnecessarily during initial installation. It was annoying everyone and we’re glad it’s no longer a problem (<a href="https://github.com/releem/mysqlconfigurer/issues/413">Issue #413</a>)</p><h3>News You Might Have Missed</h3><p><em>Laravel News</em> recently covered a Releem study on how MySQL’s default settings can drag down performance for Laravel apps. It’s a great read if you want to learn more about what’s hiding behind “out-of-the-box” configurations. <a href="https://laravel-news.com/the-hidden-cost-of-mysql-defaults-in-laravel-apps">The Hidden Cost of MySQL Defaults in Laravel Apps</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7v9a5i2ee-8JXRcaWpS9CQ.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=243fd04271cd" width="1" height="1" alt=""><hr><p><a href="https://medium.com/releem/whats-new-at-releem-september-2025-243fd04271cd">What’s New At Releem — September 2025</a> was originally published in <a href="https://medium.com/releem">Releem</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[ChatGPT Alternative for SQL Query Optimization]]></title>
            <link>https://medium.com/@romanagabekov/chatgpt-alternative-for-sql-query-optimization-da90134b5cb1?source=rss-1271bd12ede9------2</link>
            <guid isPermaLink="false">https://medium.com/p/da90134b5cb1</guid>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Roman Agabekov]]></dc:creator>
            <pubDate>Mon, 13 Oct 2025 10:54:28 GMT</pubDate>
            <atom:updated>2025-10-13T11:06:48.641Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/780/0*Cs1yQ05YkHvgyBt8.jpg" /></figure><p>Working with SQL query optimizers powered by LLMs has its ups and downs. I’ve noticed that even with tools like ChatGPT or Claude, the process can feel awkward:</p><pre>Write a prompt → Paste the query → Wait → Refine prompt → Repeat</pre><p>This cycle is fine once or twice, but quickly becomes tedious — especially for long or complex queries.</p><p>So I built a tool that removes prompt engineering from the equation and focuses purely on helping you analyze and optimize SQL queries.</p><h3>How It Works</h3><pre>1. Paste your SQL query <br>2. Select your database (PostgreSQL, MySQL, SQL Server, etc.) <br>3. Click &quot;Analyze&quot;</pre><p>The screenshot:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*DA3hcgiL6yBvplT3.png" /><figcaption>SQLito Step 1 Screenshot</figcaption></figure><h3>You’ll Get</h3><pre>- ✅ A list of suggestions with brief reasoning <br>- 🔄 A rewritten (optimized) version of your query <br>- 🎯 A confidence tag for each recommendation (High / Medium / Low)</pre><p>The screenshot:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*C8qQg-OXht325VKj.png" /><figcaption>SQLito Analysis Report</figcaption></figure><h3>Want deeper insights?</h3><p>You can optionally add:<br>- EXPLAIN plan<br>- Schema<br>- Indexes<br>- Table stats</p><p>The tool will use this additional context to refine its suggestions and increase recommendation confidence.</p><p>The screenshot of this step:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*Q0TjwBSlFp0w50m2.png" /><figcaption>SQLito Enhanced Analysis</figcaption></figure><h3>Deeper Technical Rationale</h3><p>The tool supports two levels of analysis:</p><p><strong>1. Standard Analysis (available to all users)</strong></p><p>When you paste a SQL query and click “Analyze”, the system runs a one-step evaluation:</p><ul><li>Parses the query syntax and structure.</li><li>Identifies common inefficiencies.</li><li>Generates a list of suggestions based on known performance patterns and best practices.</li><li>Provides an optimized version of the query.</li><li>Assigns confidence tags based on available context.</li></ul><blockquote>This mode is fast and lightweight, ideal for quick feedback.</blockquote><p><strong>2. Deep Analysis (available to registered users)</strong></p><p>Deep Analysis follows a multi-stage reasoning process using an internal AI agent:</p><ol><li>Hypothesis Generation<br> The model builds multiple performance-related hypotheses based on the SQL query and any provided context — including schema, EXPLAIN plans, table/index stats, constraints, etc.</li><li>Validation and Filtering<br> It then self-evaluates each recommendation. Weak or irrelevant suggestions are filtered out. This step prevents common LLM hallucinations or overly generic advice.</li><li>Optimized Query Generation<br> A refined, rewritten query is generated — informed by the validated insights and context.</li></ol><blockquote>This approach improves both precision and reliability of recommendations, especially for complex queries involving joins, CTEs, subqueries, or large tables.</blockquote><h3>Who is this for?</h3><p>This tool isn’t trying to replace profilers or DB-specific advisors. It’s designed for:</p><ul><li>Developers who want quick feedback on queries</li><li>Teams who want to share and discuss queries</li><li>People learning SQL who want to understand improvements</li></ul><h3>Give It a Shot</h3><p>You can try the tool here: <a href="https://sqli.to/">https://sqli.to</a></p><p>I’d love to hear your thoughts❤️</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=da90134b5cb1" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>