Reloads all tables. Available as of MySQL 8.4.0.
Press CTRL+C to copymysql> 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. Iffalse
, 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 tostdout
and to theheatwave_autopilot_report
table. See Section 5.8.8, “Autopilot Report Table”.silent
: Sends output to theheatwave_autopilot_report
table only. See Section 5.8.8, “Autopilot Report Table”. Thesilent
output type is useful if human-readable output is not required; when the output is consumed by a script, for example.
-
Reload tables with default routine option values:
Press CTRL+C to copymysql> CALL sys.HEATWAVE_RELOAD(NULL);
Press CTRL+C to copymysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT());
-
Reload all user-loaded and automatically-loaded tables:
Press CTRL+C to copymysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("only_user_loaded_tables",false));
-
Reload user-loaded tables with the
output
option set tosilent
:Press CTRL+C to copymysql> CALL sys.HEATWAVE_RELOAD(JSON_OBJECT("output","silent"));
-
Reload all user-loaded and automatically-loaded tables with the
output
option set tosilent
:Press CTRL+C to copymysql> 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.