OtterTune keeps track of each configuration that it installs on the database. The Configuration page allows you to view the knob settings for each configuration and the measured performance.
To access the Configuration panel, click the Configurations tab on the Database Overview page.
In the middle of the page there will be a list of the configurations that OtterTune has generated for this database. Each configuration entry includes the measured tuning objective (e.g., throughput), the timestamp of when it was created, and whether it is Active or Inactive.
Clicking on an entry will then load the details about that configuration.
The configuration details panel shows the last tuning objective measurement (e.g., throughput). It also includes the timestamps of when the configuration was created and when OtterTune last received data from the agent about the database from when this configuration is active.
Below these details is the list of knobs and their values for this configuration. The knobs that OtterTune modified in this configuration include a Tuning checkmark.
You can compare any two application configuration versions. This functionality highlights the differences between the changed configuration values in the two versions and helps Developers to understand how their configuration data has changed over time.
To compare two configurations:
- 1.Select the first configuration from the list to display its configuration details.
- 2.Select Compare with and choose the second configuration from the dropdown list. As shown in the screenshot below, knobs with different settings are highlighted in blue.
Inactive configurations have an APPLY NOW button that can be used to immediately override the current (active) configuration with one that was applied to the database previously.
The APPLY NOW button performs the following actions:
There are several scenarios where this feature is useful. Foremost is that it can be used to quickly override the current configuration if it’s believed to be causing serious performance issues.
As shown below, the APPLY NOW button is located in the upper right corner of the configuration details.
After selecting APPLY NOW, a confirmation box will appear. Select Proceed if you still wish to apply the configuration or Cancel otherwise.
After the configuration has been applied successfully, the status will change to
Monitoringand there will be a new configuration under Last configurations.