MySQL HeatWave 用户指南  / 第 2 章热浪  / 2.2 加载数据  /  2.2.5 查看负载状态

2.2.5 查看负载状态

您可以通过查询 LOAD_STATUSHeatWave Performance Schema 表中的数据来检查表是否已加载。例如:

mysql> USE performance_schema;
mysql> SELECT NAME, LOAD_STATUS FROM rpd_tables,rpd_table_id
       WHERE rpd_tables.ID = rpd_table_id.ID;
+------------------------------+---------------------+
| 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 |
+------------------------------+---------------------+

AVAIL_RPDGSTABSTATE状态指示表已加载 。有关加载状态的信息,请参阅第 5.4.8 节,“rpd_tables 表”