Viewing the Data Loading Status
Overview
Loading data into the read-only analysis engine involves two different phases. The first is a full data loading phase and the second is a real-time data loading phase. When data is loaded into the read-only analysis engine, data queries can be performed only after the data object is built. You can use the following methods to view the status of the data table loading.
Prerequisites
You have prepared a cluster in the provisioned resource instance mode. See Creating Cluster.
The cluster is in the running status.
You have already performed loading data into the read-only analysis engine.
Directions
Method 1: Viewing the Data Loading Status in the Console
1. Log in to the TDSQL-C MySQL console and click the target cluster in the cluster list on the left to enter the cluster management page.
2. On the cluster details page, locate the read-only analysis engine instance for which you need to modify the loaded objects, and then click Details to enter the details page of the read-only analysis engine instance.
3. On the details page of the read-only analysis engine instance, you can view the object information including the data loading status.
Parameter | Description |
Database name | Represents the database name to which this object belongs. It supports filtering by database name. Note: If there are many databases loaded into the read-only analysis engine, filtering by database may cause the console loading time to become too long. |
Object name | Represents the table name loaded into the read-only analysis engine. Views can also be loaded into the read-only analysis engine, but view information will not be displayed here. To view the views, use MySQL commands. When there are many objects loaded, you can search in the console using keywords of the object name. |
Status | The statuses include data loading, real-time increment, and synchronization exception. |
Data loading status | If the object is in the process of data loading, the loading progress of the current table is shown in the data loading status. |
Incremental phase latency | If the object is in the process of real-time increment, the synchronization delay information of this object is shown. |
Other information | If an exception occurs in data loading, the relevant information about the loading exception of this object is shown in other information. |
Method 2: Viewing the Data Loading Status through SQL Statements
show replication tables;orselect * from information_schema.libra_table_status;
In the read-only analysis engine, you can view the status of all data objects currently in the loading process by executing this command. It supports filtering with a WHERE condition.
The displayed field information is as shown in the figure below:
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback