2.2.8 Reload Tables

As of MySQL 8.3.0-u2, HeatWave can reload all tables.

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 option specification. 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 6.1, “HeatWave Autopilot Report Table”.

  • silent: Sends output to the heatwave_autopilot_report table only. See Section 6.1, “HeatWave 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 all tables with default options:

  mysql> CALL sys.heatwave_reload (NULL);

  mysql> CALL sys.heatwave_reload (JSON_OBJECT());

• Reload all user and system tables:

  mysql> CALL sys.heatwave_reload (JSON_OBJECT("only_user_loaded_tables",false));

• Reload user tables with the silent option:

  mysql> CALL sys.heatwave_reload (JSON_OBJECT("output","silent"));

• Reload all user and system tables with the silent option:

  mysql> CALL sys.heatwave_reload (JSON_OBJECT("only_user_loaded_tables",false,"output","silent"));