16.3.1.1 Auto Shape Prediction Data

The Autopilot Shape Advisor tab shows data for the last seven days and contains the following information:

  • Summary

    This summarizes the basic information of your DB system and HeatWave cluster including their names, their states, and the shape and size of the cluster.

  • Recommendation

    This section contains the MySQL Shape Prediction and the recommended Action. You need to select a time period in the drop-down list on the right, upon which the prediction will be based. The choices in the drop-down list include:

    • Past 12 hours
    • Past day
    • Past 3 days
    • Past week

    The time period can also be chosen by using the horizontal slider controls at the bottom of the page.

    MySQL Shape Prediction

    • Current

      The current shape size, with Shape Name, Memory Size, CPU Count, and Buffer Pool Size.

    • Recommended

      The recommended shape size, with Shape Name, Memory Size, CPU Count, and Buffer Pool Size.

    Action

    The prediction is based on the selected time period, and there are five possible cases:

    • Upsize: Move the DB System to a larger MySQL shape.

    • Downsize: Move the DB System to a smaller MySQL shape.

    • No Change: No need to change the MySQL shape.

    • Not Enough Data: There is not enough workload activity, or Auto Shape Prediction cannot make a prediction.

    • Prediction Data Not Available: Auto Shape Prediction is disabled, or it is enabled but has not produced the first prediction, or the HeatWave Console data has not been refreshed within the last 5 minutes.

    After the recommendation, Steps to take provides the instructions to follow for adopting the recommended shape.

  • Shape Prediction Insights

    This sections contains the following information:

    • Average Statistics

      • Buffer Pool

        A graph that shows the Average Buffer Pool Usage and Current Buffer Pool Size.

      • Buffer Pool Hit Rate

        A percentage value calculated for the selected time period.

      • CPU Utilization

        Average CPU utilization calculated for the selected time period.

    • Recent Statistics

      Use the left and right slider controls to adjust the time period for these time graphs:

      • Buffer Pool

        A detailed graph that shows the Buffer Pool Size and Recommended Buffer Pool Size for the selected time period.

      • CPU Count

        A detailed graph that shows the CPU count predictions for downsize cases for the selected time period.

      • Buffer Pool Hit Rate

        A detailed graph that shows the Buffer Pool Hit Rate for the selected time period.

      • CPU Utilization

        A detailed graph that shows the history of CPU Utilization for the selected time period.

      Workload markers on the time series graphs indicate recent activities:

      • Green markers: The workload is running and stable. This allows good predictions.

      • Orange markers: The workload is running, but is not stable. This makes predictions difficult.

      • No markers: No recent activities, and no predictions.