Enabling Database Instances
To connect a database instance to OtterTune, you’ll first want to make sure you have the available credits in your account to do so. See our Pricing options for more information on increasing the amount of databases you can enable on your account.
When you have available credits, you’ll see the option to enable additional database instances on your Fleet Overview.
OtterTune needs some permissions to collect metrics from your database. Configure the following parameters in the DB parameter group. AWS does not allow you to modify parameters using the database command line, please follow the instructions to modify parameters in a DB parameter group.
MySQL
PostgreSQL
All versions of MySQL.
Knob | Value | Description |
innodb_monitor_enable | module_trx | Required for collection of transaction counters. OtterTune uses such metrics to calcuate throughput. Please see the MySQL documentation for more information. |
All versions of PostgreSQL.
Knob | Value | Description |
shared_preload_libraries | pg_stat_statements | Required for collection of query latency metrics. OtterTune uses such metrics to calculate percentile query latency (like P99 query latency). Please see the PostgreSQL documentation for more information. |
pg_stat_statements.track | TOP | Required for pg_stat_statements to track top statements. |
To calculate the percentile query latency (like P99 query latency) and use it as a target objective, you need to allow collecting query latency metrics from the target database.
MySQL
Postgres
- See this documentation to check whether Performance Insights is supported for your instance. If yes, please enable your Performance Insights to manage Performance Schema automatically. You don't need to reboot your instance.
- If Performance Insights is not supported, you can follow this instruction to set the required Performance Schema parameters yourself, and reboot your instance.
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
To get the full benefit of using OtterTune, you'll need to run the OtterTune agent on your hosts. It connects to your database and sends metrics back to OtterTune. See full instructions on Agent Setup here.
Last modified 13d ago