10.1.3 HEATWAVE

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.