INFORMATION_SCHEMA.DDL_JOB_STAGE_INFO view to display runtime information for each executing DDL job, including time consumption across various stages and RPC interactions. This enables users, DBAs, and kernel developers to pinpoint the current execution position when a DDL operation gets stuck (without having to check the DDL operation logs specifically).SELECT * FROM information_schema.DDL_JOB_STAGE_INFO ORDER BY ddl_job_id\\G/*#all_nodes */ SELECT * FROM information_schema.DDL_JOB_STAGE_INFO ORDER BY ddl_job_id\\GField Name | Type | Description |
DDL_JOB_ID | int unsigned | id of the currently executing DDL job. |
CURRENT_STAGE_TYPE | varchar(64) | NORMAL: indicates that the logic of the DDL foreground thread is being executed. RECOVERY: indicates that the logic of the DDL background thread is being executed (such as asynchronous DROP Table operations). |
CURRENT_STAGE_NAME | varchar(64) | Indicates which function the current DDL logic is executing in. |
CURRENT_STAGE_SOURCE | varchar(64) | Indicates the function file name and line number of code for the current DDL execution. |
HISTORY_STAGE_INFOS | varchar(4096) | Indicates the historical stage information of the current DDL execution, typically starting from START_DDL_JOB through END_DDL_JOB. |
CURRENT_SQL_QUERY | varchar(2048) | Indicates the SQL being executed for the current DDL. |
DDL_START_TIME | varchar(64) | Indicates the start time of the current DDL execution. |
STAGE_START_TIME | varchar(64) | Indicates the start time of the current stage. |
DDL_DURATION | varchar(64) | Indicates the time interval from the start of the current DDL execution to the current time point. |
STAGE_DURATION | varchar(64) | Indicates the time interval from the start of the current stage to the current time point. |
DDL_ERROR_CODE | int | If an exception occurs, the code of the current exception will be printed. Conversely, it is NULL. |
DDL_ERROR_TEXT | varchar(2048) | If an exception occurs, the textual message of the current exception will be printed. Otherwise, it is NULL. |
tdsql> SELECT * FROM information_schema.DDL_JOB_STAGE_INFO ORDER BY ddl_job_id\\G*************************** 1. row ***************************DDL_JOB_ID: 115CURRENT_STAGE_TYPE: NORMALCURRENT_STAGE_NAME: SetDDLJobStatusSuccCURRENT_STAGE_SOURCE: ddl_common.cc:725HISTORY_STAGE_INFOS: [161ms][RPC 18ms][CREATE TABLE DDL][2025-09-01 15:09:37 ~ RUNNING]├──> [OK ][25ms][RPC 1ms][START_DDL_JOB][start_ddl_job][ddl_worker.cc:994][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]├──> [RUN][135ms][RPC 17ms][CREATE_TABLE_NO_LOCK][mysql_create_table_no_lock][sql_table.cc:9993][2025-09-01 15:09:37 ~ RUNNING]├──> [RUN][135ms][RPC 17ms][CREATE_TABLE_IMPL][create_table_impl][sql_table.cc:9539][2025-09-01 15:09:37 ~ RUNNING]├──> [OK ][112ms][RPC 9ms][CREATE_DATA_OBJECTS_FOR_TABLE][CreateDataObjectsForTable][data_object.cc:2150][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]├──> [OK ][103ms][RPC 3ms][CREATE_DATA_OBJECT][CreateDataObjects][data_object.cc:1327][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]├──> [OK ][0ms][RPC 0ms][CREATE_AUTO_INC_FOR_TABLE][CreateAutoIncForTable][auto_inc_index.cc:247][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]├──> [OK ][5ms][RPC 4ms][CREATE_WRITE_FENCE_FOR_TABLE][CreateWriteFenceForTable][ddl_executer.cc:2480][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]├──> [OK ][5ms][RPC 4ms][CREATE_WRITE_FENCE][CreateWriteFence][ddl_executer.cc:1269][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]├──> [OK ][0ms][RPC 0ms][SET_DDL_JOB_STATUS_SUCCESS][SetDDLJobStatusSucc][ddl_common.cc:725][2025-09-01 15:09:37 ~ 2025-09-01 15:09:37]CURRENT_SQL_QUERY: CREATE TABLE sbtest85(id INTEGER NOT NULL,k INTEGER DEFAULT '0' NOT NULL,c CHAR(120) DEFAULT '' NOT NULL,pad CHAR(60) DEFAULT '' NOT NULL,PRIMARY KEY (id)) /*! ENGINE = rocksdb */DDL_START_TIME: 2025-09-01 15:09:37STAGE_START_TIME: 2025-09-01 15:09:37DDL_DURATION: 161msSTAGE_DURATION: 3msDDL_ERROR_CODE: NULLDDL_ERROR_TEXT: NULL
Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários