10.1.3 HEATWAVE_RELOAD

Reloads all tables. Available as of MySQL 8.4.0.

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. MySQL 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:

  • normal: The default. Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. See Section 5.8.8, “Autopilot Report Table”.

  • silent: Sends output to the heatwave_autopilot_report table only. See Section 5.8.8, “Autopilot Report Table”. The silent output type is useful if human-readable output is not required; when the output is consumed by a script, for example.

Syntax Examples

• 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 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.