Auto Shape Prediction Data

Auto Shape Prediction data shows data for the last seven days and contains the following information:

  • Time Periods

    • Selected

      The two dates selected in Buffer Pool Insights.

    • Available

      Auto Shape Prediction data is available between these two dates a week apart.

  • MySQL Shape Prediction

    This uses the Selected dates.

    • Current

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

    • Recommended

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

  • Recommended Action

    This uses the Selected dates, and has five possible recommendations:

    • 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 MySQL HeatWave Console data has not been refreshed within the last 5 minutes.

    Instructions to follow to adopt the recommended size.

  • Buffer Pool Insights

    • Average Statistics

      • Buffer Pool

        A graph that shows Average Buffer Pool Usage and Current Buffer Pool Size. This uses the Selected dates.

      • Buffer Pool Hit Rate

        A percentage value calculated between the Selected dates.

    • Recent Statistics

      Use the left and right slider controls on one of the two time series graphs to adjust the Selected dates.

      • Buffer Pool

        A detailed graph that shows Buffer Pool Size, Buffer Pool Usage, and Recommended Buffer Pool Size. The graph uses the Selected dates.

      • Buffer Pool Hit Rate

        A detailed graph that shows the Buffer Pool Hit Rate Between the Selected dates.

      • Workload markers on the two time series graphs. These markers indicate recent activity:

        • Green markers: The workload is running and stable. Good predictions.

        • Orange markers: The workload is running, but it is not stable. Difficult to predict.

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