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(keyvalue[, keyvalue]...)|NULL}
keyvalue:
{
  "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.