Frequently Asked Questions

We created a guide for you to make this process easier. Learn more

Security is our top priority. Releem Agent does not collect any user data.

The Releem agent is open-source and does not require opening ports.

The Releem agent collects the following data:
- Memory, CPU, and disk usage statistics
- MySQL system variables & status information
- Data size statistics from information_schema
- Table & schema names (but not actual table content)
- Table structure details, indexes, and usage statistics for schema optimization
- Query execution statistics with placeholders from performance_schema, including execution counts, average execution time, query example, and EXPLAIN plans for the top queries

We use HTTPS to transfer metrics.

Try Releem free for 14 days: access all premium features, optimize MySQL performance, and get actionable recommendations.

Releem Score is a metric based on Best Practises developed by Releem and designed to classify how well a MySQL configuration is performing. The Releem Score can be accessed at any time via the Releem Customer Portal, on the metrics page.
Detailed information you can see in documentation.

Releem focuses on tuning MySQL server settings. The full list of settings you can see in documentation.

You'll receive your first set of recommended configurations within 24 hours of adding your server to Releem.

Releem continuously searches for opportunities to improve your MySQL performance. Whenever our system identifies a viable hypothesis, we'll generate a new set of recommendations and notify you. The frequency of new recommendations depends on your server's unique performance patterns and workload.

Rest assured, Releem does not automatically implement any configurations without your explicit action. Configurations are applied only when you choose to hit the "Apply Now" button or execute a specific SSH command. Before making any changes, you have the opportunity to review and compare the proposed configurations with your current settings.

Additionally, for those who prefer, there's an option to automate the application of configurations during maintenance window by setting up a dedicated cron job.

You have the option to include your business address and VAT identification on the payment page while upgrading. Additionally, you can access any of your past invoices and select the Add Address & VAT Number link to accomplish this.

Our payment service Paddle automatically emails you an invoice after each transaction. You can click on a link in this email to get your invoice.

Releem restarts MySQL to apply recommended configurations. Latency often spikes due to the database operating with cold caches. Learn more

This indicates that certain health checks differ from best practices. Avoid taking any action, Releem will consistently seek to enhance it.

This indicates that certain health checks differ from best practices. Avoid taking any action, Releem will consistently seek to enhance it.

To rollback to the previous configuration:
/bin/bash /opt/releem/mysqlconfigurer.sh -r

To uninstall Releem Agent, run this command as root:
bash -c "$(curl -L https://releem.s3.amazonaws.com/v2/install.sh)" uninstall

Currently, Releem does not support DigitalOcean managed databases, but this feature is on the roadmap. You can follow and upvote the feature request here: https://github.com/Releem/mysqlconfigurer/discussions/366

Currently, root permissions are required to install and run the Releem agent. You need to ask your service provider to install the Releem agent on your managed server.

To disable Schema & Query optimization in Releem, follow the guide at https://docs.releem.com/query-optimization/disable-sql-query-optimization. This will stop the feature from running and reduce related load.

In your PHP application, enable emulated prepared statements by setting PDO::ATTR_EMULATE_PREPARES to true during the database connection. For XenForo, check if the configuration parameter $config['db']['enableEmulatePrepares'] exists in src/config.php, although official support may be limited.

Setting init-connect = 'SET NAMES utf8mb4' in your MariaDB configuration generally does not affect performance negatively and is used to ensure proper character encoding.

The recommended value depends on your performance and durability needs. Setting innodb_flush_log_at_trx_commit to 1 ensures full ACID compliance but may reduce performance. Values 0 or 2 improve performance but risk data loss in a crash. Evaluate based on your workload and risk tolerance.

Currently, invoices are sent automatically via email by the payment service Paddle. You cannot download invoices directly from the portal, but you can access them through the email link provided after each transaction.

To apply a discount coupon, go to your Profile, click the Upgrade button, select an annual plan, and subscribe to the 1 DB Instance plan. Click the 'Add discount' link, enter the coupon code (e.g., 131A7300), and set your VAT ID if applicable. Paddle will then charge your card with the discounted price.

Currently, the option to choose data storage location in the EU is available only for customers with more than 20 instances, but this can be discussed on a case-by-case basis.

Currently, Query Analytics calculates statistics based on database name and query digest without user-level data. To distinguish queries by user, you can use the Process List tab during slow query execution to see current queries and their executors. However, this is limited and filtering by user is not yet supported but is being considered for future updates.

Add the following lines to /opt/releem/releem.conf with your AWS region and RDS instance name: instance_type="aws/rds" aws_region="[AWS_REGION]" aws_rds_db="[RDS_INSTANCE_NAME]" aws_rds_parameter_group="releem-agent". Then restart the agent with 'systemctl restart releem-agent'. For Kubernetes (EKS) installations, ensure one agent runs per primary and secondary pod.

