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.
-
-
-