Looking to install additional performance sensors?
If you're looking to get ongoing insights for more database instances, please consider upgrading to a higher tier which supports more performance sensors.
Create an account or login
Start optimizing in 60 seconds.
No credit card is required.
Installing EverSQL Performance Sensor
EverSQL performance sensor will track your databases slow query logs on an on-going basis and generate personalized optimization insights for you automatically. You can use the performance sensor with MySQL, MariaDB, Percona and PostgreSQL databases.
Step 1: Enable the slow query log
The performance sensor requires slow query logs to be enabled.
Click here for instructions if you don't have them enabled.
To enable slow query logs, please add the following parameters to MySQL's configuration file. By default, the configuration file is at /etc/my.cnf, or at /etc/mysql/my.cnf.
[mysqld]
slow_query_log=1
long_query_time=1 # Logs queries longer than 1 second
log_output=FILE
slow_query_log_file=/var/lib/mysql/slow.log
To apply the changes, please restart the database (requires short downtime):
sudo /etc/init.d/mysql restart
Step 2: Install the performance sensor
To install the performance sensor, please run the following commands.
If your slow query log file is not at /var/lib/mysql/slow.log, please modify the path below.
curl -L https://www.eversql.com/install/install_eversql_sensor.py > install_eversql_sensor.py
sudo python install_eversql_sensor.py PLATFORM_TYPE /var/lib/mysql/slow.log
To install the performance sensor, please run the following commands.
Please make sure to replace SLOW_LOG_DIR with your slow query log directory path.
curl -L https://www.eversql.com/install/install_eversql_sensor_postgresql.py > install_eversql_sensor.py
sudo python install_eversql_sensor.py PLATFORM_TYPE SLOW_LOG_DIR
Once installed, the sensor will start sending identified slow queries within up to 30 minutes.
EverSQL performance sensor will track your databases slow query logs on an on-going basis and generate personalized optimization insights for you automatically. You can find more information here.
You can use the sensor with Amazon RDS MySQL / MariaDB and Aurora MySQL / PostgreSQL databases.
Step 1: Enable the slow query log
To enable slow query logs on your database instances, please follow the 'Enable slow query log' section here.
Once you're done editing the parameter group and assigning it to your instance, please make sure you restart the database to apply the changes (may require downtime).
Step 2: Install the performance sensor
You can now deploy the performance sensor from the Amazon Serverless Application repository.
Your personal API key (required as part of the installation):
Once installed, the sensor will start sending identified slow queries within up to 30 minutes.
EverSQL performance sensor will track your databases slow query logs on an on-going basis and generate personalized optimization insights for you automatically.
You can use the performance sensor with Cloud SQL MySQL / Cloud SQL PostgreSQL databases.
Step 1: Enable the slow query log
To enable slow query logs on your Cloud SQL instances and redirect them to a Cloud Storage Bucket, please follow the instructions here.
Once you're done editing the parameter group and assigning it to your instance, please make sure you restart the database to apply the changes (may require downtime).
Step 2: Install the performance sensor (Beta)
To install the performance sensor, please run the following commands Google Cloud Shell CLI.
Please make sure to configure the following arguments before executing them:
* GCP_FUNCTION_NAME: Name the sensor (alphanumeric and dashes allowed).
* GCP_REGION: The region where your Cloud SQL instance is located (example: us-central1).
* GCP_PROJECT_ID: Your GCP project ID.
* GCP_BUCKET_NAME: The name of the bucket you created in step #1 above.
* SERVER_NAME: This is how this Cloud SQL instance will be named on EverSQL.
curl -sSL -o eversql_gcp_sensor_installation.zip https://www.eversql.com/install/eversql_gcp_sensor_installation.zip
unzip eversql_gcp_sensor_installation.zip -d eversql_gcp_sensor_installation/
gcloud functions deploy GCP_FUNCTION_NAME --project=GCP_PROJECT_ID --region=GCP_REGION --trigger-resource=GCP_BUCKET_NAME --set-env-vars="server_name=SERVER_NAME,api_key=" --runtime=python39 --memory=1024MB --timeout=540s --entry-point=main_func --source=eversql_gcp_sensor_installation --trigger-event=google.storage.object.finalize
Once installed, the sensor will start sending identified slow queries within up to 1 hour.
EverSQL performance sensor will track your databases slow query logs on an on-going basis and generate personalized optimization insights for you automatically. You can use the performance sensor with MySQL, MariaDB, Percona and PostgreSQL databases.
Step 1: Enable the slow query log
The performance sensor requires slow query logs to be enabled.
Click here for instructions if you don't have them enabled.
To enable slow query logs, please add the following parameters to MySQL's configuration file. By default, the configuration file is at %PROGRAMDATA%\MySQL\MySQL Server
[mysqld]
slow_query_log=1
long_query_time=1 # Logs queries longer than 1 second
log_output=FILE
slow_query_log_file=/var/lib/mysql/slow.log
To apply the changes, please restart the database (requires short downtime):
Step 2: Install the performance sensor
To install the performance sensor, please download and install the latest version of td-agent.
Then, please navigate to C:/opt/td-agent/etc/td-agent, open td-agent.conf, and copy the configuration section below to the file.
Please make sure to adjust the custom configuration parts below, marked in bold.
<match eversql.**>
@type http
endpoint https://actions.eversql.com/upload?apikey=API_KEY
http_method post
content_type text/plain
open_timeout 2
<buffer>
flush_interval 60s
chunk_limit_size 3MB
</buffer>
</match>
<source>
@type tail
@id input_tail
path SLOW_QUERY_LOG_FILE_PATH
pos_file TMP_DIRECTORY_PATH/slow.log.pos
tag eversql.log
read_from_head true
<parse>
@type none
message_key slowlog
</parse>
</source>
<filter eversql.**>
@type record_transformer
<record>
host_param "SERVER_NAME"
</record>
</filter>
Next, please restart the service named Fluentd Windows Service.
Once installed, the sensor will start sending identified slow queries within up to 30 minutes.
Performance Sensor - Predict performance bottlenecks, prevent downtime.
Non intrusive AI-powered solution, used to predict performance issues and generate optimization insights.
Optimization insights for slow queries.
AI-powered bottlenecks predictions.
No credentials or data access required.
Lightweight agent with no overhead.
Highly secured, verified by Amazon AWS
| Status | Server | Last received data on (UTC) | Days Active |
|---|