To configure Releem to account for other services running on your server, go to Settings and set the Memory Limit option to the amount of memory allocated for the database server. Releem will then tune the database server according to this limit.

You can apply recommendations immediately even if the Recommended Configuration is still preparing. Releem continuously analyzes workload and updates recommendations accordingly.

Before running ALTER TABLE to change the engine, execute the command `set sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION";` to avoid invalid default value errors.

You can wait for the new configuration to appear automatically as Releem updates recommendations based on the changed data distribution.

Infrequent server shutdowns (less than once a day) do not affect Releem's operation.

Releem agent does not read binlogs, so purging them will not impact its functionality.

Releem collects data every 12 hours to generate updated recommendations. More details are available in the guide at https://docs.releem.com/getting-started/step-3-getting-and-applying-recommendations

Currently, there are no explicit instructions in the documentation for uninstalling the Releem Agent on Windows. However, you can disable the Windows service named "releem-agent" via the Services management console to effectively stop the agent.

You do not need to remove the demo server before upgrading. You can upgrade to the Scale plan first and then delete the demo server later if you wish.

To enable SSL connections for the Releem agent in ECS/Fargate, update your CloudFormation stack by replacing the existing template with the latest one from https://releem.s3.us-east-1.amazonaws.com/test/releem-agent-cloudformation.yml. Set the DBSSLMode option to true and update the Image option to at least version 'releem/releem-agent:1.22.0.1' or newer. This version supports environment variables for SSL connections. Currently, you must ensure the agent can access the necessary CA certificates, although specifying the CA cert location explicitly may require additional configuration or feature support.

This error usually indicates that Performance Insights or the Performance Schema is disabled on your RDS instance. To fix it, enable Performance Insights in the AWS RDS console and set the 'performance_schema' variable to 1 in your DB Parameter Group. After applying these changes, restart your instance or the agent to ensure the metrics are collected properly.

The Releem agent is a lightweight Go application that collects global variables and performance schema data every minute, which should have minimal impact on database performance. More intensive query optimizations run every 12 hours and are split into multiple queries. Performance impact may occur only if the agent runs on servers with more than 10 databases, but there is a setting to limit the number of databases for optimization to mitigate this.

Without enabling SQL Query Optimization, Releem will not provide query and schema suggestions. This feature requires the agent to have broader database access, which may conflict with security policies in compliance-sensitive environments. You can still use other monitoring features without it.

Releem offers a special pricing plan for hosting and service providers starting at $99 for 9 servers, with volume discounts available. This offer focuses on configuration tuning services. For more details, visit https://releem.com/pricing.

You can report server issues by specifying which server is experiencing problems in your communication with Releem support. The support team will then investigate the issue on their end to provide assistance.

Yes, Releem supports both Configuration Tuning and SQL Query Optimization. You can choose to use either or both features depending on your needs. If you have been using only Configuration Tuning, you can discuss with support about exploring SQL Query Optimization as well.

The query and schema optimization are the most valuable features. Additionally, configuration tuning is also very helpful, as it helps with specialized database server settings, which can be challenging without deep backend expertise. Learn more

Go to the server list page on the dashboard, click the 'Edit' button next to the server you want to remove, and follow the on-screen instructions to delete the unused server.

Yes, documentation is available at https://docs.releem.com/query-optimization/enable-sql-query-optimization. Additional details and blog posts can be found at https://releem.com/mysql-schema-optimization and https://releem.com/blog/introducing-automatic-sql-query-optimization.

Pricing varies depending on company type and needs. For hosting providers that do not require SQL query optimization, different pricing applies. Please provide more information about your company and specific needs to get an accurate quote.

Releem offers pricing plans tailored for customers managing multiple database servers. You can view the new pricing at releem.com/pricing, which is better aligned for teams managing several databases. If you need a new plan, contact support to find the best option for your setup.

If your application uses MySQL Prepared Statements, it can limit query analytics. For PHP applications, enable emulated Prepared Statements by setting PDO::ATTR_EMULATE_PREPARES during database connection. This allows Releem to capture all SQL queries for better analysis and optimization. More details are available at https://docs.releem.com/query-optimization/prepared-statements-issue.

To start a free trial, sign up at https://app.releem.com. Complete the onboarding steps, including entering usage details and adding a new server. After you click on the added server, fill in payment information and start the free trial. Once the trial is active, you can add multiple servers from the dashboard. Note that popup blockers may interfere with trial activation, so ensure popups are allowed for the site.

You need to manually create a 'releem' user in MySQL first. Then run the installation process following the guide at https://docs.releem.com/releem-agent/installation-guides/self-managed-servers-manual-installation-linux.

Check the queries causing latency by clicking on the graph in analytics and sorting queries by average execution time. Releem measures latency as the 99th percentile of all queries, so long-running queries included there can cause spikes.

Currently, Releem does not support MSSQL.