2.5.3 Unloading Data Using Auto Unload

2.5.3.1 Auto Unload Syntax

2.5.3.2 Running Auto Unload

2.5.3.3 Auto Unload Command-Line Help

2.5.3.4 Auto Unload Examples

As of MySQL 9.1.0, Auto Parallel Load automatically loads frequently used InnoDB tables into HeatWave. If a manually loaded table might cause a memory conflict, Auto Unload unloads automatically loaded tables to free up memory.

Auto Unload facilitates the process of unloading data from HeatWave by automating many of the steps involved, including:

• Excluding schemas and tables that cannot be unloaded.

• Removes the secondary engine flag for tables that are to be unloaded.

• Unloading data from HeatWave.

Auto Unload, which can be run from any MySQL client or connector, is implemented as a stored procedure named heatwave_unload, which resides in the MySQL sys schema. Running Auto Unload involves issuing a CALL statement for the stored procedure, which takes schemas and options as arguments; for example, this statement unloads the tpch schema:

mysql> CALL sys.heatwave_unload(JSON_ARRAY("tpch"), NULL);