This section describes the Advisor utility, which provides the following optimization capabilities:
Advisor Auto Encoding
Recommends string column encodings that minimize the required cluster size and improve query performance. See Section 2.8.2, “Auto Encoding”.
Advisor Auto Data Placement
Recommends data placement keys for optimizing
GROUP BYquery performance. See Section 2.8.3, “Auto Data Placement”.
Advisor Query Insights
Provides runtime information for successfully executed queries and runtime estimates for
EXPLAINqueries, queries cancelled with
Ctrl+C, and queries that fail due to out of memory errors. Runtime data is useful for query optimization, troubleshooting, and estimating the cost of running a particular query or workload. See Section 2.8.4, “Query Insights”.
Recommends tables to unload, that will reduce HeatWave memory usage. The recommendations are based upon when the tables were last queried.
Advisor is workload-aware and provides recommendations based on machine learning models, data analysis, and HeatWave query history. Advisor analyzes the last 1000 successfully executed HeatWave queries.
Advisor is implemented as a stored procedure named
heatwave_advisor, which resides in the MySQL
sys schema. Running Advisor
involves issuing a
for the stored procedure with optional arguments.
To run Advisor, the HeatWave Cluster must be active, and the user must have the following MySQL privileges: