This page contains troubleshooting information for common issues we see when setting up and running OtterTune.
OtterTune uses the transaction counters from MySQL to calculate the throughput. To collect them, you need to add
module_trxto the list of modules specified by the
innodb_monitor_enableknob. After updating this knob, you should start seeing throughput measurements after a few minutes. Please see the documentation for more information.
- 2.Please make sure you configure the database correctly. Postgres requires loading the module pg_stat_statements, and MySQL requires enabling Performance Schema (you need to enable Performance Insights if it's available).
- 4.(Postgres only) Please make sure the installed version of pg_stat_statements is not lower than the default version. You can check it by running this query in your target database:SELECT*FROMpg_available_extensionsWHEREname = 'pg_stat_statements'ANDinstalled_version is not null;If
default_version, please run this command to update it:ALTER EXTENSION pg_stat_statements UPDATE;
- 5.(Postgres only) Please make sure
ALL)in the AWS parameter group of your RDS instance.
Several of OtterTune's features need to have your Amazon RDS Performance Insights enabled. For example, it must be enabled for OtterTune to collect query latency data that is used to compute the P99 query latency as a target objective for MySQL databases.
Firstly, you should check whether Performance Insights is available for your instance type and engine version. You can refer to this AWS documentation for Amazon RDS and this documentation for Amazon Aurora. The supported versions are as follows.
- 8.0.17 and higher 8 versions
- 5.7.22 and higher 5.7 versions
- 5.6.41 and higher 5.6 versions
（micro and small instance types are not supported)
versions 14, 13, 12, 11, and 10.
- 3.0 and higher 3 versions (compatible with MySQL 8.0)
- 2.04.2 and higher 2 versions (compatible with MySQL 5.7)
- 1.17.3 and higher 1 versions (compatible with MySQL 5.6)
(db.t2 and db.t3 instance types are not supported)
Secondly, you can follow this documentation to enable Performance Insights if it's available. Note that you don't need to reboot your instance to enable it.
- 2.Look for an OtterTune Agent stack. If CloudFormation was able to create the stack successfully the status will be
- 3.If something has gone wrong, select the stack and click on the
eventstab to see more details. Fixing the stack will require you to delete the existing stack and then restart the Agent creation process on the OtterTune website. Select the database you are connecting, go to
View Agent Setup info.
- 4.If the stack was created successfully but you are still seeing issues, navigate to the ECS Cluster AWS Console. Select the OtterTune agent cluster, select the OtterTune agent service, and select logs to see Agent output. If you would like help interpreting any failures there please reach out to Support.
OtterTune is not able to determine your database's best configuration in some cases. Please see the documentation for more information.
To enable index health, please make sure:
- 1.the agent version is >= 0.3.10
- 2.(MySQL only) the database user used to connect the database has the following permissions:
GRANT SELECT ON mysql.innodb_index_stats TO 'ottertune';
GRANT SELECT ON performance_schema.table_io_waits_summary_by_index_usage TO 'ottertune';
Last modified 30d ago