TDSQL-C for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Suggestions on Usage Specifications
- Kernel Features
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Security Features
- Stability Feature
- Analysis Engine Features
- Purchase Guide
- Value-Added Services Billing Overview
- Database Audit
- Audit Rule Template
- Serverless Service
- Serverless Introduction
- Serverless Resource Pack
- Configuration Change
- Operation Guide
- Database Connection
- Configuring Network Address
- Instance Management
- Configuration Adjustment
- Instance Mode Management
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Kernel Features
- Managing Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Console Account
- Database Account
- Configuring Custom Password Strength
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Utilization of Columnar Storage Indexes
- Read-Only Analysis Engine
- Feature Limits and Compatibility
- Description of Functions and Operators
- Read-Only Analysis Engine Management
- Data Loading
- Executing Queries
- Exclusive Features
- Performance Optimization
- Performance White Paper
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Performing Backup
- Managing Backup
- Rollback
- Restoring Data from Logical Backups
- Restoring Data Through the Console
- Restoring Data from Snapshot Backup
- Data Migration
- Parallel Query
- Setting Parallel Query
- Database Security and Encryption
- Access and Authorization
- Security Group Management
- TencentDB Security Group Management
- Monitoring and Alarms
- Monitoring
- Alarms
- Monitoring Metric Alarm
- Practical Tutorial
- Data Rollback
- Database/Table-Level Rollback
- Rolling back Entire Cluster
- White Paper
- Security White Paper
- Performance White Paper
- Troubleshooting
- Connection Issues
- API Documentation
- Making API Requests
- Instance APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
DocumentationTDSQL-C for MySQLOperation GuideRead-Only Analysis EngineData LoadingViewing the Data Loading Status
Viewing the Data Loading Status
Last updated: 2024-12-13 17:54:44
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 | Indicates the name of the database to which this object belongs. |
Object name | Indicates the name of this table. |
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
select * 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:
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No