4.2.8 Reload Tables

As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine.

Before You Begin

• Complete the steps to load data using Auto Parallel Load or manually.

Reload Tables

• Reload tables with default routine option values:

  mysql> CALL sys.HEATWAVE_RELOAD(NULL);

  mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT());

• Reload all user-loaded and automatically-loaded tables:

  mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("only_user_loaded_tables",false));

• Reload all user-loaded tables with the output option set to silent:

  mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("output","silent"));

• Reload all user-loaded and automatically-loaded tables with the output option set to silent:

  mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("only_user_loaded_tables",false,"output","silent"));

To learn more about user-loaded and automatically-loaded tables, see Automatic Loading and Unloading of DB System Tables and Partitions.

What's Next

• Perform Transactional and Analytical Processing Using MySQL HeatWave.

• Learn how to use the Machine Learning capabilities of MySQL HeatWave.

• Learn how to Unload Data.