OtterTune's Database Overview shows the details about a particular database.
The Database Info panel provides basic system and hardware information for your database.
The entries in the Database Info panel are defined as follows:
The cloud vendor of the database instance.
The hardware category or name for your database instance. For Amazon RDS, this is the DB instance type of the database.
The number of virtual CPU cores available on the database instance.
The amount of memory available on the database instance.
Number of IOPS allocated to the database instance (Amazon RDS instances with Provisioned IOPS SSD storage only).
The top of the Database Overview displays the best configuration OtterTune has seen so far and the latest performance and status information for the database.
The database's best configuration is the configuration with the largest improvement of target objective value over the database's baseline (first) configuration. The Best Configuration panel on the left displays the following information:
The measured target objective for the database's best configuration. See Target Objective for more details.
The percentage improvement of target objective value of the best configuration over the baseline (first) configuration.
The name and status of the best configuration.
OtterTune is not able to determine your database's best configuration in some cases. See below for more details.
Your database's best configuration will be pending until OtterTune has tried 8 configurations. This is because OtterTune explores the configuration space for the first configurations and it's likely that after 8 configurations we'll have seen some improvement over the baseline. Note that the best configuration will remain pending if your database is in monitoring mode. Please use the Tuning Options panel to enable optimizing mode.
OtterTune can calculate the best configuration only if your settings meet all of the following criteria:
- 1.The tuning interval is at least 24 hours
- 2.The baseline (first) configuration has at least 24 hours of target objective data
- 3.The target objective is not throughput
(1) and (2) are in place because most of our customers have diurnal workload patterns and not capturing an entire cycle can lead to inaccurate performance estimates for configurations. (3) is in place because throughput changes mainly reflect workload changes instead of performance changes when the system is not saturated. To enable the best configuration feature, you can increase the tuning interval to at least 24 hours and select a target objective that is not throughput using the Tuning Options panel. If your first configuration is already set (configuration status is inactive) and does not meet criteria (2), please reach out to Support to re-establish the baseline.
The Current Status panel on the right displays the following information:
The measured target objective for the database's current (active) configuration. See Target Objective for more details.
The current connection and tuning status of the database. See Agent Status and Tuning Mode for more details.
How often OtterTune will install a new configuration when the tuning mode is set to "Optimizing". See Tuning Interval for more details.
The next panel in the Database Overview displays the Database Insights results. This panel shows a list of insights that OtterTune generates to provide deeper visibility into the performance and workload characteristics of your database.
The entries in the Database Insights panel are defined as follows:
Workload Classification Classify database workload based on the number of read and write rows. There are five categories of workload: read-only, read-heavy, write-heavy, write-only, balanced.
Find database peak time based on the throughput.
Disk Read/Write IOPS
Analyze disk read and write IOPS.
The next panel in the Database Overview displays the Database Health check results. Each entry shows the name, status, and details for a given check. Note that the details for failed checks also include suggestions to remedy them. The panel displays up to three Database Health checks. To access the complete list of checks, select See all in the panel or the Database Health tab at the top of the Database Overview page. See Database Health for more details.
The lower part of the Database Overview displays the configurations installed most recently on the database (up to four). Each card shows the name, performance, status, and creation time for a given configuration. See Database Configurations for more details.
You can deactivate OtterTune for a database from the Database Overview page. To do this, select Settings -> Deactivate OtterTune and follow the prompt. An example is shown in the screenshot above (the Settings menu is located on the lower lefthand corner of the page).