INFORMATION_SCHEMA.DDL_JOBS displays the status information of each DDL job.Field Name | Type | Description |
id | bigint unsigned | Unique ID of the DDL task. |
schema_name | varchar(64) | The schema name corresponding to the DDL job. |
table_name | varchar(64) | The table name corresponding to the DDL job. |
version | bigint | The version information corresponding to the DDL job. |
ddl_status | enum | execution status of the DDL job. FAIL: Failure. SUCCESS: Success. EXECUTING: is executing. |
start_timestamp | timestamp | The enablement time of the DDL job. |
last_timestamp | timestamp | The update time of the last DDL job. |
ddl_sql | longtext | DDL SQL. |
info_type | enum | type of DDL task. |
info | longtext | Log of essential information during DDL job execution. |
is_history | bool | Whether the DDL job has been completed. 1: Finished. 0: Not finished. |
tdsql> create table sbtest1 (id int primary key);tdsql> select * from information_Schema.ddl_jobs order by id desc limit 1\\G;*************************** 1. row ***************************ID: 2SCHEMA_NAME: tdsqlTABLE_NAME: sbtest1VERSION: 4DDL_STATUS: SUCCESSSTART_TIMESTAMP: 2025-06-24 15:00:35LAST_TIMESTAMP: 2025-06-24 15:00:35DDL_SQL: create table sbtest1 (id int primary key)INFO_TYPE: CREATE TABLEINFO: {"rm_idx":[],"wf_rmed":false,"exec_addr":{"ip":"10.10.10.10","port":15035},"row_apply_saved":true,"current_schema_name":"tdsql","ddl_with_complete_info":"","crt_data_obj_task_id":29372684622102841,"dstr_data_obj_task_id":0,"data_obj_to_be_dstr_arr":[],"tbl_tidxid":10028,"row_applied":false,"recov_addr":{"ip":"10.10.10.10","port":15035}}IS_HISTORY: 11 row in set (0.00 sec)
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