PAUSE DDL命令可用于暂停当前状态为RUNNING或ROLLBACK_RUNNING的DDL任务。
语法
JOB_ID可通过SHOW DDL命令获取。
PAUSE DDL JOB_ID;示例
mysql> pause ddl 1359630950316638208; Query OK, 1 row affected (0.04 sec) -- 再次 mysql> show ddl\G; *************************** 1. row *************************** JOB_ID: 1359630950316638208 OBJECT_SCHEMA: d2 OBJECT_NAME: t1 ENGINE: DAG DDL_TYPE: CREATE_TABLE STATE: PAUSED PROGRESS: 0% START_TIME: 2021-08-04 14:02:19.781 END_TIME: 2021-08-04 14:02:35.276 ELAPSED_TIME(MS): 15495 PHY_PROCESS: BACKFILL_PROGRESS: 0% 1 row in set (0.02 sec)