HeatWave User Guide  /  ...  /  HEATWAVE_RELOAD

10.1.3 HEATWAVE_RELOAD

Reloads all tables. Available as of MySQL 8.4.0.

Press CTRL+C to copy
mysql> CALL sys.HEATWAVE_RELOAD([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ["only_user_loaded_tables",{true|false}] ["output",{"normal"|"silent"}] } }

Use key-value pairs in JSON format to specify options. HeatWave uses the default setting if there is no defined option. Use NULL to specify no arguments.

The options include:

  • only_user_loaded_tables: Enabled by default. The procedure only reloads user tables. If false, the procedure reloads user and system tables.

  • output: Defines where to send the output. Permitted values are:

Syntax Examples

  • Reload tables with default routine option values:

    Press CTRL+C to copy
    mysql> CALL sys.HEATWAVE_RELOAD(NULL);
    Press CTRL+C to copy
    mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT());
  • Reload all user-loaded and automatically-loaded tables:

    Press CTRL+C to copy
    mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("only_user_loaded_tables",false));
  • Reload user-loaded tables with the output option set to silent:

    Press CTRL+C to copy
    mysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("output","silent"));
  • Reload all user-loaded and automatically-loaded tables with the output option set to silent:

    Press CTRL+C to copy
    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.