Table of Contents
This section describes the Advisor utility, which provides the following optimization capabilities:
Recommends string column encodings for improving query performance and reducing the amount of memory required on HeatWave nodes. See Section 8.1, “Auto Encoding”.
Auto Data Placement
Recommends data placement keys for optimizing
GROUP BYquery performance. See Section 8.2, “Auto Data Placement”.
Provides runtimes for successfully executed queries and runtime estimates for
EXPLAINqueries, queries cancelled using
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 8.3, “Query Insights”.
Advisor is workload-aware and provides recommendations based on machine learning models, data analysis, and HeatWave query history. Advisor analyzes the last 200 successfully executed HeatWave queries.
Advisor is implemented as a stored procedure named
heatwave_advisor, which resides in the MySQL
sys schema. Running Advisor involves
CALL statement for the
stored procedure with optional arguments.
CALL sys.heatwave_advisor (options);
Issue the following statement to view Advisor command-line help:
Advisor can be run from any MySQL client or connector.