6.2.3 Data Load Progress and Status Monitoring

• The time required to load a table into HeatWave depends on data size. You can monitor load progress by issuing the following query, which returns a percentage value indicating load progress.

  mysql> SELECT VARIABLE_VALUE
            FROM performance_schema.global_status
            WHERE VARIABLE_NAME = 'rapid_load_progress';
  +----------------+
  | VARIABLE_VALUE |
  +----------------+
  | 100.000000     |
  +----------------+

• To check the load status of tables in a particular schema:

  mysql> USE performance_schema;
  mysql> SELECT NAME, LOAD_STATUS 
            FROM rpd_tables,rpd_table_id 
            WHERE rpd_tables.ID = rpd_table_id.ID AND SCHEMA_NAME LIKE 'tpch';
  +------------------------------+---------------------+
  | NAME                         | LOAD_STATUS         |
  +------------------------------+---------------------+
  | tpch.supplier                | AVAIL_RPDGSTABSTATE |
  | tpch.partsupp                | AVAIL_RPDGSTABSTATE |
  | tpch.orders                  | AVAIL_RPDGSTABSTATE |
  | tpch.lineitem                | AVAIL_RPDGSTABSTATE |
  | tpch.customer                | AVAIL_RPDGSTABSTATE |
  | tpch.nation                  | AVAIL_RPDGSTABSTATE |
  | tpch.region                  | AVAIL_RPDGSTABSTATE |
  | tpch.part                    | AVAIL_RPDGSTABSTATE |
  +------------------------------+---------------------+

  For information about load statuses, see Section 6.4.8, “The rpd_tables Table”.

• To view the amount of data loaded in HeatWave for a table, in bytes:

  mysql> USE performance_schema;
  mysql> SELECT rpd_table_id.TABLE_NAME, rpd_tables.NROWS, 
            rpd_tables.LOAD_STATUS, rpd_tables.SIZE_BYTES 
            FROM rpd_table_id, rpd_tables
            WHERE rpd_table_id.ID = rpd_tables.ID 
            ORDER BY SIZE_BYTES;
  ------------+---------+---------------------+------------+
  | TABLE_NAME | NROWS   | LOAD_STATUS         | SIZE_BYTES |
  +------------+---------+---------------------+------------+
  | region     |       5 | AVAIL_RPDGSTABSTATE |    4194304 |
  | nation     |      25 | AVAIL_RPDGSTABSTATE |    8388608 |
  | part       |  200000 | AVAIL_RPDGSTABSTATE |   33554432 |
  | customer   |  150000 | AVAIL_RPDGSTABSTATE |   41943040 |
  | orders     | 1500000 | AVAIL_RPDGSTABSTATE |  226492416 |
  +------------+---------+---------------------+------------+

• To view the time that a table load operation completed:

  mysql> USE performance_schema;
  mysql> SELECT rpd_table_id.TABLE_NAME, rpd_tables.NROWS, 
            rpd_tables.LOAD_STATUS, rpd_tables.LOAD_END_TIMESTAMP 
            FROM rpd_table_id, rpd_tables
            WHERE rpd_table_id.ID = rpd_tables.ID;
  +------------+---------+---------------------+----------------------------+
  | TABLE_NAME | NROWS   | LOAD_STATUS         | LOAD_END_TIMESTAMP         |
  +------------+---------+---------------------+----------------------------+
  | region     |       5 | AVAIL_RPDGSTABSTATE | 2021-12-06 14:32:15.209825 |
  | part       |  200000 | AVAIL_RPDGSTABSTATE | 2021-12-06 14:32:07.594575 |
  | customer   |  150000 | AVAIL_RPDGSTABSTATE | 2021-12-06 14:31:57.210649 |
  | nation     |      25 | AVAIL_RPDGSTABSTATE | 2021-12-06 14:17:53.472208 |
  | orders     | 1500000 | AVAIL_RPDGSTABSTATE | 2021-12-06 14:24:45.809931 |
  +------------+---------+---------------------+----------------------------+

• To view the time that the last successful recovery took across all tables.

  mysql> SELECT variable_value
            FROM performance_schema.global_status 
            WHERE variable_name="rapid_recovery_time";
  +----------------+
  | variable_value |
  +----------------+
  | N/A            |
  +----------------+