tencent cloud

TDSQL Boundless

DokumentasiTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMATDSTORE_TIERING_COLD_RG_JOB_PROGRESS

TDSTORE_TIERING_COLD_RG_JOB_PROGRESS

Download
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-07-13 16:37:17

Function

INFORMATION_SCHEMA.TDSTORE_TIERING_COLD_RG_JOB_PROGRESS is used to view the execution progress of hot-to-cold data migration tasks for RGs on TDStore nodes across the cluster under the tiered storage mode. It covers both ongoing tasks and completed historical tasks.
This view only displays the progress of cold migration tasks that move existing data from the local data DB to the remote COS durable DB. It does not include the incremental upload process for cold RGs during runtime. A task goes through several stages during execution. The percentage progress is shown only during the SST file upload stage, while other stages display only the current stage name. The stages supported by a task are as follows:
Validating: The validation stage.
DrainingTransactions: The transaction draining stage.
Preparing: The preparation stage.
ExportingSnapshot: The snapshot export stage.
Uploading: The SST upload stage, where the upload percentage is displayed.
Committing: The commit stage.
Done: The task is completed.

Field Description

Field Name
Type
Description
NODE_NAME
VARCHAR(64)
The name of the TDStore node where the task resides.
JOB_ID
BIGINT UNSIGNED
The ID of the cold data migration job.
REP_GROUP_ID
BIGINT UNSIGNED
The ID of the Replication Group that is undergoing cold data migration.
STAGE
VARCHAR(64)
The current stage of the job. Valid values: Validating, DrainingTransactions, Preparing, ExportingSnapshot, Uploading, Committing, Done.
UPLOADED_FILE_NUM
BIGINT
The number of uploaded SST files. It is meaningful only during and after the Uploading stage, and is NULL in other stages.
TOTAL_FILE_NUM
BIGINT
The total number of SST files that need to be uploaded for this job. It is meaningful only during and after the Uploading stage, and is NULL in other stages.
UPLOADED_FILE_SIZE
BIGINT
The number of uploaded bytes. It is meaningful only during and after the Uploading stage, and is NULL in other stages.
TOTAL_FILE_SIZE
BIGINT
The total number of bytes that need to be uploaded for this job. It is meaningful only during and after the Uploading stage, and is NULL in other stages.
PROGRESS_PCT
VARCHAR
The upload progress percentage, calculated based on bytes. It is meaningful only during and after the Uploading stage, and is NULL in other stages.
START_TIME
VARCHAR(64)
The start time of the job, in the format YYYY-MM-DD hh:mm:ss.
END_TIME
VARCHAR(64)
The end time of the job, in the format YYYY-MM-DD hh:mm:ss. It is NULL while the job is in progress.
ELAPSED_TIME_MS
BIGINT UNSIGNED
The elapsed time of the job, in milliseconds. While the job is in progress, it is the cumulative time from the start to the current moment. After the job is completed, it is the total time consumed.
ERR_MSG
VARCHAR
The error information generated during job execution. It is NULL when the job runs normally.
DETAIL_COST_INFO
TEXT
Detailed information about the time consumed in each stage of the job, facilitating performance analysis.

Examples

tdsql > SELECT * FROM information_schema.TDSTORE_TIERING_COLD_RG_JOB_PROGRESS\\G
*************************** 1. row ***************************
         NODE_NAME: tdstore-node-1
            JOB_ID: 1001
      REP_GROUP_ID: 200
             STAGE: Done
 UPLOADED_FILE_NUM: 12
    TOTAL_FILE_NUM: 12
UPLOADED_FILE_SIZE: 134217728
   TOTAL_FILE_SIZE: 134217728
      PROGRESS_PCT: 100.00%
        START_TIME: 2026-06-05 10:00:00
          END_TIME: 2026-06-05 10:05:23
   ELAPSED_TIME_MS: 323000
           ERR_MSG: NULL
  DETAIL_COST_INFO: Validating:5ms,DrainingTransactions:120ms,Preparing:30ms,ExportingSnapshot:200ms,Uploading:322000ms,Committing:645ms
*************************** 2. row ***************************
         NODE_NAME: tdstore-node-2
            JOB_ID: 1002
      REP_GROUP_ID: 201
             STAGE: Uploading
 UPLOADED_FILE_NUM: 6
    TOTAL_FILE_NUM: 10
UPLOADED_FILE_SIZE: 67108864
   TOTAL_FILE_SIZE: 104857600
      PROGRESS_PCT: 64.00%
        START_TIME: 2026-06-05 10:08:00
          END_TIME: NULL
   ELAPSED_TIME_MS: 45000
           ERR_MSG: NULL
  DETAIL_COST_INFO: Validating:4ms,DrainingTransactions:115ms,Preparing:28ms,ExportingSnapshot:180ms,Uploading:44673ms
2 rows in set (0.01 sec)
Topik sebelumnya: TDSTORE_SST_PROPSTopik selanjutnya: TDSTORE_TIERED_STORAGE_USAGE

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan