-
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 7.3.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 | +----------------+