How to view the DDL jobs in TiDB?

by

You can use admin show ddl to view the current job of adding an index or the running DDL jobs.

As for viewing DDL jobs, you can also use two other commands as follows:

  • admin show ddl jobs: to view all the results in the current DDL job queue (including tasks that are running and waiting to run) and the last ten results in the completed DDL job queue
  • admin show ddl job queries 'job_id' [, 'job_id'] ...: to view the original SQL statement of the DDL task corresponding to the job_id; the job_id only searches the running DDL job and the last ten results in the DDL history job queue

More Related Contents:

  1. How does spring.jpa.hibernate.ddl-auto property exactly work in Spring?
  2. add column to mysql table if it does not exist
  3. How do you like your primary keys? [closed]
  4. What are DDL and DML?
  5. How to generate entire DDL of an Oracle schema (scriptable)?
  6. Can a number be used to name a MySQL table column?
  7. How to convert primary key from integer to serial?
  8. Safely rename tables using serial primary key columns
  9. Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?
  10. Delete column from SQLite table
  11. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  12. MySQL: ALTER TABLE if column not exists
  13. Sqlite primary key on multiple columns
  14. Adding multiple columns AFTER a specific column in MySQL
  15. Postgres manually alter sequence
  16. How do I add a foreign key to an existing SQLite table?
  17. Why use multiple columns as primary keys (composite primary key)
  18. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  19. Using ALTER to drop a column if it exists in MySQL
  20. How to get function parameter lists (so I can drop a function)
  21. Why can I create a table with PRIMARY KEY on a nullable column?
  22. DROP FUNCTION without knowing the number/type of parameters?
  23. How do I DROP a constraint from a sqlite (3.6.21) table?
  24. PostgreSQL create table if not exists
  25. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  26. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  27. Drop column from SQLite table
  28. ALTER TABLE without locking the table?
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment