Disable SQL Query Optimization

To disable the SQL Query Optimization feature, please select your installation type and follow the instructions below.

Linux

1. Edit the Releem Agent configuration file:

nano /opt/releem/releem.conf

2. Change the setting:

query_optimization=false

3. Restart the agent:

systemctl restart releem-agent

Docker

Recreate the container with query optimization disabled:

docker rm -f releem-agent
docker run -d --name releem-agent \
  -e RELEEM_QUERY_OPTIMIZATION=false \
  ... \
  releem/releem-agent:[version]

For Docker Compose, set:

environment:
  RELEEM_QUERY_OPTIMIZATION: false

Then recreate the service:

docker compose up -d

AWS RDS

If the agent is managed by CloudFormation, update the releem-agent stack and set QueryOptimization to false.

If the agent runs on EC2, set query_optimization=false in /opt/releem/releem.conf and restart the agent:

systemctl restart releem-agent

GCP Cloud SQL

Set query_optimization=false in the agent configuration or recreate the Docker container with RELEEM_QUERY_OPTIMIZATION=false, then restart the agent.

Azure MySQL

Set query_optimization=false in the agent configuration or recreate the Docker container with RELEEM_QUERY_OPTIMIZATION=false, then restart the agent.

Windows

Set query_optimization=false in C:\ProgramData\ReleemAgent\releem.conf, then restart the Releem Agent Windows service.