2.5.4 Unload All Tables

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

mysql> CALL sys.heatwave_unload_all ([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 unloads user tables. If false, the procedure unloads 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

• Unload all tables with default options:

  mysql> CALL sys.heatwave_unload_all (NULL);

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

• Unload all user and system tables:

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

• Unload user tables with the silent option:

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

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

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