8.1 Loading or Unloading Data into HeatWave

Use MySQL HeatWave Console to load data into or unload data from a HeatWave Cluster.

This task requires the following MySQL privileges:

• The PROCESS privilege.
• The EXECUTE privilege on the sys schema.
• The SELECT privilege on the Performance Schema.

The time required to load data from the DB System into the HeatWave Cluster depends on the data size.

Note:

HeatWave Cluster data can also be managed using SQL or the Auto Parallel Load interface from a MySQL client. See Loading Data, in the MySQL HeatWave User Guide.

To load data, do the following:

1. Connect to a DB System that has a HeatWave Cluster. See Connecting from the Console.
2. Click the Manage Data in HeatWave tab. You can view the following information about schemas and tables:
   • Name: The name of the schema or table.
   • Source: The source of the schema or table. For example, InnoDB.
   • Memory Size Estimate (GiB): An estimate of the memory required on the HeatWave Cluster for the schema or table.
   • Loaded: The number of tables loaded into HeatWave. You can click the Refresh icon to refresh the load status.
   • Rows Estimate: The estimated number of rows in the table.
   • String Column Encoding: The number of columns to be encoded as VARLEN (variable-length) columns, expressed as a fraction of the total number of table columns. For information about HeatWave string column encoding, see Encoding String Columns, in the HeatWave User Guide.
   • Predicted Load Time (s): The predicted load time in seconds.
3. Select the schemas and tables that you want to load by clicking the check box present in front of the schema or table name. If you select a schema, all the tables in the schema are selected. Expanding a schema using the drop-down control displays the table in the schema. The Load Status column provides the load status as a percentage value.
4. After you have selected the tables you want to load or unload, click Load or Unload.

   If loading data, the MySQL Auto Parallel Load tables into HeatWave dialog appears, providing a summary of the load operation to be executed. The following information is shown:

   • DB System: The DB System name
   • Estimated load size: The estimated size of the data to be loaded
   • Estimated load time: The estimated time required to load the data
   • Selected schemas and tables: The selected schemas and tables to be loaded
     • Name: Name of the schema or table
     • Memory Size Estimate (GiB): The memory size estimate for the schema or table on the HeatWave Cluster
   • Estimated total memory footprint: A pie chart showing the estimated percentage of HeatWave Cluster memory required for each table
   • Estimated load times (seconds): A pie chart showing estimated load times for each table

   If unloading data, the MySQL Auto Parallel Unload tables from HeatWave dialog appears, providing a summary of the unload operation to be executed. The following information is shown:

   • DB System: The name of the DB System

   • Estimated unload size: The estimated size of the data to be unloaded

   • Selected schemas and tables: The selected schema and tables to be unloaded

     • Name: Name of the schema or table

     • Memory Size Estimate (GiB): The memory size estimate for the schema or table on the HeatWave Cluster

   • Estimated memory foot print (GiB): The estimated HeatWave Cluster memory footprint showing occupied memory, current free memory, and additional available free memory after the unload operation

5. Click Confirm Load or Confirm Unload to start the load or unload operation.

The Cluster Memory Snapshot shows the amount of HeatWave Cluster memory used.

Parent topic: Manage Data in HeatWave with Workspaces