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.