Documentation Home
HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 2.0Mb
PDF (A4) - 2.0Mb


2.2.8 Reload Tables

HeatWave MySQL 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 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:

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"));