Chapter 5 Accelerate Query Processing

Table of Contents

5.1 About MySQL HeatWave

5.2 Supported SQL Modes

5.3 Supported Functions and Operators

5.3.1 Aggregate Functions

5.3.2 Arithmetic Operators

5.3.3 Cast Functions and Operators

5.3.4 Comparison Functions and Operators

5.3.5 Control Flow Functions and Operators

5.3.6 Data Masking and De-Identification Functions

5.3.7 Encryption and Compression Functions

5.3.8 JSON Functions

5.3.9 Logical Operators

5.3.10 Mathematical Functions

5.3.11 String Functions and Operators

5.3.12 Temporal Functions

5.3.13 Vector Functions

5.3.14 Window Functions

5.3.15 Miscellaneous Functions

5.4 Run Queries

5.4.1 Requirements for Running Queries

5.4.2 SELECT Statement Clauses for MySQL HeatWave

5.4.3 Explain Query and Check Execution Time

5.4.4 CREATE TABLE ... SELECT Statements

5.4.5 Create MySQL HeatWave Temporary Tables

5.4.6 INSERT ... SELECT Statements

5.4.7 Query Views

5.4.8 View Query Runtimes and Estimates

5.4.9 Diagnose Query Offload

5.4.10 Auto Scheduling

5.4.11 Auto Query Plan Improvement

5.4.12 Dynamic Query Offload

5.5 Modify Tables

5.6 Analyze Tables

5.7 Run Tasks Asynchronously

5.8 Optimize Workloads for OLAP

5.8.1 String Column Encoding

5.8.2 Data Placement Keys

5.8.3 About MySQL HeatWave Autopilot Advisor

5.8.4 Auto Encoding

5.8.5 Auto Data Placement

5.8.6 Auto Query Time Estimation

5.8.7 Unload Advisor

5.8.8 Autopilot Report Table

5.8.9 Advisor Report Table

5.9 Optimize Workloads for OLTP

5.9.1 Autopilot Indexing

5.10 MySQL HeatWave Monitoring

5.10.1 Query Execution Monitoring

5.10.2 Query History and Statistics Monitoring

5.10.3 Scanned Data Monitoring