2.2.3.7 The Auto Parallel Load Report Table

MySQL 8.0.32 deprecates the heatwave_load_report table, and replaces it with the heatwave_autopilot_report table in the sys schema. A future release will remove it. See Section 2.7.9, “Autopilot Report Table”.

When MySQL runs Auto Parallel Load, it sends output including execution logs and a generated load script to the heatwave_load_report table in the sys schema.

The heatwave_load_report table is a temporary table. It contains data from the last execution of Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server is shut down.

Auto Parallel Load Report Table Query Examples

Query the heatwave_load_report table after MySQL runs Auto Parallel Load, as in the following examples:

• View error information in case Auto Parallel Load stops unexpectedly:

  mysql> SELECT log FROM sys.heatwave_load_report WHERE type="error";

• View warnings to find out why tables cannot be loaded:

  mysql> SELECT log FROM sys.heatwave_load_report WHERE type="warn";

• View the generated load script to see commands that would be executed by Auto Parallel Load in normal mode:

  mysql> SELECT log->>"$.sql" AS "Load Script"
            FROM sys.heatwave_load_report 
            WHERE type = "sql" ORDER BY id;

• View the number of load commands generated:

  mysql> SELECT Count(*) AS "Total Load Commands Generated"
            FROM sys.heatwave_load_report 
            WHERE type = "sql" ORDER BY id;

• View load script data for a particular table:

  mysql> SELECT log->>"$.sql"
            FROM sys.heatwave_load_report 
            WHERE type="sql" AND log->>"$.schema_name" = "db0" AND log->>"$.table_name" = "tbl" 
            ORDER BY id;

• Concatenate Auto Parallel Load generated DDL statements into a single string to copy and paste for execution. The group_concat_max_len variable sets the result length in bytes for the GROUP_CONCAT() function to accommodate a potentially long string. (The default group_concat_max_len setting is 1024 bytes.)

  mysql> SET SESSION group_concat_max_len = 1000000;
  mysql> SELECT GROUP_CONCAT(log->>"$.sql" SEPARATOR ' ')
            FROM sys.heatwave_load_report 
            WHERE type = "sql" ORDER BY id;